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 07:07 AM
Excel Web Page Printing ClinicITguy1 Excel Discussion (Misc queries) 0 December 31st 04 06:15 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 11:49 PM
How do I stop automatic page breaks in excel Lesley Hutchinson Excel Worksheet Functions 0 October 31st 04 01:49 PM


All times are GMT +1. The time now is 08:12 AM.

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

About Us

"It's about Microsoft Excel"