General

aesthetics (how might I make it look pretty)
I have been developing a weekly planning system for my health care team (many thanks to all those who helped with my numerous programming issues during development) Its now near as damn it complete and im looking to make it look good! It comprises of 8 large boxes (ranges) or planning areas on a plain white bac... 3 Jul 2008 14:34

How to keep Column headers with Autofilter & Freeze Panes
I have a spreadsheet (Excel 2003) with which I use Autofilter a lot. I also freeze the panes just below the column headers (titles). With this in place, once I scroll down past the first page, my column headers disappear. I've tried putting in blank rows & moving the row on which I place the cursor when sett... 3 Jul 2008 17:40

quesiton on links
If I rename a directory or a workbook, are the links to other workbooks automatically updated or does the path get corrupted?? I have a number of workbooks that are linked and I want to duplicate the entire directory and rename the main workbook. thanks in advance for your time and consideration on this one. ... 3 Jul 2008 14:34

Negative hours [h]:mm:ss
How can I enter negative hours when formatted as [h]:mm:ss eg - 00:32:00 = 32 minutes Regards The Rook ... 3 Jul 2008 13:32

Template for tracking employee vacation, sick and personal time
Is anyone familair with an excel spreadsheet, or word document one could use to track employees vacation, sick and/or personal time? ... 3 Jul 2008 13:32

How do I copy excel file to a flash drive?
A simp;e question - I have an excel file that I want to transfer to a flash drive for back up purposes. I can't seem to find out or see in Excel how to do this??? ... 3 Jul 2008 11:28

How do I filter a cell to look for anything w/ text vs numbers?
I have a spreadsheet with data that has numbers and/or text. How do I filter out the data with only numbers? ... 3 Jul 2008 11:28

exitsing table copying into new workbook
I have spent weeks creating a table and it finally works. I need some help in conpying over the formulas from the test sheet I worked on into the real document. See below for a synopsis of what I did and what I need to do. I get a report with a bunch of data. Some I don't need. I am creating a macro to pare ... 3 Jul 2008 12:31

Conditional formula in Excel
I have an Excel spreadsheet which includes a calculation of annual mileage which I then need to convert into a cost. However, the rate of mileage depends on the amount of mileage, i.e. the first 10,000 miles at 40p, and mileage in excess of that at 25p. Currently I have =E9*0.40, however I need to have som... 3 Jul 2008 11:28

How to make a cents symbol in Excel 2007
I read a comment about using Alt + 0162 to make a cents symbol (c with a slash through it). But it was for Excel 2003. I tried it in Excel 2007 and just got beeps for an error. How do you do it in 2007? -- Scott in Salt Lake ... 3 Jul 2008 10:27