This is an incredibly easy and simple tip and an Excel navigation shortcut that I quite honestly had no idea existed until just recently. I’ve always used Ctrl + left/right/down/up arrow to quickly get to the top/bottom of my current columns or start/end of my current row. That being said this tip is great if you are a heavy mouse user and just love to click things- so here it is. When you are on any cell, you can double click the top/left/bottom/right of your cell to get literally to the beginning or end of that row or column. You need to make sure that you have the 4 point cursor available when hovering over either of the sides of your cell. Here is a quick gif image to show you how this works. Note that the image below is only showing you how to navigate from top to bottom (and from bottom to top) of a column but you can you with the left or right hand sides of the cell to go to the beginning of the row or to the end of the row.
I hope you enjoy this tip as much as I did and I already forget where I came across this but it could be a life changer for some of you and I hope it is.
Until the next time!
Other Great Excel Shortcut Resources
- Excel Shortcuts: Use Alt + = to Automatically Sum Cells
- Excel Shortcuts: Build A Quick Weekday Date List in Excel
- Excel Shortcut: Using Alt + Shift + Right Arrow To Group Your Pivot Table Fields
- Excel Shortcut: Copy Formulas and/or Formatting to Multiple Sheets at Once – How to Identify Highest Sales For Each Country