View Single Post
  #2   Report Post  
Michael
 
Posts: n/a
Default

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.