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

G

Guest

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

Excel Cannot delete empty cells/rows 4
Re-setting lat row or end of data 1
How to specify a range from arbitrary cell and to "end of worksheet" 5
"Last cell" in Excel 2003 is way past end of data, how do i fix? 11
Different "end" on different sheets 2
How do I delete blank rows (rows alternate data, blank, data, etc 2
How do I copy a range in Excel without including hidden rows? 1
Macro that deletes rows from cell containing End to end of data. 2

Top