Welcome to the eighth post of this series. Hope you are enjoying this series. Click here to read to navigate to go to special.
Select Last cell. Cell that has data and / or formatting. This is one of those most used excel option people often use.
If the data is within the visible range we can simply select the cell using a mouse. This is not the case most of the times as we would be working on worksheets with more than 10,000 rows? 25,000 rows? Or more? And you want to move to the last cell of the worksheet for any reason! Here is when this option comes handy.
Traditional way of this is go to Special, Click on Last cell. You will automatically be placed in the last cell of the worksheet that has data or formatting. But, who has the time to go to special and do all the selection. Hence keyboard shortcut below.
Keyboard Shortcut:
Ctrl+End.
Just an additional keyboard shortcut I thought would go well with the above one. To select the range from the active cell to the last cell. Ctrl+Shift+End
Share your experience:
Hope you are enjoying this series.
Do you use these options more often? Share your experiences. Have another tip do this stuff? Also, do not forget to leave your comments on this post. I learn a lot from you all. I’ll be posting soon, nineth post of this series “Go to Special – Select Visible cells only”.
Links related to this series:
No comments:
Post a Comment