| Thread | Last Post | Replies |
|
| Changing sheets | 09 May 2005 14:21 GMT | 1 |
Is there a way to move between sheets of a workbook using keystrokes? (eg ALT plus Left or Right ARROW keys) Thanks David
|
| Relative/absolute cell references | 09 May 2005 14:19 GMT | 2 |
I have a formula, like for instance = A1*A3 I like to copy this, relatively, that is updating it to =A2*A4 and so on. The data is supposed to be in A1, A3 or A2, A4, but if the user moves the data from A1 to B1 the fomula is updated to =B1*A3.
|
| "Start import at row"-limit when importing text to worksheet | 09 May 2005 12:57 GMT | 3 |
I'm using Excel 2003 to do analyse large textfiles, to do this I regularly imports text to Excel, but unfortunately I've realized that there are some limitations when importing text files. I have a text file which has more that 65536 lines (which is the maximum row
|
| Excel 2002 Condition Formatting...cont | 09 May 2005 12:53 GMT | 1 |
Got it to work but will not work when referencing another sheet in the workbook.
|
| Header | 09 May 2005 12:32 GMT | 1 |
In word we have what is called: "Header rows repeat" for tables do we have such thing in Excel (I need this because i have a list of 200 rows with names phone birth date) I want to see the header when i print on each paper.
|
| Define Currency | 09 May 2005 01:22 GMT | 2 |
Using Excel 2000, when I click on currency button (formatting toolbar) I get the dollar symbol, however I want the symbol always to display as Euro. How do I make this the default currency value displayed? Regards & thanks,
|
| Does anyone know? | 09 May 2005 01:08 GMT | 4 |
We have just switched to Excel 2002. Does anyone know how I can get the "=" sign to remain in the toolbar instead of having to click the "Fx" every time to bring it up when I want to input a formula? The older excel was able to do this.
|
| Excel 2002 Condition Formating | 09 May 2005 00:15 GMT | 2 |
I am having a problem with conditional formating. I need to change the color of the numeric value to "red" if it is not equal to 490 or 500 or 510 or 520. Have tried various methods but not successful. All numbers in "each" cell turn red whether they are equal to the above ...
|
| Slow to open /close | 08 May 2005 22:29 GMT | 3 |
Just recently I am having problems with Excel, and the speed at which it opens and closes. It can take up to 20 seconds to close. Version is Excel 2000, OS is ME, 256 RAM, 1100 Mhz. All other programs seem normal, have no viruses or malware,
|
| Linking/connecting nine separate worksheets of a workbook | 08 May 2005 21:05 GMT | 3 |
Is there a way, after formatting nine separate sheets in a work book like sheet 1, sheet 2, sheet 3, etc., that I could connect or link these (I hope I am using the right words), so that if I change say the header on one sheet, the same change is automatically made on the other ...
|
| page numbering | 08 May 2005 21:00 GMT | 4 |
Please let me know the simplest way in Excel to automatically number pages like page 1 of 9, 2 of 9, 3 of 9, etc.? Also, in the future, if I delete a worksheet, then will the system know that it now needs to be 1 of 8, 2 of 8, 3 of 8, etc.?
|
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | 08 May 2005 20:11 GMT | 7 |
I wish to compare the cost of telephone calls between various telephone service providers available to me. I have downloaded a list of itemised call made by me from my present provider and I wish to compare the cost of each call if I had used
|
| Line graphs with many lines | 08 May 2005 18:44 GMT | 1 |
I am trying to figure out how to make a graph where I can have toe population as the y axis and the date as the x axis. The lines I want series a to be "2004" and b to be "2005". Anyone got any ideas?
|
| Calculation within a Cell | 08 May 2005 18:38 GMT | 2 |
I am trying to create cells that will make calculations for me. For example, I want to enter the number 140, and have the cell automatically make the calculation to 30 percent of that number. Any suggestions? Thanks.
|
| How do I unhide columns | 08 May 2005 18:29 GMT | 3 |
It's driving me crazy. I can't get columns to unhide after hiding them. I have to go to the "select all" and then drag the columns open. It said something in Help about a column going to zero. How do I stop that so the UNHIDE will work?
|