Excel, how to reset the "last used cell on the worksheet "

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I often use the keyboard shortcut control-shift-end in Excel to highlight all
my data, but if I have deleted rows or columns from the original data this
still goes to the original bottom right cell, so it includes blank cells I no
longer want. How do you re-set the last used cell to be at the end of the
data and exclude the blanks?
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Error message "cannot shift nonblank cells off the worksheet" 2
Changing position of last used cell 4
Excel-how do I reset the cell to which I go with a Control End? 1
Range to Last Cell 1
"Last cell" in Excel 2003 is way past end of data, how do i fix? 11
CTRL+SHIFT+END extends selection of cells to last - how reset? 9
How To Have A Cell Be Blank If... 2

Back
Top