View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Youngblood
 
Posts: n/a
Default 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.