delete extra columns and rows

G

Guest

I have an excel worksheet.

Currently I'm only using 700+ rows and about 15 colums. However I could
scroll down to the 10 millionth row if I wanted. How do I get rid of all
those extra rows? Same problem with the cloumns. I basically want someone to
open up my file and see that there aren't an infinate number of rows yet to
be populated.

I found this macro that was supposed to delete all empty rows. it ran and
they were still there.
 
B

Bob Umlas

Excel ALWAYS has 65536 rows and 256 columns, and you can't change that no
matter what you do.
However, you can hide them.
use F5 (goto). and type 750:65536, press OK, then use Ctrl/9
then use F5, type P:IV, press OK, then use ctrl/0

Now the extraneous ones are hidden from view.
 

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

Similar Threads

I cannot delete the extra rows or columns in Excel 2007 2
Deleting unneeded rows and columns 1
Insert/ Delete rows of a protected worksheet. 3
copying some rows and columns 21
delete blank rows & colums 3
Easiest Way to Delete Rows 4
Cannot delete extra rows 5
extra rows and columns wouldn't show 2

Top