General

Is there a way to type in text and not have it print?
I would like to have text show on the screen but not when printed, sot of like defpoints in AutoCAD. Is there a way to do this in Excel? On a similar note, is there a way to print a cell or even the header or footer in gray scale or in draft? ... 14 Jan 2010 13:34

Is anybody experiencing problems within the community answers
Hi everybody, I wonder if somebody else is experiencing problems, I have been answering questions for the three past days and none of them had showed up. On Friday I was not able to see any new questions it was like nobody asked any question and then on Monday I saw all the questions from that friday ... 13 Jan 2010 10:58

cell styles
I've discorvered its all to do with the size of excel window. eg enlarge or maximise excel window, and behold! the cell styles you seek will appear. kodered wrote: on the home tab, there is a button called "cell styles" click on this andthey 07-Dec-09 on the home tab, there is a button called "cell style... 13 Jan 2010 07:38

Conditionally formatting text and numbers differently
I am trying to do conditional formatting on cells in Excel 2007 such that if they contain numeric data, they will be formatted in one font, style, and size, and if they contain text (e.g. "Out of range"), another combination. The nearest I can find is to format specific text, but even when I enter the possible ... 13 Jan 2010 08:44

Data Validation List (Drop Down) Not Showing
I have a validation with drop down list in it but the drop down is not showing. I can go into the cells with the validation and it shows that it is set up to be a validation with list. The source of the list is correct. The drop down worked at one point but now it doesn't. Did I format the cells in a way th... 13 Jan 2010 17:47

Why is the font tab missing from Format Control box?
I'm trying to set up option buttons in my excel file, but I cannot find a way to change the font of the text in the option button. In the excel help page it says to select the control, right click, select the Format Control button, then select the "Font" tab. For some reason... I'm not finding this "Font" tab. ... 12 Jan 2010 20:48

FORM ENTRY OUTSIDE OF RANGE SPECIFIED
I am trying to set up some data entry by using the form button, but in trying to enter data in the middle of the worksheet I get a message saying "the command could not be completed by using the range specified. Select a single cell within the range and try the command again". Any ideas or help would be appreci... 12 Jan 2010 16:20

worksheet skipped in page numbering
I have an Excel document with 10 worksheets (tabs). I went to set up footers and my options from the drop down were page 1 for first tab, page 2 for second tab, etc. until I got to the 5th tab and it went back to page 1. Tab 6 gives me dropdown options for page 5 - in short, it is like it skipped a worksheet... 12 Jan 2010 15:13

Multiple columns into single row
I have multiple columns : 1 2 3 4 1 2 3 4 1 2 3 4 .... And I want to paste into a single row: 1 2 3 4 1 2 3 4 1 2 3 4..... Transpose does not do it. Any suggestions? Thanks ... 12 Jan 2010 18:35

Making a Excel file Read Only
We need to have our shared file to be read only. The problem we have been having is, if suzy opens the file before we do, we cannot edit the file. So this is what we also need. Suzy cannot open the file before us, or if she does we can still edit the file. Suzy cannot edit the file at all. She must only be abl... 14 Jan 2010 01:28