command lab
  • TOP
  • Excel

  • Excel’s list of shortcuts to remember absolutely [with practice function]

Excel’s list of shortcuts to remember absolutely [with practice function]

Excel is a very popular tool in business.

I’ve put together a set of shortcuts that you definitely want to remember. Those who work with Excel every day should learn shortcuts as soon as possible. Let’s learn early and let’s say goodbye to the wasteful work that we used to do with the mouse.

It’s important not only to learn shortcuts with your head, but also with your body. This site can be practiced intuitively, so please try the following practice first. And we recommend that you practice regularly on this site.

A detailed explanation list of each shortcut is given at the bottom.

First of all, please practice by actually moving your hands.

The exercises below include all Excel exercises. If you want to practice by dividing by genre, please select a menu from the items in “TRAINING” on this site and practice.

Press the START button below to enter practice mode.
STARTSTOP
* Input mode switching ctrl + shift + alt + space
PRE
NEXT
Guide mode
Repeat mode
PUSH ENTER

Open/Close/Save Book

The following shortcuts are too general, and many people already know them. If you do not know it, please wear it immediately. You’ve been doing a lot of wasted work up to now. If you didn’t know this shortcut, you would have lost 5 seconds per task. If you were to repeat this 50 times a day…how many seconds would you lose per year? ?

Open bookWindowsCtrlo
mac(command)o
Close bookWindowsCtrlw
mac(command)w
Save the bookWindowsCtrls
mac(command)s

Undo

It is a shortcut to return to the previous state. Commonly known shortcuts, which are often the same commands in other applications.

In case of Excel, you can trace the past of edit history by repeating this command.

Please note that the history will not be reset even if you execute overwriting, but if you close the book once and reopen it, the edit history will be reset.

UndoWindowsCtrlz
mac(command)z

Copy/Paste/Cut

This may be the most common shortcut. In the case of Excel, the behavior is slightly different between the cell selection mode and the cell editing mode.

In the cell selection mode, the format information in the cell is also acquired. In the edit mode in the cell, it is possible to edit without being affected by the format, so it is necessary to use it properly depending on the situation.

copyWindowsCtrlc
mac(command)c
pastingWindowsCtrlv
mac(command)v
Cut outWindowsCtrlx
mac(command)x

Find/Replace

This is a very popular shortcut to display a search and replace dialog. You can also set options such as scope, search direction, and search target.

If you execute search or replace with the selected range specified, you can search only in the selected range, so it is necessary to use them properly depending on the situation. ‥

Search forWindowsCtrlf
mac(control)f
ReplaceWindowsCtrlh
mac(control)h

Break in the same cell

This shortcut should be very troublesome if you do not know it. If you try to start a new line with just the Enter key while in edit mode in a cell, you will exit edit mode and select the cell below. This shortcut is required if you want to break lines in cells.

Break in the same cellWindowsaltEnter
mac(option)Enter

Edit text (bold, italic, underline, strikethrough)

If you remember, it is a text decoration type shortcut that can be edited at explosive speed. The behavior is different when the cell itself is selected and when individual characters are selected in cell edit mode.

When the cell itself is selected, it is applied to all the characters in the cell. On the contrary, when individual character is selected in cell edit mode, it is applied only to the selected character.

BoldWindowsCtrlb
mac(command)b
Make italicWindowsCtrli
mac(command)i
UnderlineWindowsCtrlu
mac(command)u
Strike throughWindowsCtrl5
mac(control)5

Move cell

It is surprisingly convenient to know the shortcut for moving cells. The key point is that this shortcut is where you can move cells without taking your finger off the home position. Remember, you will be able to work without stress.

Move rightWindowsTab
macTab
Move leftWindowsshiftTab
mac(shift)Tab
Move downWindowsEnter
macEnter
Move upWindowsshiftEnter
mac(shift)Enter

Hide rows/columns

Shortcut to hide rows and columns. You can select a row or column for each row, right-click and select “Do not display” with a single command. Remember, it will definitely streamline your work. ‥

Hide cursor “row”WindowsCtrl9
mac(command)9
Hide cursor “column”WindowsCtrl0
mac(command)0

Extend selection

Shortcut for expanding a cell selection. Use this when you want to edit multiple cells.

Extend the selection up one level.Windowsshift
mac(shift)
Extend the selection one place to the right.Windowsshift
mac(shift)
Extend the selection down one level.Windowsshift
mac(shift)
Extend the selection one place to the left.Windowsshift
mac(shift)

Move to the end in the data area

It is a shortcut that can move to the edge in the data area. When moving from a place with a value, it moves to the edge of the cell with a value, and when moving from a place without a value, it moves all the way to the edge of the cell with no value.

Move to the first row in the current data areaWindowsCtrl
mac(command)
Move to the leftmost column in the current data areaWindowsCtrl
mac(command)
Move to the last line in the current data areaWindowsCtrl
mac(command)
Move to the rightmost column in the current data areaWindowsCtrl
mac(command)

Select to the edge within the data area

It is an application of the above shortcut. Shortcut used when you want to extend the selection to the edge of the data area.

Extend selection to the first row in the current data areaWindowsCtrlshift
mac(command)(shift)
Extend selection to the leftmost column in the current data areaWindowsCtrlshift
mac(command)(shift)
Extend selection to the last row in the current data areaWindowsCtrlshift
mac(command)(shift)
Extend selection to the rightmost column in the current data areaWindowsCtrlshift
mac(command)(shift)

Open list of validation rule options

Normally, for cells with selection items, press the ▼ button with the mouse to display a selection list, but using this shortcut you can select without using the mouse. Please remember that working without a mouse can reduce work stress.

Open list of validation rule optionsWindowsalt
mac(option)

Open Cell Format dialog

Shortcut for opening a dialog that allows you to format cells such as “number”, “currency”, and “string”. Even after the dialog is displayed, you can select it with the arrow keys and press ENTER to confirm it, so you can change the format without using the mouse.

Open Cell Format dialog boxWindowsCtrl1
mac(command)1

Edit active cell and move cursor to end of cell content

When you want to edit the text in the cell, it is a shortcut that you can immediately enter edit mode. If you want to edit the contents of a cell, you can use this shortcut to save one action. It’s a shortcut that you should definitely remember because it will increase the work efficiency considerably.

If you select with this shortcut, the backmost one will be active, so you can add characters immediately.

Edit active cell and move cursor to end of cell contentWindowsF2
macF2

Open [Insert] or [Delete] dialog

The behavior of this shortcut changes depending on the status of the selected cell. If you have selected one or more cells, a dialog box will appear, but if you have selected all rows or columns, a blank line will be added or deleted without displaying the dialog box. ..

Open Insert dialogWindowsCtrlshift「+」
mac(command)(shift)「+」
Open the Delete dialogWindowsCtrl「-」

Extend selection to “column” or “row”

A shortcut that extends the selection to the entire column or row from the current cursor. After selecting all columns/rows, you can add or delete them by using the shortcuts of “Insert” and “Delete” above, so remember them as a set.

Extend the selection to the entire column.WindowsCtrlspace
mac(control)space
Extend the selection to the entire row.Windowsshiftspace
mac(shift)space

Add or remove blank columns with Columns or Rows selected

As mentioned above, if you use the shortcuts of “Insert” and “Delete” with the column or row selected, you can perform the operations of “Insert” and “Delete” as they are. Very convenient to remember.

If you add a row/column while copying/cutting by row/column, the contents of copy/cut will be inserted as is.

[With columns or rows selected] Add a blank columnWindowsCtrlshift「+」
mac(command)(shift)「+」
[With columns or rows selected] Delete blank rowsWindowsCtrl「-」
mac(command)「-」

[Select format and paste] Open dialog

This is a shortcut for selecting the format when pasting the information copied from another cell. Knowing this is faster than pasting and then choosing a format.

0

[Select format and paste] Open dialogWindowsCtrlaltv
mac(command)(option)v

If possible, repeat the previous command or operation.

This is a shortcut that allows you to repeat special actions such as “Combine cells to center”. Very useful when you want to perform the same action in multiple places.

[If possible] Repeat the previous command or operation.WindowsCtrly
mac(command)y

Apply/remove outer borders to selected cells

A shortcut to add or remove borders from the outline of the selected cell. If you have selected multiple cells, the border will be added only to the outer frame.

If the outer border has already been applied, the behavior is to delete the border.

Apply outline border to selected cellsWindowsCtrlshift&
mac(command)(option)0

Switch between sheets in a book

This is a shortcut to switch between sheets separated by tabs at the bottom of the same book (file). Remember, you don’t have to click the tabs at the bottom to switch.

Select the next sheet in the book.WindowsCtrlshiftpagedown
mac(option)
Select the previous sheet in the book.WindowsCtrlshiftPageUp
mac(option)

Expand or collapse the formula bar.

This is a shortcut to switch the upper box for editing the cell contents from one line to multiple lines. If it is displayed in multiple lines, it will be toggled to one line.

Expand or collapse the formula bar.WindowsCtrlshiftu
mac(control)(shift)u

Use Copy Down to copy the cell content and formatting one level above to the cells in the selection.

A shortcut to copy the contents and format of the cell above. If a single cell is selected, the cell contents and format above it will be copied, and if multiple cells are selected, it will be applied within that range.

Use Copy Down to copy the cell content and formatting one level above to the cells in the selection.WindowsCtrld
mac(command)d

Switch cell format

It is a shortcut to directly convert each format such as currency and percentage. It can be converted without going through a dialog, so if you remember it, the work will progress considerably.

Apply the Currency display format.WindowsCtrlshift$
mac(control)(shift)$
Apply the Percentage display format.WindowsCtrlshift%
mac(control)(shift)%
Apply the Date format for dates, months, and years.WindowsCtrlshift#
mac(control)(shift)#

Open the Insert Hyperlink dialog.

Shortcut to open the dialog used when inserting a link. Normally, you need to right-click a cell and select it from the context menu, but you can use the shortcut to open the dialog immediately.

Open the Insert Hyperlink dialog.WindowsCtrlk
mac(command)k

Check the worksheet you are working on or the spelling in the selected range.

Shortcut to check spelling only for English. If no selection is specified, the worksheet you are working on will be checked. If you have specified a selection, the spelling will be checked in that range.

Check the worksheet you are working on or the spelling in the selected range.WindowsF7
macF7

Enter the current time and date

It is a shortcut that automatically inputs the current time and date. The format is also automatically dated, which is convenient.

Enter the current timeWindowsCtrl:
mac(command);
Enter the current dateWindowsCtrl;
mac(control);

Add a cell comment.

This is a shortcut that allows you to enter a comment to a cell immediately. This is useful when you use comments for the description of the sheet.

Add a cell comment.WindowsshiftF2
mac(shift)F2

Create an embedded graph from the selected range of data.

It is a shortcut to automatically generate a graph based on the selected range of data. You may not use it very often, but in case of emergency, you can quickly create a graph.

Create an embedded graph from the selected range of data.WindowsaltF1
mac(option)F1

Macro shortcuts

This is a convenient shortcut for those who work with macros in VBA.

Create, run, edit, or delete macros.WindowsaltF8
mac(option)F8
Open the Microsoft Visual Basic For Applications editor.WindowsaltF11
mac(option)F11

コメントを残す

CAPTCHA


The comment will be displayed after approval by the site administrator. Please follow the manners and comment.