Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows before printing
I have a large spreadsheet where the user needs to fill in quantities in
column A. The cells in column A contain 0 and have a green background color if "empty". When completed the value becomes 0 and background color red. Only certain rows (less than 30 %) are completed that way. I want to print only rows that have been filled out. however the rows have to stay in exactly the same sequence. My idea was to automatically hide all the rows that have 0 in cell A before printing. Can somebody help me to get this thing right? Thanks, Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows before printing
Hi
see: http://www.rondebruin.nl/print.htm#Hide -- Regards Frank Kabel Frankfurt, Germany Daniel VanEygen wrote: I have a large spreadsheet where the user needs to fill in quantities in column A. The cells in column A contain 0 and have a green background color if "empty". When completed the value becomes 0 and background color red. Only certain rows (less than 30 %) are completed that way. I want to print only rows that have been filled out. however the rows have to stay in exactly the same sequence. My idea was to automatically hide all the rows that have 0 in cell A before printing. Can somebody help me to get this thing right? Thanks, Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows before printing
MULTIPOST answered in OFFICENLEXCEL -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Daniel VanEygen wrote : I have a large spreadsheet where the user needs to fill in quantities in column A. The cells in column A contain 0 and have a green background color if "empty". When completed the value becomes 0 and background color red. Only certain rows (less than 30 %) are completed that way. I want to print only rows that have been filled out. however the rows have to stay in exactly the same sequence. My idea was to automatically hide all the rows that have 0 in cell A before printing. Can somebody help me to get this thing right? Thanks, Daniel |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows before printing
keepITcool wrote:
MULTIPOST answered in OFFICENLEXCEL -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam Keep, Is it multiposting when you post 2 messages in 2 different languages? :-D OTOH, in the 21 minutes between his first post and his second post here in mpep, he already had 2 replies in mpnoe! -- To top-post is human, to bottom-post and snip is sublime. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows before printing
Amai Amedee. gij ook hier, Zulle!
his tough luck that with XanaNews I can monitor groups much more efficiently... -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Amedee Van Gasse wrote : Keep, Is it multiposting when you post 2 messages in 2 different languages? :-D OTOH, in the 21 minutes between his first post and his second post here in mpep, he already had 2 replies in mpnoe! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide row before printing | Excel Discussion (Misc queries) | |||
How can i auto hide empty rows in printing in excel? | Excel Discussion (Misc queries) | |||
Hide/Unhide rows for printing | Excel Discussion (Misc queries) | |||
Hide rows but show when printing | Excel Discussion (Misc queries) | |||
Hide Empty Rows When Printing | Excel Worksheet Functions |