Excel භාවිතා කරන ඔබ සදහා වැදගත් shortcut keys

       Excel shortcut keys

Ctrl+N: Create a new workbook

Ctrl+O: Open an existing workbook

Ctrl+S: Save a workbook

F12: Open the Save As dialogue box

Ctrl+W: Close a workbook

Ctrl+F4: Close Excel

F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font colour, clicking another cell and pressing F4 repeats that action in the new cell.

Shift+F11: Insert a new worksheet

Ctrl+Z: Undo an action

Ctrl+Y: Redo an action

Ctrl+F2: Switch to Print Preview

F1: Open the Help pane

Alt+Q: Go to the “Tell me what you want to do” box

F7: Check the spelling

F9: Calculate all worksheets in all open workbooks

Shift+F9: Calculate active worksheets

Alt or F10: Turnkey tips on or off

Ctrl+F1: Show or hide the ribbon

Ctrl+Shift+U: Expand or collapse the formula bar

Ctrl+F9: Minimize the workbook window

F11: Create a bar chart based on selected data (on a separate sheet)

Alt+F1: Create an embedded bar chart based on select data (same sheet)

Ctrl+F: Search in a spreadsheet, or use Find and Replace

Alt+F: Open the File tab menu

Alt+H: Go to the Home tab

Alt+N: Open the Insert tab

Alt+P: Go to the Page Layout tab

Alt+M: Go to the Formulas tab

Alt+A: Go to the Data tab

Alt+R: Go to the Review tab

Alt+W: Go to the View tab

Alt+X: Go to the Add-ins tab

Alt+Y: Go to the Help tab

Ctrl+Tab: Switch between open workbooks

Shift+F3: Insert a function

Alt+F8: Create, run, edit, or delete a macro

Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Left/Right Arrow: Move one cell to the left or right

Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row

Up/Down Arrow: Move one cell up or down

Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column

Tab: Go to the next cell

Shift+Tab: Go to the previous cell

Ctrl+End: Go to the most bottom right used cell

F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.

Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)

Ctrl+Home: Move to the beginning of a worksheet

Page Up/Down: Move one screen up or down in a worksheet

Alt+Page Up/Down: Move one screen to the right or left in a worksheet

Ctrl+Page Up/Down: Move to the previous or next worksheet

Shift+Left/Right Arrow: Extend the cell selection to the left or right

Shift+Space: Select the entire row

Ctrl+Space: Select the entire column

Ctrl+Shift+Space: Select the entire worksheet

F2: Edit a cell

Shift+F2: Add or edit a cell comment

Ctrl+X: Cut contents of a cell, selected data, or selected cell range

Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range

Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range

Ctrl+Alt+V: Open the Paste Special dialogue box

Delete: Remove the contents of a cell, selected data, or selected cell range

Alt+Enter: Insert a hard return within a cell (while editing a cell)

F3: Paste a cell name (if cells are named in the worksheet)

Alt+H+D+C: Delete column

Esc: Cancel an entry in a cell or the formula bar

Enter: Complete an entry in a cell or the formula bar

Ctrl+B: Add or remove bold to the contents of a cell, selected data, or selected cell range

Ctrl+I: Add or remove italics to the contents of a cell, selected data, or selected cell range

Ctrl+U: Add or remove underline to the contents of a cell, selected data, or selected cell range

Alt+H+H: Select a fill colour

Alt+H+B: Add a border

Ctrl+Shift+&: Apply outline border

Ctrl+Shift+_ (Underline): Remove outline border

Ctrl+9: Hide the selected rows

Ctrl+0: Hide the selected columns

Ctrl+1: Open the Format Cells dialogue box

Ctrl+5: Apply or remove strikethrough

Ctrl+Shift+$: Apply currency format

Ctrl+Shift+%: Apply per cent format