| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show zero values only when data is entered in other fields
I am currently working on a spreadsheet that contains min. information but
will expand over time. I have formatted a column for number and would like the zero value to show only in fields where there is other information showing (all the rest of the rows should show no zeros. I also found that because I applied conditional formatting to one of the columns from row 2-2000, when I want to print the whole spreadsheet rows 1-2000 are selected to print (pages 1-56) not just the page(s) with data on them. How do I get it to auto select only the rows with data. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show values of data points in a chart with the mouse poin | Charts and Charting in Excel | |||
| function to show if two fields in a column have the same data. | Excel Worksheet Functions | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Threaded Mode
