| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding rows on a sheet before printing
Hi all,
How would I go about hiding rows as a result of a blank in column A(there is a formula in columnA which gives a blank) and a 0 in column B, there is blank cells between 4/3/07 and 5/3/07. I would most likely only do this at the time of printing as the user does not see this sheet it is all auto filled from data on other sheets. The sheet is called Carlog. A B C D 1/3/07 0 0 2/3/07 0700 1526 8.26 3/3/07 0700 1526 8.26 4/3/07 0700 1526 8.26 5/3/07 0700 1526 8.26 6/3/07 0700 1526 8.26 thanks Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Hiding rows when printing | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Hiding rows before printing | Excel Discussion (Misc queries) | |||
Threaded Mode
