General

Select a formula / range from Excel drop down suggestions
As we enter a formula in a cell, Excel finds matches of what is being written comparing it to (all) formulas and ranges of the current workbook and displays them in a drop down box just beneath the cell. Can someone please tell me if there is a key combination that inserts the currently selected list item in the... 12 Feb 2010 16:52

Auto Filter Sorting Issue
I have a large spread sheet and frequently use the auto filter capabilities. My rows are getting out of sequence (the data is not staying in the correct row). I've marked cells and then tested by sorting different columns ascending, desending, etc. and I've done this on multiple columns. I can not get the da... 12 Feb 2010 12:21

unique name list
Excel 2003. I have a list of 40 names. I would like to randomly select names without repeat until all 40 names have been selected. Any ideas please. ... 13 Feb 2010 02:49

Fill colour
Hi, I have SUM formula in one of the cell. For Example I have a formula in cell# A1. And the formula is A52+A54+A84+A95+A96+B101+B105+C96+D201 etc., by holding the F2 button in cell#A1 I can see all precedents of this cell. I wanted to fill the colours in these cells by holidng F2 Button. but its not allowin... 12 Feb 2010 02:14

Precedent Cell
Hi, I have SUM formula in one of the cell. For Example I have a formula in cell# A1. And the formula is A52+A54+A84+A95+A96+B101+B105+C96+D201 etc., by holding the F2 button in cell#A1 I can see all precedents of this cell. I wanted to fill the colours in these cells by holidng F2 Button. but its not allowin... 12 Feb 2010 08:56

HYPERLINK IN A NEW WINDOW
When a hyperlink opens the spreadsheet minimizes. I wish to view the spreadsheet and the hyperlinked web window in the same screen, as a permanent default mode. (am using Excel 2000, not a expert) ... 11 Feb 2010 19:38

file browsing - autocomplete
Hi - I had my hard disk crash and just got a new computer. One feature that is no longer works on the new one is an autocomplete feature when I'm browsing for a file to open within excel. for example, if I started typing "C:\my documents", as soon as I typed "C:\m", the rest of the text would autopopulate. ... 12 Feb 2010 07:51

Conditional Formatting based on Non Blank Cells
I have a form for users to fill out and I only want them to fill out one of three categories. So if they type something in one category I want the other two categories to grey out. How can I do that? ... 11 Feb 2010 19:38

help with sorting
I have an excel spreasheet that I am trying to sort. Some rows are highlighted, some are not. When I select the rows I want to sort, my highlights end up in some of the rows that were not previously highlighted and some of the non-highlighted rows end up with highlights. It is not consistent. It ends up wit... 12 Feb 2010 02:14

Print Preview in 2007
I have sheet with several charts and tables. Page breaks are set. To get the Print Preview to look correct I have to offset the Charts (some overlap the page breaks and some typing). How can I get the Print Preview to look the same as the sheet looks like in normal mode? ... 11 Feb 2010 17:22