MS Excel

R

Ratman

I created a Excel spreadsheet with several different pages to it.

Unfortunately even though it only takes 35 lines on the page, while creating
it I accidentally hit a key that took me to page 65536. Now, even though
65501 lines are blank, it wants to print 2000 blank pages. How do I fix my
spreadsheet? I have tried deleting all the blank lines, but that doesn't
seem to do anything.
 
G

garfield-n-odie

The usual way to reset the last used cell in Excel is to delete
the unused rows at the bottom, delete the unused columns at the
right, save the worksheet, close the worksheet, and reopen the
worksheet. Alternatively, you can select the desired worksheet
area and click on File | Print Area | Set Print Area.
 
R

Ratman

Great! Thanks.

garfield-n-odie said:
The usual way to reset the last used cell in Excel is to delete
the unused rows at the bottom, delete the unused columns at the
right, save the worksheet, close the worksheet, and reopen the
worksheet. Alternatively, you can select the desired worksheet
area and click on File | Print Area | Set Print Area.
 

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