Prev: Calculating total amount in a Pivot Table
Next: MS Excel 2003 - Advanced Features Add-In
From: ajr81 on 4 Mar 2010 10:15
This is kind of hard to explain, but here it goes. Let's say I start with a
spreadsheet that has 10,000 rows of data. Then I decide to delete 3,000 of
these rows. When I use the scroll bar to go to the bottom of the
spreadsheet, it takes me to row 10,000. Or, if I use control + end, it goes
to row 10,000 as well. Is there a way to "reset" the scroll bar to now know
that the bottom of the data is row 7,000? I know I could just copy it into a
new spreadsheet. But I am just curious. The same can be asked about deleted
columns too. Thank you.
From: Dave Peterson on 4 Mar 2010 10:31
Visit Debra Dalgleish's site:
http://contextures.com/xlfaqApp.html#Unused

ajr81 wrote:
>
> This is kind of hard to explain, but here it goes. Let's say I start with a
> spreadsheet that has 10,000 rows of data. Then I decide to delete 3,000 of
> these rows. When I use the scroll bar to go to the bottom of the
> spreadsheet, it takes me to row 10,000. Or, if I use control + end, it goes
> to row 10,000 as well. Is there a way to "reset" the scroll bar to now know
> that the bottom of the data is row 7,000? I know I could just copy it into a
> new spreadsheet. But I am just curious. The same can be asked about deleted
> columns too. Thank you.

--

Dave Peterson
From: Daryl S on 4 Mar 2010 10:53
Ajr81 -

Usually saving the spreadsheet will do the trick, as long as the blank
columns/rows were deleted (not just the contents).

--
Daryl S


"ajr81" wrote:

> This is kind of hard to explain, but here it goes. Let's say I start with a
> spreadsheet that has 10,000 rows of data. Then I decide to delete 3,000 of
> these rows. When I use the scroll bar to go to the bottom of the
> spreadsheet, it takes me to row 10,000. Or, if I use control + end, it goes
> to row 10,000 as well. Is there a way to "reset" the scroll bar to now know
> that the bottom of the data is row 7,000? I know I could just copy it into a
> new spreadsheet. But I am just curious. The same can be asked about deleted
> columns too. Thank you.
 | 
Pages: 1
Prev: Calculating total amount in a Pivot Table
Next: MS Excel 2003 - Advanced Features Add-In