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

Y

Youngblood

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.
 

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

Getting Text data using the Data - Subtotal feature 1
Macro Pause to Select range then Subtotal 0
Subtotals including blank rows 0
Totalling columns & inserting blank row afterwards 0
Deleting blank rows 5
need help in fine-tuning a formula that removes blank cells in a column range 3
reverse pasting rows with alternate blank cells 0
How do I copy a range in Excel without including hidden rows? 1

Top