| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I avoid fields being automatically filled in by default?
How do I avoid fields being automatically filled in by default? For example,
the formula for C1 is: =SUM(A1-B1) If nothing is yet entered in A1 or B1, then C1 is given the value "0" I would like it to remain blank as a default. Thanks again for your help Jason |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I avoid fields being automatically filled in by default?
Jason,
Go to: Tools Options, specifically the "View" tab Make sure the "Zero values" checkbox is deselected. That should take care of it. Steph "jason" wrote: How do I avoid fields being automatically filled in by default? For example, the formula for C1 is: =SUM(A1-B1) If nothing is yet entered in A1 or B1, then C1 is given the value "0" I would like it to remain blank as a default. Thanks again for your help Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel macro to automatically change default printer | Excel Discussion (Misc queries) | |||
| change default chart settings for new excel charts automatically | Charts and Charting in Excel | |||
| Setting and KEEPING the default chart | Charts and Charting in Excel | |||
| Excel template to load automatically as the default template? | Excel Discussion (Misc queries) | |||
| Excel Forms - text fields decompressing font automatically | Excel Discussion (Misc queries) | |||
Linear Mode
