Summary of 70+ Most Useful Excel Shortcut Keys You Know

If you use Excel software basically, we will think it is not difficult, but for accountants or storekeepers, this is a software with a number of words, extremely complex calculation formulas, not easy. to use, especially in work that needs to be mastered to help solve problems faster. So keyboard shortcuts play an extremely important role to optimize your time. Join WebTech360 to learn  the most useful Excel shortcuts to work most efficiently .

What Are Shortcut Keys?

During daily computer use, a shortcut is a sequence of keys or a combination of key combinations on the computer keyboard to call and execute commands in the software.

Most keyboard shortcuts will require the user to press a key or a sequence of keys in turn. While other shortcuts require pressing and holding multiple keys simultaneously. Depending on the operating system, the program and the user's settings, the shortcut operation will be different.

In this article, we will guide you through the most useful Excel shortcuts , apply them immediately to your daily work to save time and increase your work productivity many times!

Summary of 70+ Most Useful Excel Shortcut Keys You Know

Excel shortcuts to help you work as fast as "Lightning"

70+ Most Useful Excel Shortcut Keys You Should Know

In addition to the ways of remembering the familiar keyboard shortcuts that are often used as taking notes or getting used to them. You can easily memorize a lot more keyboard shortcuts just by categorizing them into groups.

Today we will reveal the most useful shortcuts in Excel by headings for your convenience to follow and remember.

Working with the shortcut Ctrl

List of the most useful Excel keyboard shortcuts for manipulating the Ctrl key:

CTRL + TAB Switch between open Excel files

CTRL + PAGE UP Switch to the left sheet

CTRL + PAGE DOWN Switch to the right sheet

CTRL + HOME Move back to the first row and column in the sheet

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

CTRL + N Create a new file

CTRL + O Open a saved file

CTRL + P Print file

CTRL + S Save the page

CTRL + W Close current Excel sheet

CTRL + SHIFT + A Inserts a comma ( ) and arguments after entering the function name

F4 or CTRL + Y Repeat the last action

CTRL + C Copy selection

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

CTRL + R Copy data from left to right

CTRL + V Paste the value stored in the clipboard

CTRL + X Cut the selected part

CTRL + Z Go back to the last action

CTRL + DELETE Delete all text in a line

CTRL + – Delete rows and columns

CTRL + ; Update date

CTRL + 0 Hide selected columns

CTRL + 1 Calls up the Format Cells dialog box

CTRL + 5 Enable/disable centerline and non-centerline mode

CTRL + 9 Hide selected lines

CTRL + B Enable/disable the bold part

CTRL + I Turn italic on/off

CTRL + U Turn the underline on/off

CTRL + SHIFT + – Removes the border for the selected cells

CTRL + SHIFT + # Reformat Data type for day, month, year

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

CTRL + SHIFT + % Reformat Percentage Numbers (no decimal places)

CTRL + SHIFT + & Add Outline

CTRL + SHIFT + ( Show hidden lines

CTRL + SHIFT + : Enter time

CTRL + SHIFT + ? Format Numer with two decimal places

CTRL + SHIFT + ^ Reformat Exponential numbers to two decimal places

CTRL + SHIFT + ~ Format Numbers as General

CTRL + SHIFT + ” Copy the value of the upper cell to the cursor position of the current cell

CTRL + SHIFT + = Insert blank cells or blank lines

CTRL + SHIFT + 0 Show currently selected columns

CTRL + SHIFT + 5 Format is a percentage

CTRL + SHIFT + 9 Show currently selected lines

CTRL + ARROW Move to the position of the last cell containing the data before the empty cell

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

CTRL + SHIFT + HOME Extend the selection to the top of the worksheet

CTRL + SPACEBAR Select all columns

CTRL + ' Copies the upper cell value at the cursor position of the current cell

CTRL + K Inserts a Hyperlink.

Working with the Shift key

List of the most useful Excel keyboard shortcuts for manipulating the Shift key:

SHIFT + ARROW Select an area

SHIFT + ENTER Fill in the data in the cell and move up to the upper position in the selection

SHIFT + HOME Extend the selection back to the first line

SHIFT + PAGE DOWN Extend selection down one screen

SHIFT + PAGE UP Extend selection up one screen

SHIFT + SPACEBAR Select an entire line

SHIFT + F2 Insert more comments

SHIFT + TAB Write data to the cell and move left the selection.

Working with the Alt . key

List of the most useful Excel keyboard shortcuts for working with the Alt key:

ALT + TAB Switch between programs

ALT + = Call the Auto Sum function

ALT + ENTER Down one line in cell

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

ALT + DP Shortcut Insert / PivotTable

ALT + AE Shortcut Data / Text to Column

ALT + DB Shortcut Data / Subtotal

ALT + OHU Show hidden sheet

ALT + OHH Hide sheet

ALT + OCA Auto Align Column Width

ALT + ES Paste Special

ALT + DFF Shortcut Data / Filter

ALT + WF + ENTER Keyboard Shortcut View / Freeze or Unfreeze Panes

ALT + WS Shortcut View / Split

ALT + N + (Type of chart) Insert chart types.

Office computer configuration 2021 for office people

- Mainboard: Gigabyte H410m-H

- CPU: Intel Core I3 10100 Up To 4.3g | 4 Core | 8 Thread

- Ram: Lexar 8gb Ddr4 2666mhz (1x8gb)

- SSD: Gigabyte SSD 240g Sata III

- Power: Aerocool Vx Plus 400 400w

Case : Jetek Kamado (No Fans)

This is the minimum configuration for office work, if you want to watch movies, play games at a higher level, you should upgrade this configuration.

Those are the 3   most useful groups of shortcuts in Excel that WebTech360 has made, making it easy for you to remember as well as classifying groups that will make it convenient for you to use these shortcuts. If you find it useful, continue to follow WebTech360 for more interesting information.

Sign up and earn $1000 a day ⋙

Which Dell Laptop Line is Best, Should Buy and Use Today?

Which Dell Laptop Line is Best, Should Buy and Use Today?

You are wondering which Dell laptop is the best, should buy today. So, let's take a look at the detailed answer right in the content below.

Top 10+ Thin and Light Laptop Models With Best Powerful Configuration Today

Top 10+ Thin and Light Laptop Models With Best Powerful Configuration Today

On the market, there are many laptops from different brands, but the 10 models of thin and light laptops with strong configuration below are chosen by many users.

Top 5 Best Computers, Laptops for Learning Information Technology Today

Top 5 Best Computers, Laptops for Learning Information Technology Today

Wondering which type of computer to learn information technology should choose? Revealing the top 5 best computer lines for IT people in this article will help you.

Workstations - Equipped with an Eye-catching Cooling System.

Workstations - Equipped with an Eye-catching Cooling System.

Ordinary computers specialize in making 3dsmax rendering software, lumion, sketchup software for architects, artists ...

How powerful will the Core i9 processor for laptops be and whats new?

How powerful will the Core i9 processor for laptops be and whats new?

Intel has officially launched the Core i9 series for laptops, promising to bring the power of the desktop into laptops that were previously thought to be inferior to PCs.

Asus TUF FX504GD Red Matter - The perfect upgrade of the FX503VD

Asus TUF FX504GD Red Matter - The perfect upgrade of the FX503VD

The Asus TUF FX504GD Red Matter available in the main market is an extremely reasonable choice with low cost and high performance criteria. An extremely high quality gaming laptop.

Instructions to rotate horizontally, vertically rotate the computer screen extremely fast

Instructions to rotate horizontally, vertically rotate the computer screen extremely fast

Your computer screen can be completely rotated horizontally, vertically if you know how. The information below will help you adjust quickly.

How to record high quality computer and laptop screens for free

How to record high quality computer and laptop screens for free

How to record high quality computer screen for free? Let's learn how to record screen through several sections quickly and easily.

What is the best way to adjust the color of the screen?

What is the best way to adjust the color of the screen?

Long-term use of computer screens can easily lead to color change. So what is the best way to adjust the color for the screen? Read the following article to answer the above question.

What is Intel UHD Graphics 620? Should I Use This Onboard Card?

What is Intel UHD Graphics 620? Should I Use This Onboard Card?

Intel UHD Graphics 620 is a hot onboard graphics card recently. So what makes this product stand out from other cards on the market?

MSI Laptop From Which Country? Whether to buy or not?

MSI Laptop From Which Country? Whether to buy or not?

You are looking to refer to the current popular msi laptop line. So which country's msi laptop? Is the quality good or not? With WebTech360 for reference.

Choose Air Heatsink Or Liquid Heatsink, Which Is Better?

Choose Air Heatsink Or Liquid Heatsink, Which Is Better?

Want to know more about the system, features and more of the heatsink? The following article will help you better understand gas heatsinks or liquid heatsinks.

Do You Know The Simplest Way to Classify Computer Monitors?

Do You Know The Simplest Way to Classify Computer Monitors?

Depending on the intended use, you will choose a screen of the corresponding quality. Refer to WebTech360's sharing of computer screens

Distinguishing the Most Popular Headphones Today

Distinguishing the Most Popular Headphones Today

Headphones are an indispensable part of life. How to choose a standard headset? WebTech360 shares with you how to distinguish different types of headphones.

Looking for Answers: Should You Use a Wired or Wireless Mouse?

Looking for Answers: Should You Use a Wired or Wireless Mouse?

There are many people who wonder whether to use a wired or wireless mouse, what are the advantages and disadvantages of each type of mouse. WebTech360 will answer in the following article.

Did You Know: Whats the Difference Between a Gaming Mouse and a Normal Mouse?

Did You Know: Whats the Difference Between a Gaming Mouse and a Normal Mouse?

What is the difference between a gaming mouse and a regular mouse? Let's learn more about this issue with WebTech360 through the article below!

3 Fastest And Easiest Ways To Convert DOCX To DOC 2023

3 Fastest And Easiest Ways To Convert DOCX To DOC 2023

Simple and effective ways to convert DOCX to DOC you can try at home. Please refer to the article of WebTech360!

Do You Know How to Convert PDF Files to JPG, PNG Image Files?

Do You Know How to Convert PDF Files to JPG, PNG Image Files?

Converting PDF files to JPG and PNG image files is necessary, WebTech360 will introduce converting software and websites through this article.

Instructions for Connecting IPhone to Computer Using iTunes

Instructions for Connecting IPhone to Computer Using iTunes

Is connecting iPhone to computer using iTunes as difficult as you think? Steps to connect iPhone to computer using iTunes are simple for newbies.

Learn: Is Heat Dissipation Important For Laptops, PCs?

Learn: Is Heat Dissipation Important For Laptops, PCs?

Cooling fans are an integral part of PC kits. So let's join WebTech360 to answer the question, is heat dissipation important for laptops/PCs?