5 minutes to learn about common keyboard shortcuts in excel

The most used spreadsheet tool today. The convenience that it brings to users is very useful. But many people, despite using excel for a long time, still do not know these shortcuts. Let's join giaphapdonggoi.net to learn the function of these shortcuts!

1. What is Excel?

Excel is a spreadsheet application that allows users to calculate and report with figures easily and quickly.
Excel consists of rows and columns and especially functions that allow us to calculate the sum of multiplication and division, etc. Widely applied in practice, the software helps office workers to manage their work well, save money and save money. Save time when working with numbers.

2. Common keyboard shortcuts in Excel

You have been using excel for so long, you know how many common shortcuts below. Let's find out together!

Shortcuts for navigation of objects in excel:
Syntax

Uses

CTRL + PAGE UP

Switch to the sheet on the left

CTRL + PAGE DOWN

Switch to the right sheet

HOME

Move the mouse to the beginning of the line

CTRL + HOME

Move the mouse to the first row and column in the sheet

CTRL + END

Move to the last row and column in the sheet

Arrow key

Move up, down, left, or right in a worksheet.

Pg Dn/Pg Up

Move to the bottom of the worksheet/ to the top of the worksheet.

Alt + Pg Dn/Alt + Pg Up

Move the screen right/left in a worksheet.

Tab/Shift+Tab:

Move a cell right/left in a worksheet.

Shortcuts with simple operations
Syntax

Uses

Ctrl + Z:

Undo previous action (multiple levels) - Undo.

Ctrl + Y:

Go to next action (multiple levels) - Redo.

Ctrl + C:

Copy the contents of the selected cell

CTRL + FEMALE

Create a new file

CTRL + O

Open the saved file

CTRL + P

CTRL + WILL

Save page

CTRL + W

Close current page

ALT + =

Using the Auto Sum function

CTRL + SHIFT + A

Insert commas ( ) and arguments after entering the function name

Keyboard shortcuts when using formulas in calculations
Syntax

Uses

Ctrl + Shift + $:

Apply currency format with two decimal places.

Ctrl + Shift + ~:

Apply the General style number format.

Ctrl + Shift + #:

Apply date formatting as: day, month, and year.

Ctrl + Shift + @:

Apply time format with hours, minutes and indicate AM or PM.

Ctrl + Shift + ^:

Apply scientific number format with two decimal places.

F4:

Repeat the last format selection.

Ctrl + A:

Displays the input method after entering the name of the formula.

Ctrl + Shift + A:

Insert the arguments in the formula after entering the name of the formula.

CTRL + KY

Insert a Hyperlink

ESC

Ignore changing data

SHIFT + ARROW

Select region

SHIFT + ENTER

Write data to the cell and move up in the selection

SHIFT + HOME

Extend selection back to first line

SHIFT + PAGE DOWN

Extend selection down one screen

SHIFT + PAGE UP

Extend selection to one screen

SHIFT + SPACEBAR

Select the whole line

SHIFT + F2

Insert comments

SHIFT + TAB

Write data into the cell to move left the selection

TAB

Write data to the input cell, move to the right of the selection

There are also some other shortcuts you can also apply in some emergency cases like
Ctrl + Shift + +: Displays the insert cell/row/column menu.
Shift + F2: Insert/Edit a comment cell.
Shift + F10, then M: Delete comment.
Alt + F1: Create and insert a chart with data in the current range.
F11: Create and insert a chart with data in the current range in a separate chart sheet.
Ctrl + K: Insert a link.
Enter (in a cell containing the link): Activate the link.

tim-hieu-nhung-phim-tat
You certainly already know how to use these shortcuts, right? These shortcuts require you to memorize or practice a lot to remember. There are also many useful information waiting for you at giaphapdonggoi.net. Let's update many new articles together here.! Wish you proficient in office computer