Excel-Adding Extra Cells

S

Sunny46

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

How do I get Excel to print off extra columns, rows, etc. when I go to print? It only prints what I have entered in the cells but nothing more. I want it to print out the rest of the page with blank rows, columns, etc., where I have not typed. I have gotten this to work in Excel one other time but don't remember how I did it! Thanks!
 
C

CyberTaz

One option: Select the range of cells you want to print then go to File>
Print Area> Set Print Area. In order to have the grid lines print you'll
have to use either File> Page Setup - Sheet & tick the Gridlines checkbox or
apply Borders to the empty cells.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
S

Sunny46

Bob,
Thank you so much for the directions. It worked perfectly and I've got gridlines on the entire sheet now.

Sunny
 

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