How do I get rid of blank rows between data and Ctrl End result?
 

Using Excel 2002; I am subtotaling and removing subtotals from data. After I
remove subtotals and hit Ctrl End, I am at a cell that is several blank rows
from the end of my rows of data. How can I cause my Ctrl End function to go
to the last cell in ss that contains data?

Thank you. I am a new subtotal user.

How do I get rid of blank rows between data and Ctrl End result?
 

Try one of the fixes at Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Wed, 19 Apr 2006 13:27:02 -0700, Youngblood
wrote:

Using Excel 2002; I am subtotaling and removing subtotals from data. After I
remove subtotals and hit Ctrl End, I am at a cell that is several blank rows
from the end of my rows of data. How can I cause my Ctrl End function to go
to the last cell in ss that contains data?

Thank you. I am a new subtotal user.

How do I get rid of blank rows between data and Ctrl End resul
 

Thank you, Gord. DD's Site had the fix!

"Gord Dibben" wrote:

Try one of the fixes at Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Wed, 19 Apr 2006 13:27:02 -0700, Youngblood
wrote:

Using Excel 2002; I am subtotaling and removing subtotals from data. After I
remove subtotals and hit Ctrl End, I am at a cell that is several blank rows
from the end of my rows of data. How can I cause my Ctrl End function to go
to the last cell in ss that contains data?

Thank you. I am a new subtotal user.