delete page within a worksheet - How?

P

pjsatz

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Does anyone know how to delete all the extra pages of rows an columns that show up in excel within a worksheet?

I don't know if these are extra pages but when I scroll down or to the right, it just continues adding them forever.

I don't want to to set a print area.

I want to delete the extra sheets.

Phil
 
C

CyberTaz

The size of an Excel worksheet is fixed - you cannot remove the unused
columns & rows. Their presence has no bearing on printing, though. Only
those parts of the worksheet having content generate pages when you print.
 
P

pjonesCET

If you want to show only the columns you have information in one page (vertically and or Horizontally) dependent on whether your information extend beyond one page or not. go to page setup and click on Margins
 you will see a window as shown in this Screenshot:
http://screencast.com/t/YTZjZWUy

click on Horizontal, vertical or both then set margins to the smallest that the printer acn print that you need to show all your info on one page. for my printer its .25 left and right and .50 for top and bottom (if you dont use header and footers. if you use header and foot then it will be 1 top and bottom (.50 for margin and .50 for header/footer)
 
P

pjonesCET

Also if the information is not too large amount that could fit on one page also check *fit to one page*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top