This section highlights the most useful actions to work efficiently. It focuses on navigating sheets, organizing and updating data, applying formatting, and managing information effectively. These core shortcuts and routines help you work faster, keep your sheets organized, and maintain a consistent workflow across devices.
Navigation and search
Use the search shortcut as your baseline “where is it?” command when scanning large sheets. Open the Tool Finder shortcut to type a command name and execute it. A practical routine: find first, then refine. Use Find/Replace shortcut for quick cleanup, and Tool Finder for commands you don’t want to hunt in menus.
Filters
For fast data review, learn to work with filters using Tool Finder. You can access filtered cell menus entirely from the keyboard. This approach keeps the action purely keyboard-driven and consistent across devices.
Cells
Use the Tool Finder to execute commands like merge cells quickly, avoiding menu hunting and staying consistent across browsers.
Rows
Row operations are high-frequency in cleanup and tracking sheets. The reliable pattern is: select the row first, then use Insert/Delete Row shortcuts. Direct shortcuts are usually faster than menu options.
Formatting
For spreadsheet readability, formatting hotkeys are best learned as “small tools” you apply repeatedly: Bold, Underline, Clear Formatting, and Borders. When you need fill colors specifically, use the Tool Finder shortcut. Regular use improves clarity and keeps your sheets organized.