General

Making Zeros look like no entry
I have a spreadsheet that makes some calculation in a column, based on multiplying numbers entered in 2 other columns. However, for some of the rows, there is no "input" data, and so the calculation simply indicates the answer is zero. This gives me a column with lots of zero's in the cells. I'd prefer there si... 28 Mar 2010 07:54

Customizing the Display of Data in an Excel Cell
Hi gurus. I would like to have the cells in my spreadsheet do something automatically, if that is possible: I would like there to be some space between the text in a cell and the lower border of the cell, even if there is only one line of text. This woud be kind of like what you have in Word, where you can set... 28 Mar 2010 04:40

selecting a cell
I seem unable to select a single cell, or a single row--click on one in the normal manner, and the two below also highlight, then delete or whatever command is given. If I input a number/text, that just goes into the one cell. tapping F8 increases this to two wide and three high automatically selected. Also... 27 Mar 2010 17:42

Double click to send cell to another app?
I have NO clue how this is done, or even if it is an excel command... But I have a spreadsheet that work has sent me that if I double click on any cell in the A column, it captures that cell data and sends it to another window then does an Enter command. I have looked all through the spreadsheet and I can't f... 29 Mar 2010 11:23

Select specific location in spreadsheet
I have a menu set up for a user to get information based on a choice from a drop down list. The event macro will go to a specific location based on the choice. The location is in the same worksheet but I have a split window - so the information to display is on the right while the menu is still on the left. R... 27 Mar 2010 16:33

printer paper will not advance
When printing the paper will not advance properly and the text prints on top of the previous lines ... 27 Mar 2010 13:09

tab in a cell
Hi, How can I put a tab in a cell?. If I press the tab key, the control goes to the next cell. Thanks! ... 27 Mar 2010 09:40

counting identical items in a column and returning the occurre
That did it. Thanks much. "Huber57" wrote: Try this: In C1 (to count the zeros) =COUNTIF($A$1:$A$701,"0") In C2 (to count the 1s): =COUNTIF($A$1:$A$701,"1") etc. Hope that helps. If it does, rate it has helpful at the bottom of the post. "ExcelWizardImNot" wro... 27 Mar 2010 05:34

How to reduce size of ms excel file-2003
I am usung excel 2003. A file containing 6000 records and 85 columns and used formula in each cell becomes a larger size and dificult in saivng. It takes more time. some time error occures "memory not enough". Is there any solution in excel 2003? ... 27 Mar 2010 09:40

Counting Days
Hello - I'm trying to figure out a formula that tells me the number of days until a date or tells me how many days have passed since the date. Meaning, if today is 01/01/10 and my target date is 01/05/10, I would like the formula to return "-5". If today is 01/10/10 and my target date was 01/05/10, I woul... 27 Mar 2010 01:11