How To Set Page Size In Excel
- #2
Hi bulla,
Start, go to File > Folio Setup. On the Folio tab select the Fit To scaling choice and select 1 pages broad by ane pages tall. Then select A4 in the Paper Size dropdown.
This will prepare these properties for the workbook until you lot change them.
Damon
bulla
New Member
- Joined
- Dec three, 2007
- Messages
- 5
- #iii
Thanks Damon - thank you a LOT.
But one matter I really want to practise is really LIMIT the size of the worksheet - so when you await at it it's simply the size of an A4 folio.
ie. there are NO columns beneath or to the right of the worksheet........
Know what I mean?
i've only seen this washed once ....
Practice you know how I can do this?
Thank you.....
Domski
Well-known Fellow member
- Joined
- Jan 18, 2005
- Messages
- 7,292
- #4
Howdy,
You can hide rows and columns by either selecting the whole row or column and then correct clicking and selecting hibernate or by using the Format menu which means you don't demand to to select the whole row/cavalcade you wish to hide only just a cell within.
You could then protect the worksheet to prevent people unhiding them.
Dom
bulla
New Member
- Joined
- December 3, 2007
- Messages
- 5
- #5
thanks but i might have described it incorrectly......
An excel worksheet is infinite in it'due south width and acme. Information technology can go on forever.
Now imagine an A4 slice of newspaper.
I want my worksheet to simply exist a finite size. I only desire it to be the size of a sheet of newspaper. I don't desire it to go on infinitely.
Is this possible?
Domski
Well-known Fellow member
- Joined
- January xviii, 2005
- Messages
- 7,292
- #6
Hide the columns and rows as I described and and so in File...Page Setup select it to fit on 1 page wide past 1 page tall.
Should practice the trick.
bulla
New Member
- Joined
- Dec three, 2007
- Messages
- v
- #seven
Cheers once again ..... well, some skillful news and some bad news!!!
Adept - I've been able to totally hide the columns ACROSS the folio considering it didn't take as well long to highlight all the columns etc.
And this is EXACTLY what I wanted to do.
But the ROWS .... I can't do information technology......... using the "page downwards" keyboard button I got down to row 30,000 and in that location was no sign that I was going near the bottom of the spreadsheet.
Plainly I'grand missing something here........
Can you help so I tin can "delete" the rows nether row l .......
thank you Domski - much appreciated
Domski
Well-known Member
- Joined
- January 18, 2005
- Messages
- 7,292
- #8
There are 65536 rows on a standard excel worksheet prior to Excel 2007 where it'southward over a one thousand thousand.
Click on the first row that yous desire to hide (if you click the row number it will select the whole row. Now press Ctrl+Shift and the down pointer primal.
Once selected you should be able to hide them easily.
bulla
New Member
- Joined
- Dec three, 2007
- Messages
- 5
- #9
cheers thank you thank you thank y'all thanks !!!!!!!
This is exactly what I wanted to know! I knew there was a shortcut, simply I hadn't used it in years and years ....
Thats bully .....thanks Domski! 
Source: https://www.mrexcel.com/board/threads/how-do-i-create-a-worksheet-of-a-fixed-size.291870/
0 Response to "How To Set Page Size In Excel"
Post a Comment