69+ The Most Useful Excel Keyboard Shortcuts You Should Know

For those whose jobs require daily use of Excel such as accountants, storekeepers…. it is very valuable to save a bit of time in processing tasks. And to streamline the working time, the shortcut keys in excel are very important.

However, not everyone knows the keyboard shortcuts in this useful excel.

This article Bencomputer will summarize the extremely useful excel shortcuts for your reference!

In addition to using many familiar expressions and remembering or recording keystrokes in excel, we have one more way to remember keystrokes more easily, which is to categorize keystrokes by topic.

WebTech360 will divide the keystrokes according to the sections for you to easily follow.

SYNOPSIS

1. Keyboard shortcut in Excel in combination with CTRL and ALT

a. Navigation shortcut

b. Action shortcuts

c. Function keys are off

d. Copy shortcut

e. Format shortcut

f. Select the data area

2. Shortcuts that incorporate the Alt accessibility key and the menu underlined letters

1. Keyboard shortcut in Excel in combination with CTRL and ALT

a. Navigation shortcut

OFF KEY BENEFITS

ALT + TAB Switch between programs

CTRL + TAB Switch between open Excel files

CTRL + PAGE UPSang sheet on the left

CTRL + PAGE DOWN Go to the right sheet

HOMEDi moves to the beginning of the line

CTRL + HOMEDi switches to the first row and column in the sheet

CTRL + END Move to the last row and column in the sheet

b. Action shortcuts

CTRL + N Create a new file

CTRL + O Open the saved file

CTRL + PIn

CTRL + SL Save the page

CTRL + W Closes the current page

ALT + = Use the Auto Sum function

CTRL + SHIFT + A Insert an ampersand () and the arguments after entering the function name

Very simple but easy to mistake, you just need to remember the letters and automatically attach the Ctrl accessibility button.

c. Function keys are off

F2 Edit data in cells

F3 Paste a given name in the formula

F4 or CTRL + Y Repeat the action you just performed

F5 Go to the position specified by reference

The available function keys do not need to be combined with any other auxiliary keys. It's quite easy to remember just doing a few times to get used to.

d. Copy shortcut

CTRL + CS Copy

CTRL + D merges the value from the cell above the current cell into the current cell

CTRL + R Copy data from left to right

CTRL + VD Paste

CTRL + X Cut

CTRL + Z Return to the action you just performed

CTRL + DELETEX Delete all text in one line

ALT + ENTER Descends a line in a cell

These keyboard shortcuts are very important to work with in excel and need more attention to save time optimally.

e. Format shortcut

CTRL + - Delete rows and columns

CTRL +; Update date

CTRL + 0 Hides the currently selected columns

CTRL + 1 Call the Format Cells dialog box

CTRL + 5 Enables / disables hyphenation

CTRL + 9 Hides the selected lines

CTRL + Bold on / off

CTRL + I Italicize on / off

CTRL + X Underline on / off

CTRL + SHIFT + - Delete the border for the selected cells

CTRL + SHIFT + # Data format format for date, month, and year

CTRL + SHIFT + $ Curency number format with two decimal places

CTRL + SHIFT +% Percentage Number Format (without decimal places)

CTRL + SHIFT + & Add Outline

CTRL + SHIFT + (Display hidden lines

CTRL + SHIFT +: Enter the time

CTRL + SHIFT +? Numerous format with two decimal places

CTRL + SHIFT + ^ Exponential type number format with two decimal places

CTRL + SHIFT + ~ General number format

CTRL + SHIFT + ”Copies the value of the cell above to the cursor position of the current cell

CTRL + SHIFT + = Insert blank cell or blank line

CTRL + SHIFT + 0 Show currently selected columns

CTRL + SHIFT + 5 Format format as a percentage

CTRL + SHIFT + 9 Show currently selected lines

These shortcut key combinations are relatively complicated and have to double use of accessibility keys. Although it's a bit hard to remember but extremely useful, just by memorizing these key combinations, you can easily become an "excel master" in a short time.

f. Select the data area

ALT + DOWN ARROW Displays a list of values ​​in the current column

CTRL + ARROWD Move to the last cell containing data before the blank cell

CTRL + SHIFT + END Extend the selection to the last used cell

CTRL + SHIFT + HOMO expands the selection to the beginning of the worksheet

CTRL + SPACEBAR Select the entire column

CTRL + 'Copy the cell value above to the cursor position of the current cell

CTRL + K Insert a Hyperlink

ESC Ignore changing data

SHIFT + ARROW Select the area

SHIFT + ENTER Writes data into a cell and moves up in the selection

SHIFT + HOMI expands the selection to the first row

SHIFT + PAGE DOWN Extend selection down one screen

SHIFT + PAGE UP Extend selection up one screen

SHIFT + SPACEBAR Select the entire line

SHIFT + F2 Insert comment

SHIFT + TAB Writes data to a cell and moves left in the selection

TAB Writes data in a cell and moves right through the selection

Similar to the above section, this section includes key combinations that are familiar and very popular. If possible, try to practice every day to quickly master these key combinations.

2. Shortcuts that incorporate the Alt accessibility key and the menu underlined letters

The combination of useful shortcuts in Excel is preserved from the oldest versions up to now, slightly different from word after versions, so that users can conveniently use it without spending time to learn and get acquainted.

The general rule of this section 2 is to manipulate the Alt key and the underlined characters in the menu of Excel 2003 (refer to the image below).

Note: just press Alt 1 time, no need to hold down.

ALT + D PInsert / PivotTable

ALT + A EData / Text to Column

ALT + D BData / Subtotal

ALT + OH Show hidden sheet

ALT + OH Hides the sheet

ALT + OC AT Manually adjusts the column width

ALT + E SDán Special

ALT + DF FData / Filter

ALT + WF + ENTERView / Freeze or Unfreeze Panes

ALT + W SView / Split

ALT + N + (Type of chart) Insert the chart

It seems a bit too many characters to remember, but "hundred or not by hand" , just practice and use every day, the useful key combinations in this excel will not be difficult for you.

Above are the useful shortcut combinations in Excel that WebTech360 has synthesized and classified according to each item for you to easily memorize and use.

Good luck!