Buzz
1. How to Edit Within Cells Using Keyboard Shortcuts
Shift + Left Arrow/Shift + Right Arrow: Select or deselect a character to the left/right of the cell.Ctrl + Shift + Left Arrow/Ctrl + Shift + Right Arrow: Select or deselect a word to the left/right of the cell.Shift + Home/Shift + End: Select from the cursor to the beginning/end of the line.
2. How to Use Undo / Redo Shortcuts
Ctrl + Z: Undo the previous action (multiple levels).Ctrl + Y: Redo the next action (multiple levels).
3. How to Work with Clipboard Using Shortcuts
Ctrl + C: Copy the content of the selected cell.Ctrl + X: Cut the content of the selected cell.Ctrl + V: Paste the previously copied or cut content into the selected cell.
4. How to Edit Within Cells Using Keyboard Shortcuts
F2: Edit the selected cell with the cursor positioned at the end of the line.Alt + Enter: Insert a line break within the same cell.Enter: Complete editing the cell and move to the cell below.
Shift + Enter: Complete editing the cell and move to the cell above.Tab/Shift + Tab: Complete editing the cell and move to the cell on the right/left.Esc: Cancel editing in a cell.Backspace: Delete the character to the left of the cursor.Delete: Delete the character to the right of the cursor.
5. How to Edit Active or Selected Cells Using Keyboard Shortcuts
Ctrl + D: Copy the content of the cell above.Ctrl + R: Copy the content of the cell below.Shift + F2: Insert/edit a cell comment.Shift + F10, then press M: Delete a comment.Alt + F1: Create and insert a chart with the current data range.F11: Create and insert a chart in a separate chart sheet with the current data range.Ctrl + K: Insert a hyperlink.
6. How to Format Cells Using Keyboard Shortcuts
Ctrl + 1: Open the Format dialog box.Ctrl + B: Apply or remove bold formatting.Ctrl + I: Apply or remove italic formatting.Ctrl + U: Apply or remove underline formatting.Ctrl + 5: Apply or remove strikethrough formatting.
7. How to Format Numbers Using Keyboard Shortcuts
Ctrl + Shift + $: Apply currency format with two decimal places.Ctrl + Shift + ~: Apply the General number format.Ctrl + Shift + #: Apply date format: Day/Month/Year.Ctrl + Shift + @: Apply time format with hours, minutes, and AM/PM indication.Ctrl + Shift + ^: Apply scientific number format with two decimal places.
8. How to Navigate Through a Spreadsheet Using Keyboard Shortcuts
Arrow Keys: Move up, down, left, or right within a spreadsheet.Page Down/Page Up: Jump to the top or bottom of the spreadsheet.Tab/Shift + Tab: Move one cell right/left within the sheet.Home: Move to the first cell of a row.Ctrl + Home: Jump to the first cell of the entire spreadsheet.Ctrl + End: Move to the last cell containing data.Ctrl + F: Open the Find and Replace dialog (with the Find tab open by default).Ctrl + H: Open the Find and Replace dialog (with the Replace tab open by default).Ctrl + G: Open the Go To dialog.Alt + Down Arrow: Show the AutoComplete list.
9. How to Select Cells Using Keyboard Shortcuts
Shift + Space: Select the entire row.Ctrl + A: Select the entire worksheet area (or the areas containing data).Ctrl + Shift + Page Up/Page Down: Select the current sheet and the previous (or next) sheet within the same file.Shift + Page Down/Shift + Page Up: Extend the selection to the bottom/top of the current page.Shift + Home: Extend the selection to the first cell of the spreadsheet (top-left corner).Ctrl + Shift + Home: Extend the selection to the last used cell in the spreadsheet (bottom-right corner).
10. How to Manage Selections Using Keyboard Shortcuts
Shift + F8: Add a range of cells to the selection (either contiguous or non-contiguous). Use the arrow keys or Shift + arrow keys to expand the selection.Enter/Shift + Enter: Move the current cell down/up within the selected range.Tab/Shift + Tab: Move the current cell right/left within the selected range.
