General

Removing Duplicates from multiple worksheets
Hi I need to remove duplicates from multiple wotrksheets and then give me the results in one final worksheet. ... 5 Feb 2010 12:51

Column vs Row Size Ratio?
Excel2003 ... For Cells to be perfectly square ... What is the Col Width to Row Height Ratio I would use? Thanks ... Kha ... 5 Feb 2010 13:58

Shared workbook-header not working
I have a shared workbook in which the header holds the date. When changing months, the headers work for me but no one else sharing! Should I turn off sharing, change headers, then turn back on? I cannot find a setting to fix this Thanks ... 9 Feb 2010 15:10

Place numbers in ascending order
I have 2 columns as follows: A B Number Correct Order 1 3 5 6 2 I need to display the numbers from column A in ascending order in column B, WITHOUT using the sort function! Any tips please! -- Its easier to learn thing than pretend you know it ... 5 Feb 2010 10:33

change XL2003 autofilter's arrow color
"SMT" wrote: "BK" wrote: how can i change the XL2003 autofilter's arrow color from blue (when active) to red or another color? the current dark blue is hard to distinguish from the black (inactive) color making it difficult to visually distinguish when a filter is active. ... 5 Feb 2010 07:13

Flag 'Filter on' for the user
This may help but it is limited as it advises if any filtered columns on a worksheet are in action Apply the formula to a cell outside the any of your filtered columns. A5:A45 is the sample so change to suit your range. =IF(COUNTA(A5:A45)=SUBTOTAL(3,A5:A45),"NO","YES") You can Conditional Format the cell to tur... 5 Feb 2010 07:13

File Open: No Preview Available...why please?
When selecting File Open, and the property choices are [Thumbnails, Icons, List, Preview, etc.], why does the Preview option state 'No Preview Available'? Even if the Spreadsheet has been created, named, and saved already (and is being retrieved) there is no preview available? ... 5 Feb 2010 02:52

Macro or Look-up?
Hello I am trying to update a worksheet to make it more efficient and easier to use. I would like one point of data entry for the final user, 'hide' the main formula worksheet, and then just have the printable, user-friendly formatted report sheet. I know a little about macros (but not so much in relation ... 4 Feb 2010 21:24

How to keep the print output colour setting for the same file?
I have two Excel files saved in a network drive. And I access the files in two different servers in a separate location. I have no problem printing both the files with the correct setting (especially the print output colour) that I saved with the files using one of the servers. However, when I try to print the... 4 Feb 2010 19:08

Backup Files in Excel 2007
I am using Excel 2007. Everytime I open an Excel file and save it to my desktop - it creates a backup file on my desktop. I have read the other postings and I don't see anywhere where i can turn this feature off! any help appreciated. ... 4 Feb 2010 19:08