Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
If you want to exclude certain rows then select FILE then click on PAGE SETUP, then a dialouge box will appear, there will be 4 tabs, select the tab that says SHEET, and then direclty under that tab in the left hand side it will say "PRINT AREA" and then there will be like an area where you can enter something but at the end of that field to the right before the PRINT button is a "small icon" which you can click and then you can select the area or select multiple areas to print, (To Select multiple areas you choose one are and hold the "CTRL" button on ur keyboard and select more areas.you can click on a column/s to print that entire column, the same with the rows.) this way you can choose your areas to print. "Sarah" wrote: Hi there. I have a long document with +/- 400 rows of information, mostly text. I need to print the document and exclude/hide about 100 of those rows, based on their content. Is there some way to conditionally hide those rows instead of manually hiding each before I print them? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Area | Excel Discussion (Misc queries) | |||
add row to Print Area | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
Print Area | New Users to Excel |