ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Because of row/column deletions, how do you reset the last cell? (https://www.excelbanter.com/excel-discussion-misc-queries/78236-because-row-column-deletions-how-do-you-reset-last-cell.html)

AndreaW

Because of row/column deletions, how do you reset the last cell?
 
Selecting: Ctrl, End
This takes me to the last cell PRIOR to row and column deletions. How do
you RESET the last cell AFTER row and column deletions?

AndreaW

Because of row/column deletions, how do you reset the last cell?
 
Never mind ... found it!

"AndreaW" wrote:

Selecting: Ctrl, End
This takes me to the last cell PRIOR to row and column deletions. How do
you RESET the last cell AFTER row and column deletions?


Dave Peterson

Because of row/column deletions, how do you reset the last cell?
 
Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

AndreaW wrote:

Selecting: Ctrl, End
This takes me to the last cell PRIOR to row and column deletions. How do
you RESET the last cell AFTER row and column deletions?


--

Dave Peterson

Patricia Shannon

Because of row/column deletions, how do you reset the last cel
 
I sometimes have to do a "Save As" to itself

"Dave Peterson" wrote:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

AndreaW wrote:

Selecting: Ctrl, End
This takes me to the last cell PRIOR to row and column deletions. How do
you RESET the last cell AFTER row and column deletions?


--

Dave Peterson



All times are GMT +1. The time now is 10:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com