Microsoft Excel is a powerful application for spreadsheet processing and an indispensable tool widely used around the world to run businesses to personal finance. Whether you’re an Excel power user or an everyday user, we have put together 25 Excel keyboard shortcuts to make your spreadsheet processing easy.
- Ctrl + A: Select the entire workspace.
- Ctrl + C: This will copy the selected data.
- Ctrl + V: This will paste the data you copied.
- Ctrl + x: cut the selected data.
- Ctrl + B: apply (on/off) bold formatting.
- Ctrl + I: Apply (on/off) italics formatting.
- Ctrl + U: Apply (on/Off) underline formatting.
- Ctrl + F: Find text or formatting within the current workbook.
- Ctrl + H: Find and replace text or formatting within the current workbook.
- Ctrl + Home: Highlight from the current cell back to column A of the row.
- Ctrl + 1: Format Cells dialog box.
- Ctrl + K: Insert hyperlink.
- Ctrl + G: Go to a specific field.
- F2: Edit current Cell.
- F7: Spell check.
- F11: Create a chart from current data.
- Ctrl + End: This will take you to the last cell of your data.
- Ctrl + Home: Similar to the Ctrl + End, but this will take you to the first cell of your data.
- Ctrl + Up Arrow: will take you to the first cell of your active column.
- Ctrl + Down Arrow: will take you to the last cell of your active column.
- Ctrl + Space bar: Will select current column.
- Shift + Space: will select row(s) of your active cell(s).
- Ctrl + Minus sign: Will give you the Delete dialog box.
- Ctrl + Shift + Home: Highlights from the current cell back to A1.
- Ctrl + Shift + End: Highlights from the current cell to the last cell.
No comments:
Post a Comment