G
Guest
Somehow I've ended up at 65000 rows in a Sheet. How can I delete the unwanted rows (all aprt from 50), as it is making the document size huge!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JulieD
Hi
all worksheets have a fix dimension of 256 columns & 65000 rows and you
can't do anything about it - however, you can make them not appear in the
scroll bar (what i mean is that instead of the vertical scroll button being
very very very small because excel's reading the whole worksheet as "active"
you can make only your used area "active") -
the easiest way i've found to achieve this is to
1. right mouse click on a sheet tab and choose view / code
2. choose view / intermediate window from the menu
3. copy & paste the following line in
activesheet.usedrange
4. press enter
5. close the vb window (top right hand cross)
Cheers
JulieD
all worksheets have a fix dimension of 256 columns & 65000 rows and you
can't do anything about it - however, you can make them not appear in the
scroll bar (what i mean is that instead of the vertical scroll button being
very very very small because excel's reading the whole worksheet as "active"
you can make only your used area "active") -
the easiest way i've found to achieve this is to
1. right mouse click on a sheet tab and choose view / code
2. choose view / intermediate window from the menu
3. copy & paste the following line in
activesheet.usedrange
4. press enter
5. close the vb window (top right hand cross)
Cheers
JulieD
unwanted rows (all aprt from 50), as it is making the document size huge!needhelp said:Somehow I've ended up at 65000 rows in a Sheet. How can I delete the
G
Guest
Sounds like exactly what I need!
I can't get it to work. Am in Visual Basic Intermediate view, type in activesheet.usedrange, press enter, then exit back to worksheet but nothing's changed....
I can't get it to work. Am in Visual Basic Intermediate view, type in activesheet.usedrange, press enter, then exit back to worksheet but nothing's changed....
J
Jim Rech
You may have formatting in the rows that appear unused. Select and clear
the unused rows:
-Press F5 to open the Go To window
-Enter "51:65536" (no quotes) as the Reference and click OK
-Use Edit, Clear, All.
Now Save your workbook. After the save the used range is usually adjusted.
--
Jim Rech
Excel MVP
| Sounds like exactly what I need!
| I can't get it to work. Am in Visual Basic Intermediate view, type in
activesheet.usedrange, press enter, then exit back to worksheet but
nothing's changed....
|
| "JulieD" wrote:
|
| > Hi
| >
| > all worksheets have a fix dimension of 256 columns & 65000 rows and you
| > can't do anything about it - however, you can make them not appear in
the
| > scroll bar (what i mean is that instead of the vertical scroll button
being
| > very very very small because excel's reading the whole worksheet as
"active"
| > you can make only your used area "active") -
| > the easiest way i've found to achieve this is to
| > 1. right mouse click on a sheet tab and choose view / code
| > 2. choose view / intermediate window from the menu
| > 3. copy & paste the following line in
| > activesheet.usedrange
| > 4. press enter
| > 5. close the vb window (top right hand cross)
| >
| > Cheers
| > JulieD
| >
| > | > > Somehow I've ended up at 65000 rows in a Sheet. How can I delete the
| > unwanted rows (all aprt from 50), as it is making the document size
huge!
| > >
| >
| >
| >
the unused rows:
-Press F5 to open the Go To window
-Enter "51:65536" (no quotes) as the Reference and click OK
-Use Edit, Clear, All.
Now Save your workbook. After the save the used range is usually adjusted.
--
Jim Rech
Excel MVP
| Sounds like exactly what I need!
| I can't get it to work. Am in Visual Basic Intermediate view, type in
activesheet.usedrange, press enter, then exit back to worksheet but
nothing's changed....
|
| "JulieD" wrote:
|
| > Hi
| >
| > all worksheets have a fix dimension of 256 columns & 65000 rows and you
| > can't do anything about it - however, you can make them not appear in
the
| > scroll bar (what i mean is that instead of the vertical scroll button
being
| > very very very small because excel's reading the whole worksheet as
"active"
| > you can make only your used area "active") -
| > the easiest way i've found to achieve this is to
| > 1. right mouse click on a sheet tab and choose view / code
| > 2. choose view / intermediate window from the menu
| > 3. copy & paste the following line in
| > activesheet.usedrange
| > 4. press enter
| > 5. close the vb window (top right hand cross)
| >
| > Cheers
| > JulieD
| >
| > | > > Somehow I've ended up at 65000 rows in a Sheet. How can I delete the
| > unwanted rows (all aprt from 50), as it is making the document size
huge!
| > >
| >
| >
| >
L
Lady Layla
Hi
Use Ctrl + End to get to the last "used" cell --- most likely this is blank
Then find your actual last cell used.
Once you find that, go to the row directly below the last row, hold the shift
key down, and end + arrow down to get to the last row (65k), Right click,
delete, delete entire row. Go back to the last cell and do the same with the
columns (but delete entire column) all the way to the right (IV) column.
Save your file and your last cell should be the last actual cell you have data
in
: Somehow I've ended up at 65000 rows in a Sheet. How can I delete the unwanted
rows (all aprt from 50), as it is making the document size huge!
:
Use Ctrl + End to get to the last "used" cell --- most likely this is blank
Then find your actual last cell used.
Once you find that, go to the row directly below the last row, hold the shift
key down, and end + arrow down to get to the last row (65k), Right click,
delete, delete entire row. Go back to the last cell and do the same with the
columns (but delete entire column) all the way to the right (IV) column.
Save your file and your last cell should be the last actual cell you have data
in
: Somehow I've ended up at 65000 rows in a Sheet. How can I delete the unwanted
rows (all aprt from 50), as it is making the document size huge!
: