| Thread | Last Post | Replies |
|
| Worksheet tab names | 15 Sep 2005 21:22 GMT | 4 |
Is there a way to reference a cell inside a worksheet to tell me th name of the worksheet? I have say 6 different worksheets in a file named Sales,Costs,etc and when I print the worksheets I want cell A1 t disply the worksheet name
|
| Cells that move with the rest of the worksheet | 15 Sep 2005 21:06 GMT | 5 |
How do you do this? I know it is possible from when I took a class in Excel, but I can't remember how to do it.
|
| Take Rows from Sheet1 and use as headers on Sheet2 - SheetN | 15 Sep 2005 20:58 GMT | 1 |
I have 10 rows on sheet 1 that users fill in. I'd like those 10 rows to be the top lines printed on all subsequent sheets. Is this possible? How? Thanks in advance.
|
| Find and replace according to conversion table | 15 Sep 2005 20:54 GMT | 5 |
I have a question about automating find and replace for text data. I havetbe replacements I want to take place. Instances of A1 should be replaced with the value in B1, A2 with B2, and so on. There are several thousand entries. How can I use this information to do a
|
| User defined formula - concatenate range | 15 Sep 2005 20:51 GMT | 4 |
I apologize if this is too lengthy. I am using a User defined formula to take a range of values in the workbook and concatenate them into one long string value . I also want them to be separated by commas. Example (real data is much larger):
|
| Retrieve deleted excel document | 15 Sep 2005 20:25 GMT | 2 |
Is there a way to retrieve a spreadsheet that have been overwritten? Thanks
|
| Drawing Lines | 15 Sep 2005 19:53 GMT | 2 |
Is there an easy way to draw lines around a range of cells where you can specify to draw the line on the top, bottom, left or right side of the range? Thanks.
|
| Help! | 15 Sep 2005 19:51 GMT | 2 |
Thanks for your help in advance. I am trying to figure out a way that inside the same spreadsheet you can have different column width sizes. Is there a way to divide the spreadsheet to allow this to happen?
|
| Form Colors on a form change on a laptop pc | 15 Sep 2005 19:31 GMT | 2 |
When one of our users prints his Expense Report (an Excel form), it prints in blue ink and he would like it changed to black. Previously, the color of the lines was set to automatic. I changed the color to black and it still prints blue for him. Is there a setting on his pc ...
|
| how to limit cell data & (masks) | 15 Sep 2005 19:26 GMT | 3 |
how do you set the number of characters for input on a certain cell o column i knew this at one point, but when u don't use it, unfortunatly u loos it...
|
| Export each sheets as a CSV files | 15 Sep 2005 19:04 GMT | 1 |
I would like to save all the sheets in a workbook to MS-DOS CSV files. It would be nice if I could export only the selected sheets but that not really required. Is there a free addin that will allow me to do that or maybe a macro?
|
| Unwanted formating (excel 2000) | 15 Sep 2005 18:56 GMT | 5 |
We have to import a file (CSV) where data in a column is in "999:99" or "99:99" format. For unknown to me reason the built in logic treats that data as Time and Excel converts some data in this column into wrong format.
|
| how do I get a formula to not show the amount but still be there | 15 Sep 2005 18:52 GMT | 2 |
I need to have a formula entered but I do not want the zero to show
|
| Sorting Column | 15 Sep 2005 18:27 GMT | 2 |
:confused: Exporting tags from Autocad I end up with my first colum containin data such as A6r ....A35r & A6 ......A55, how can I sort this column i accending order by the number only, ignoring the letters....??????
|
| Automatically Add Rows | 15 Sep 2005 18:23 GMT | 1 |
Is it possible to have Excel automatically add rows, ideally a new row each month? I know you can use dynamic ranges to increase the range each month, but I'd like it to "physically" add a row in addition to this, so that I don't have to manually insert a row every month.
|