Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am working on sheet and have 20 rows.
I want the 20 rows to take up a full A4 page. |
#2
![]() |
|||
|
|||
![]()
Hi
Depending on what data is in the 20 rows, eg lots of text, small numbers, etc. A couple of otions a 1. Go to Page setup and Select Fit to 1 page wide & 1 page Tall. 2. Change the page orientation to Landscape if there is a lot in each row. 3. Highlight the row headers 1 to 20 by clicking on row Header and then Hold down Shift and click on row 20 header. When these are highlighted, put your cursor in the row headers between any two rows and when it turns into a double sided arrow drag the rows until they are a little wider. Have a look at print preview and see how they look. repaet until satisfied. Remember though, the minute you add more rows or data, this process may have to be repeated. HTH Michael "Sillygoose" wrote: I am working on sheet and have 20 rows. I want the 20 rows to take up a full A4 page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
make first few rows print on every page? | New Users to Excel | |||
Excel Web Page Printing | Excel Discussion (Misc queries) | |||
excel 2003 page numbering | Excel Worksheet Functions | |||
How do I stop automatic page breaks in excel | Excel Worksheet Functions |