Why do I get ##### instead of the sum?
Well, then how do I fit something to one page wide?
I need to determine the difference between two times. If the difference is positive, it works fine. But excel does not want to display negative time values. Why not?
I find that sometimes my formulas do not get fully calculated. This often happens when I use custom functions created with visual basic?
How can I change the color of the sheet tabs?
In excel, how can I prevent a row from printing in a range if certain cells in a particular column equal 0. I do not want to extract the records to another section of thesheet. Is it possible to hide those rows, then print, then unhide?
I have a range of time values, but when I try to sum them, the total is never greater than 24 hours?
I am trying to open files called "excel 97 templates" with my excel for windows 95, version 7.0. I get the message: "(filename).xls: file format is not valid". Whatgives? Is the "excel 97" saved file just unreadable by my version?
How can I enter the current date into a cell so it does not change from day to day? When I use the now function, it always shows the current date?
How can I show the complete path and filename in the excel title bar?
When I apply fill colour to a cell, I can not see it on the worksheet. However, the colour shows up in print preview, or when I print the worksheet. Whats wrong?
Is there a way to set up a toolbar button in excel to access page setup?
How can I print a workbooks full path in the header or footer? The page setup dialog box does not seem to offer the option.?
Ihave been working with downloaded data and pasting a years worth at a time into a "template" that I want all the resulting spreadsheets to look like. Each years datahas approximately the same amount of data in it. Seems each spreadsheet is taking more and more space as I work on them? Any ideas what I have done?
I am using excel and I want to print only the bottom of the worksheet. There is not an option to do this in the print dialog box. How can this be done?