Рет қаралды 13,131
Enter - Moves the active cell down by default. The default can be changed to up, left, right or no movement.
Home - Moves the active cell in the worksheet to the left most visible cell in the worksheet within the same row.
Page Down - Moves the active cell cursor and screen one full page down.
Page Up - Moves the active cell cursor and screen one full page up.
Alt + Page Down - To move one full screen to the right in the worksheet.
Alt + Page Up - To move one full screen to the left in the worksheet.
Ctrl + Back Space - Scrolls to the active cell if it’s not in the visible window.
Ctrl + Up (Down, Left, Right) - Move to the upper (lower, left, right) most part of the current data region.
Ctrl + End - Move to the lower right most used cell in the worksheet.
Ctrl + Home - Move to the upper left most cell in the worksheet.
Ctrl + Page Down - Move to the next worksheet in the workbook.
Ctrl + Page Up - Move to the previous worksheet in the workbook.
F6 - Move focus to the next pane in a workbook.
Shift + F6 - Move focus to the previous pane in a workbook.
Ctrl + Tab - Switch between the current workbook and the last active workbook.
Ctrl + Shift + Tab - Switch between all open Excel workbooks.
* Most navigation short cuts also work as selection shortcuts by also holding shift during shortcut execution. 👇
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: howtoexcelblog
Twitter: howtoexcelblog
LinkedIn: www.linkedin.com/in/john-macdougall/
Thanks for all your support!