Shortcut Edit Excel

Excel ShortcutsSource:

Excel is a valuable tool for many business professionals, but it can be time-consuming to navigate through the different menus and options. Thankfully, there are a variety of shortcuts that can make editing in Excel much more efficient. Here are some of the most useful Excel shortcuts:

Navigation Shortcuts

Excel Navigation ShortcutsSource:

One of the most basic functions of Excel is moving around the spreadsheet. Here are some shortcuts that can help:

CTRL + Arrow Keys

Excel Ctrl Arrow KeysSource:

Instead of using the mouse to move around the spreadsheet, use the CTRL key and arrow keys to quickly move to the desired cell. For example, CTRL + down arrow will take you to the last row of data in a column.

CTRL + Home or End

Excel Ctrl Home EndSource:

Use CTRL + Home to quickly move to cell A1, and CTRL + End to quickly move to the last cell of data in the spreadsheet.

Formatting Shortcuts

Excel Formatting ShortcutsSource:

Formatting is an important part of creating a professional-looking spreadsheet. Here are some formatting shortcuts:

CTRL + B, I, or U

Excel Ctrl B I USource:

Use CTRL + B to bold text, CTRL + I to italicize text, and CTRL + U to underline text.

CTRL + 1

Excel Ctrl 1Source:

This shortcut will open the Format Cells dialog box, where you can adjust the formatting of the selected cell or range of cells.

Formula Shortcuts

Excel Formula ShortcutsSource:

Formulas are a powerful tool in Excel, and using shortcuts can make working with them much easier. Here are some formula shortcuts:


Excel F2Source:

Use F2 to edit the contents of a cell. This is especially useful when working with formulas.


Excel F4Source:

Use F4 to repeat the last action. This is especially useful when copying and pasting formulas.


These are just a few of the many Excel shortcuts that can save you time and make editing in Excel much more efficient. By using these shortcuts regularly, you can become a master of Excel in no time!

Related video of Shortcut Edit Excel

M Arthur
M Arthur

Pembelajar dan penyuka dunia teknologi. Suka sekali berbagi pengetahuan lewat tulisan. Terimakasih sudah membaca salah satu tulisan saya.

Articles: 1031