If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
delete extra columns and rows
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. |
#2
|
|||
|
|||
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. "matt charlton" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete columns or rows | Ivor Williams | Worksheet Functions | 2 | June 3rd, 2005 11:16 PM |
how do i delete the extra empty rows and columns that i dont need. | lindaY | General Discussion | 3 | March 20th, 2005 03:48 PM |
How to delete extraneous rows and columns | Bruce Gray | General Discussion | 5 | February 26th, 2005 05:30 PM |
Delete Empty Rows & Columns | Dawn | General Discussion | 1 | September 2nd, 2004 01:33 PM |
"Extra" Rows and Columns | Shane | Charts and Charting | 2 | May 7th, 2004 11:47 AM |