Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sillygoose
 
Posts: n/a
Default I want 20 rows in excel to take up full A4 page

I am working on sheet and have 20 rows.
I want the 20 rows to take up a full A4 page.

  #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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel "slide up" rows with content thru empty rows to condense portly44 Excel Worksheet Functions 2 April 1st 05 12:47 AM
make first few rows print on every page? CD New Users to Excel 3 January 3rd 05 06:07 AM
Excel Web Page Printing ClinicITguy1 Excel Discussion (Misc queries) 0 December 31st 04 05:15 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM
How do I stop automatic page breaks in excel Lesley Hutchinson Excel Worksheet Functions 0 October 31st 04 12:49 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"