Getting rid of empty areas of a workbook

steve_e

New Member
Joined
Nov 10, 2005
Messages
6
Hi -
Apologies, I'm sure this is very basic but I don't seem to be able to phrase the question in the right way to get an answer to the help documentation...

I have been sent a file with 5 sheets in it - very short in terms of content. But when I go to print it, it comes up with 80 or so pages, most of them empty. When I click the page break preview, it seems to be listing lots of pages below the content in each sheet.

I can't find a way to stop Excel from wanting to print these apparently 'empty' areas of the spreadsheet. Can anyone help?

Regards, Steve.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Try resetting the print area: Print>Print Area>Set Print Area just on the cells you want to print.

Richard
 

steve_e

New Member
Joined
Nov 10, 2005
Messages
6
Sorry Richard -
I'm on Excel 2000 and can't see a print area option. Would that be a later version feature?

Also, I want it to print a number of different sheets, just a smaller area on each sheet.

Thanks for your reply!

Regards, Steve.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,496
Office Version
  1. 365
Platform
  1. Windows
steve_e

Welcome to the Mr Excel board!

If you don't want to be restricted to a particular print Area, another thing worth trying is to go to the bottom of the data, click and drag down a few hundred/thousand rows. It only takes a second if you pull the mouse right down to the bottom of the screen (I think Excel has 5 scroll speeds as you pull the mouse further off the screen).

Then go Edit|Delete|Entire Row|OK
Save the sheet and try a Print Preview to see if this has changed the result.

Another thing to look for along the lines of Parsnip's answer is that the sheets may already have a (large) Print Area set. Try File|Print Area|Clear Print Area.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,496
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

steve_e said:
Sorry Richard -
I'm on Excel 2000 and can't see a print area option. Would that be a later version feature?

Also, I want it to print a number of different sheets, just a smaller area on each sheet.

Thanks for your reply!

Regards, Steve.
I think Parsnip meant File>Print Area>Set Print Area
 

SiddersAtCHEP

Board Regular
Joined
Nov 2, 2005
Messages
104
Try looking at File -->Print area -->Set Print Area. Otherwise, I am sure that 2000 has a button which does this although it may not be on the toolbars by default. Right click anywhere on the toolbar area, choose Customize, select the Commands tab, select File category and scroll down the right panel until you see Set print area. Left click and hold to drag the icon up to the toolbar and (I suggest) place it next to the Print icon.
 

steve_e

New Member
Joined
Nov 10, 2005
Messages
6

ADVERTISEMENT

Found it - thanks to you all!

One further question, if you have time. When you set print area, does it 'remember' this area for different sheets? So if I have 5 different tabs for the workbook, can I set a print area for each one, then print the entire workbook and have it print only the areas I'd previously set (if that makes sense)?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,553
Messages
5,636,989
Members
416,953
Latest member
broexc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top