Excel Attributes & Shortcuts

Excel shortcuts are key combinations that perform certain actions in Excel. Here are some of the most commonly used Excel shortcuts: 

1. Navigation Shortcuts:

   • Ctrl + Arrow Key: Moves to the edge of the current data region in a worksheet.

   • Ctrl + Home: Moves to the beginning of a worksheet.

   • Ctrl + End: Moves to the end of a worksheet.

2. Cell Selection Shortcuts:

   • Shift + Arrow Key: Extends the cell selection area in the direction of the arrow key.

   • Ctrl + Shift + Arrow Key: Extends the cell selection to the last non-blank cell in the same column or row as the active cell.

3. Data Entry and Editing Shortcuts:

   • Ctrl + D: Fills the cell beneath with the contents of the selected cell.

   • Ctrl + R: Fills the cell to the right with the contents of the selected cell.

   • F2: Edits the active cell and positions the insertion point at the end of the cell contents.

4. Formatting Shortcuts:

   • Ctrl + 1: Opens the Format Cells dialog box.

   • Ctrl + B: Applies or removes bold formatting.

   • Ctrl + I: Applies or removes italic formatting.

   • Ctrl + U: Applies or removes underlining.

5. Workbook and Worksheet Management Shortcuts:

   • Ctrl + N: Creates a new workbook.

   • Ctrl + O: Opens a workbook.

   • Ctrl + S: Saves a workbook.

   • Ctrl + P: Prints a worksheet or a workbook.

   • Ctrl + F: Opens the Find and Replace dialog box.