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?
When I click on an excel file to open it, the file opens but an error message is displayed that says a file with that name is already open and that I can not open twofiles open with the same name?
I am using microsoft excel 7.0 running under windows 95. I am using formulas to subtract time. If the resulting time is a negative number, the result displays aspound signs. How can I fix this?
What is freeze panes and how do I do it?