Deleting rows below my data

[Troy]

I have some worksheets that have used 380 rows but the
scroll bar on some of the sheets go down to appx 1900
rows, so when I send it to my web you can scroll down a
long blank page after my data. Can I remove the blank
area?

 

[Peo Sjoblom]

Select everything to the right and below your data, while select do
edit>delete
Save the workbook.

 

[Ron de Bruin]

Hi Troy

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it

 

[Don Guillett]

Sure, just highlight the empty rows, using the row numbers bar>right
click>delete>SAVE>
use ctrl+end to test

 

[Guest]

Troy
Generally, when you save, close, and reopen the workbook, the scroll
bar resets to match the used area. First, make sure rows below 380
really are empty by deleting all rows from 381 down to 65536.

Regards,
Tom McNamara



----- Troy wrote: -----

I have some worksheets that have used 380 rows but the
scroll bar on some of the sheets go down to appx 1900
rows, so when I send it to my web you can scroll down a
long blank page after my data. Can I remove the blank
area?