{"id":2291,"date":"2026-10-01T10:48:58","date_gmt":"2026-10-01T10:48:58","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?page_id=2291"},"modified":"2026-10-31T12:13:30","modified_gmt":"2026-10-31T12:13:30","slug":"keyboard-shortcuts-fast-navigation","status":"publish","type":"page","link":"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/navigating-efficiently-in-worksheets\/keyboard-shortcuts-fast-navigation\/","title":{"rendered":"Keyboard shortcuts for fast navigation"},"content":{"rendered":"
\n
\n
\n
\n
\n\t\t\t\t\t\t[addtoany]<\/p>\n

Keyboard shortcuts<\/h1>\n

Moving around and selecting in a worksheet with a lot of data can feel laborious and time-consuming. Fortunately, there are smart keyboard shortcuts that make it easier. Being able to navigate tables efficiently is important, for example, when copying, writing functions and when finding and replacing. With the following keyboard shortcuts you can quickly select a column, a row or a table:<\/p>\n

\"Basic<\/p>\n

Ctrl+arrow key<\/strong>: activates the last non-empty cell in the direction of the arrow<\/p>\n

Shift+arrow key<\/strong>: selects one cell in the direction of the arrow<\/p>\n

Ctrl+Shift+arrow key<\/strong>: selects all cells between the cell where you were and the last non-empty cell in that direction<\/p>\n

What is efficient in small tables is laborious in large tables<\/h2>\n

The following way of moving to the last cell in a list is efficient if the list is short but laborious if the list is long:<\/p>\n