Microsoft Excel Navigation Tips

Microsoft Excel Navigation Tips

Navigation

In addition to the Shift + Arrow key method described above; Excel also has a couple of convenient functions for selecting larger areas of the spreadsheet. Shift + Space selects an entire row, while Ctrl + Space selects an entire column.

Ctrl + Shift + Down/Up Arrow

This extends the selection of cells to the last non-blank cell in the same column or row as the active cell. If the next cell is blank, the selection is extended to the next non-blank cell.

Ctrl + Arrows

Navigate to the bottom, top, left corner, or right corner of the current data region, depending on which arrow you press. Meanwhile, if you have several sheets in your workbook, Ctrl + Page Down/Page Up will move to the next sheet or previous sheet in your workbook respectively. 

Cell values

Pressing F2 will edit the active cell that you have selected, positioning the insertion point at the end of the cell’s contents. If editing in that cell is turned off, this shortcut will move the insertion point into the Formula Bar. Esc will cancel the entry in the cell or Formula Bar, as well as exiting any dialog box that may be open.

Formulas

 If you’re working with formulas, Ctrl +’ is a quick way to copy the formula from the cell above, while Ctrl + Shift +” will copy the value from the cell above without copying the formula.




    • Related Articles

    • Microsoft Word Keyboard Shortcuts

      Keyboard Shortcut Basics – General: Some shortcuts will work wherever you are in the Microsoft universe, whether you’re in an Office program or a web browser. Although the examples given are for Windows, most of these also work on Mac if the control ...

    • Microsoft 365-A More Inclusive, Seamless Working Environment

      NEWSLETTER This month, new features are added across Microsoft 365 to improve accessibility, support flexible workstyles, streamline routine tasks, and offer more ways to make your voice heard. Also launching new capabilities in Windows 11 and ...

    • How To Sync Outlook Contacts in Mobile

      How To Sync Outlook Contacts The steps in this guide may vary between operating systems and devices. Check that access to Contacts is allowed for Outlook before proceeding with the sync setup. Sync Outlook Contacts to Android To sync Outlook contacts ...

    • Multifactor authentication Number Matching Feature-Latest

      Multifactor authentication Number Matching Feature Beginning May 8, 2023, number matching is enabled for all Authenticator push notifications. As relevant services deploy, users worldwide who are enabled for Authenticator push notifications will ...