.png)
Elevate your spreadsheet efficiency with keyboard shortcuts tailored for seamless data management and quick navigation. With just a few keystrokes, you can format cells, create formulas, navigate between sheets, and perform essential tasks like copy, paste, and autofillโno mouse needed. These shortcuts help streamline your workflow, reduce repetitive actions, and keep your hands on the keyboard for a faster, more focused experience.
๐๐ผ๐น๐ฑ: `Ctrl + B` ย
ย Apply bold formatting to the selected cells. ย
โ
๐๐๐ฎ๐น๐ถ๐ฐ: `Ctrl + I` ย
ย Apply italic formatting to the selected cells. ย
โ
๐จ๐ป๐ฑ๐ฒ๐ฟ๐น๐ถ๐ป๐ฒ: `Ctrl + U` ย
ย Apply underline formatting to the selected cells.
โ
๐๐ผ๐ฝ๐: `Ctrl + C` ย
ย Copy the selected cells to the clipboard. ย
โ
๐ฃ๐ฎ๐๐๐ฒ: `Ctrl + V` ย
ย Paste the copied content into the selected cells. ย
๐ฃ๐ฎ๐๐๐ฒ ๐ฉ๐ฎ๐น๐๐ฒ๐ ๐ข๐ป๐น๐: `Ctrl + Shift + V` ย
ย Paste only the values (without formatting) into the selected cells. ย
๐๐น๐ฒ๐ฎ๐ฟ ๐๐น๐ถ๐ฝ๐ฏ๐ผ๐ฎ๐ฟ๐ฑ: `Escape` (when a cell is copied) ย
ย Clear the current clipboard content.
๐๐ฒ๐น๐ฒ๐๐ฒ ๐๐ฒ๐น๐น ๐๐ผ๐ป๐๐ฒ๐ป๐๐: 'Delete' or 'Backspace'
ย Delete the contents of the selected cells. ย
๐๐น๐ฒ๐ฎ๐ฟ ๐๐ฒ๐น๐น ๐๐ผ๐ฟ๐บ๐ฎ๐๐๐ถ๐ป๐ด: `Ctrl + \` ย
ย Remove all formatting from the selected cells.
๐ ๐ผ๐๐ฒ ๐ฆ๐ฒ๐น๐ฒ๐ฐ๐๐ถ๐ผ๐ป: `Arrow Keys` ย
ย Navigate between cells in the worksheet. ย
๐ฆ๐ฒ๐น๐ฒ๐ฐ๐ ๐๐น๐น ๐๐ฒ๐น๐น๐: 'Ctrl +ย A'
ย Select all cells in the current sheet. ย
๐ก๐ฒ๐
๐ ๐๐ฒ๐น๐น: `Tab` ย
ย Move to the cell to the right. ย
๐ก๐ฒ๐
๐ ๐ฅ๐ผ๐: `Enter` ย
ย Move to the cell below.
๐จ๐ป๐ฑ๐ผ* `Ctrl + Z` ย
ย Undo the last action. ย
๐ฅ๐ฒ๐ฑ๐ผ: `Ctrl + Y` ย
ย Redo the last undone action.
๐ข๐ฝ๐ฒ๐ป ๐๐ถ๐ป๐ฑ ๐๐ถ๐ฎ๐น๐ผ๐ด: `Ctrl + F` ย
ย Open the Find dialog to search within the sheet. ย
๐ข๐ฝ๐ฒ๐ป ๐๐ถ๐ป๐ฑ ๐ฎ๐ป๐ฑ ๐ฅ๐ฒ๐ฝ๐น๐ฎ๐ฐ๐ฒ ๐๐ถ๐ฎ๐น๐ผ๐ด: `Ctrl + H` ย
ย Open the Find and Replace dialog. ย
๐๐น๐ผ๐๐ฒ ๐๐ถ๐ป๐ฑ/๐ฅ๐ฒ๐ฝ๐น๐ฎ๐ฐ๐ฒ ๐๐ถ๐ฎ๐น๐ผ๐ด: `Escape` ย
ย Close the Find or Find and Replace dialog.
๐ฆ๐๐ฎ๐ฟ๐ ๐๐ฑ๐ถ๐๐ถ๐ป๐ด ๐๐ฒ๐น๐น: (Type any printable character) ย
ย Begin editing the selected cell. ย
๐๐ผ๐ป๐ณ๐ถ๐ฟ๐บ ๐๐ฒ๐น๐น ๐๐ป๐๐ฟ๐: `Enter` ย
ย Confirm the data entry in a cell and move down. ย
๐๐ผ๐ป๐ณ๐ถ๐ฟ๐บ ๐๐ฒ๐น๐น ๐๐ป๐๐ฟ๐ ๐ฎ๐ป๐ฑ ๐ ๐ผ๐๐ฒ ๐ฅ๐ถ๐ด๐ต๐: 'Tab'
ย Confirm the data entry in a cell and move to the right. ย
๐๐ฎ๐ป๐ฐ๐ฒ๐น ๐๐ฒ๐น๐น ๐๐ป๐๐ฟ๐: 'Escape'
ย Cancel the current cell edit and revert to the original content. ย
๐๐๐๐ผ๐ฐ๐ผ๐บ๐ฝ๐น๐ฒ๐๐ฒ ๐ฆ๐๐ด๐ด๐ฒ๐๐๐ถ๐ผ๐ป: `Tab` (when autocomplete is active) ย
ย Accept the autocomplete suggestion while editing a formula.
ย
๐ง๐ผ๐ด๐ด๐น๐ฒ ๐๐ฑ๐ถ๐ ๐ ๐ผ๐ฑ๐ฒ: `F2`
ย When editing a formula, you can toggle edit mode with F2. Edit mode means arrow keys will navigate the text of the formula bar instead of selecting an input cell. ย
๐ฆ๐ฒ๐ ๐ ๐ฎ๐ป๐๐ฎ๐น ๐๐ผ๐ป๐ ๐ฆ๐ถ๐๐ฒ: `Enter` (when editing font size) ย
ย Apply the manually entered font size.
๐๐น๐ฒ๐ฎ๐ฟ ๐๐๐ฟ๐ฟ๐ฒ๐ป๐ ๐๐ฐ๐๐ถ๐ผ๐ป: 'Escape'
ย Exit the current mode or dialog and return focus to the sheet. ย
๐ฃ๐ฒ๐ฟ๐ณ๐ผ๐ฟ๐บ ๐๐ฐ๐๐ถ๐ผ๐ป ๐ถ๐ป ๐ฆ๐ถ๐ฑ๐ฒ๐ฏ๐ฎ๐ฟ: `Enter` (when sidebar is focused) ย
ย Execute the default action for the selected item in the sidebar.
Notes:
โข ๐ฃ๐ฟ๐ถ๐ป๐๐ฎ๐ฏ๐น๐ฒ ๐๐ต๐ฎ๐ฟ๐ฎ๐ฐ๐๐ฒ๐ฟ๐: Pressing any printable character key (letters, numbers, symbols) while a cell is selected will start editing that cell. ย
โข ๐๐ผ๐ป๐๐ฒ๐
๐-๐ฆ๐ฒ๐ป๐๐ถ๐๐ถ๐๐ฒ ๐๐ฐ๐๐ถ๐ผ๐ป๐: Some shortcuts behave differently depending on the current focus (e.g., cell input, sheet, dialog). For example, pressing `Escape` will close dialogs or cancel actions based on where your focus is. ย
โข ๐ ๐ฎ๐ฐ ๐จ๐๐ฒ๐ฟs: Use the `Command` key (`โ`) instead of `Ctrl` for all shortcuts.
.png)