Printing Excel sheets

[Maarten]

Hi,

On my Excel sheet I have only 10 rows in use, but for some reason the totaal sheet on my screen is
about 1000 rows, from which 990 are empty.

But what's worse, when I print the sheet I get 1000 rows paper output, in stead of 10 rows.

How can I get rid of all these empty rows. Not only for printing but also on my screen.

Some help would be nice !

Thanks !

 

[Bill Ridgeway]

This problem is caused when a spread sheet which had say, 1000 columns by
1000 rows is reduced by deleting columns and rows. For some reason deleting
columns and rows doesn't remove the internal flag of the position of the
last column / row.

To remove this problem -

go to the lowest right-hand cell. Highlight everything to the right of that
and click on <Edit><Delete>

go to the lowest right-hand cell. Highlight everything below that (at least
1000) and click on <Edit><Delete>

Save the file

Regards.

Bill Ridgeway
Computer Solutions

 

[Dave Peterson]

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

 

[Steve Hawkins]

Another quick way to 'lose' such problems for which the cause is not
immediately apparent, is simply to highlight the part of the sheet you want
(with its headers) and copy and paste it as a new sheet. This is also handy
to get rid of any old distracting column/cell border formatting that I find
tends to build up below the in use part of a sheet as it is gradually
modified.

Steve_H

 

[Jay Benton]

Hi,

On my Excel sheet I have only 10 rows in use, but for some reason the totaal sheet on my screen is
about 1000 rows, from which 990 are empty.

But what's worse, when I print the sheet I get 1000 rows paper output, in stead of 10 rows.

How can I get rid of all these empty rows. Not only for printing but also on my screen.

Some help would be nice !

Thanks !

If you are only wanting to print the data that you have entered, then
just take your mouse and highlight all of the affected rows and
columns and then goto "files" scroll down to "Print Area" and select
"Set Print Area". That should solve your dilema.