38 Excel keyboard shortcuts, Work with Excel faster

When working with table and column data with Excel, the need to use keyboard shortcuts to save time is indispensable.

These keyboard shortcuts are applicable to all versions of Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Excel 2019. Please note that an operation can be performed by two other keyboard combinations. each other even though we only knew one before.

Below is a list of common Excel keyboard shortcuts that help quickly format data in Microsoft Excel, please read it for your reference.

Shortcuts to help format cells

Ctrl + 1: Display the Format dialog box.
Ctrl + B (or Ctrl + 2): Apply or cancel bold formatting.
Ctrl + I (or Ctrl + 3): Apply or cancel italic formatting.
Ctrl + U (or Ctrl + 4): Apply or cancel an underline.
Ctrl + 5: Apply or cancel strikethrough formatting.
Alt + '(apostrophe): Display the Style dialog box.

Keyboard shortcuts help in formatting numbers

Ctrl + Shift + $: Applies the currency format with two decimal places.
Ctrl + Shift + ~: Apply the General number format.
Ctrl + Shift + #: Apply date formats like: day, month, and year.
Ctrl + Shift + t: Apply the time format with hours, minutes, and indicate AM or PM.
Ctrl + Shift + ^: Apply the scientific number format with two decimal places.
F4: Repeat last formatting selection.

Shortcuts to help manipulate cells

Alt + H, A, R: Align the cell right.
Alt + H, A, C: Center the cell.
Alt + H, A, I: Align cells to the left.

Formula shortcuts

=: Start a formula.
Shift + F3: Display the Insert Function dialog box.
Ctrl + A: Display input method after entering formula name.
Ctrl + Shift + A: Insert arguments in formula after entering formula name.
Shift + F3: Insert a function into a formula.
Ctrl + Shift + Enter: Enter the formula as an array formula.
F9: Counts all worksheets in all workbooks.
Shift + F9: Calculate the active spreadsheet.
Ctrl + Shift + U: Switch to expand or collapse the formula bar.
Ctrl + ': Toggle Show formulas in cells instead of values.
Ctrl + Pg Dn (PageDown): The shortcut switches Sheet to sheet right on the open sheet
Ctrl + Pg Up (PageUp): Switch to the sheet to the left of the open sheet.
Ctrl + arrow keys: move to the top, bottom, left edge, right edge of a worksheet. This shortcut will prevent us from having to use the mouse to drag the slider to find the bottom cell, especially with a long spreadsheet. When you use the Ctrl key with any arrow keys in the direction you want to move, you will quickly get to the position you are looking for.
Ctrl + arrow keys + Shift: localize the range of data to the end of the table instead of just moving the selection box to the bottom of the table.
Double click the left mouse button in the cell: copy the formula to the bottom of the table. Normal action to copy down the rows below that when appears the + sign, then hold and drag the mouse until the bottom of the table. However, faster, you place the mouse on the plus position, double click the left mouse button and the formula will be copied down.Ctrl + Shift + 1 (!): Format the cell as a decimal number with 2 numbers after the comma.
Ctrl + Shift + 4 ($): format currency cell $.
Ctrl + Shift + 5 (%): format the cell as number%.
F4: turns a cell into absolute value. When copying formulas from different cell locations like B1, C2, . will automatically change when copied to the bottom line to become B2, C3. To prevent the formula from jumping, use the $ key before and after the cell letter to lock it. And a cell can be quickly locked using F4.
&: combine two-cell content. Jump to the 3rd column and type the formula = cell 1 & "" & cell 2, in which the "" part to create a space between the contents of 2 cells after merging. Then copy the formula to the bottom of the table, a column will appear with the content of combining columns 1 and 2.
Alt + =: quickly sum a column. Highlight the calculated area and highlight 1 blank cell below then press Alt + =, the last cell value is the sum of the cells in the selection.
Ctrl + Shift +; (semi-colon): quickly fill the current time in a worksheet.
Ctrl +; (semi-colon): enter the current date in the cell.
Ctrl + ~ (edge 1): see all cells in formulas.

Excel keyboard shortcuts

Isabella Humphrey

Update 23 September 2020

You should read it

May be interested

Summary of useful keyboard shortcuts in excel
tips make would like to share with you the accounting, office summarizing the shortcuts in excel 2007, 2010 which are very useful as follows
Common keyboard shortcuts are used in PowerPoint
if you often use powerpoint as presentations, instead of using the mouse cursor to manipulate, you should know the keyboard shortcuts in powerpoint to be able to work faster. using keyboard shortcuts will help you work more efficiently.
Lightroom keyboard shortcuts - All Adobe Lightroom keyboard shortcuts to use
in lightroom there are many different features so we manipulate it manually will take time. because of that, the manufacturer they provide shortcuts so you can manipulate faster and work more efficiently. software tips will introduce you to the shortcuts in adobe lightroom.
Summary of new keyboard shortcuts on Windows 11 to help you work faster
microsoft has just released a beta version of windows 11 that brings many new experiences to users. windows 11 also provides users with many new keyboard shortcuts.
Useful keyboard shortcuts on MacBook
when using a macbook, if you know how to combine the shortcut keys, you will operate faster and work more efficiently. here are some common keyboard shortcuts on macos.
Keyboard shortcuts for Chrome - Summary of Chrome shortcuts you need to know
for people who often use google chrome, the keyboard shortcuts will help them work faster and save a lot of time. in this article, software tips will send you the extremely useful shortcuts on google chrome.
List of common shortcuts for Google Sheets on Mac (Part 2)
using keyboard shortcuts to import data into a table makes it easy to understand how google sheets uses it to help you work faster and more efficiently. in the next section, network administrator will introduce you to the list of common google sheets shortcuts on mac.
Keyboard shortcuts in Excel 2007, 2013, 2016, 2010, 2003, 2019, 2021
when working with excel, using shortcuts not only saves time but also improves work efficiency. taking advantage of basic and advanced shortcuts in excel helps you perform operations more quickly and efficiently, from copying data to formatting cells and tables.
The most useful Excel keyboard shortcuts 2010 2013 2007
if you often use excel to work and study, you can not ignore the shortcuts to maximize speed and shorten the time working on excel.
Keyboard shortcuts in Microsoft Teams
this article summarizes the following shortcuts in microsoft teams by tipsmake will help you work faster in the process of using teams, thanks to the microsoft teams keyboard shortcuts that will save time and increase productivity on the plus platform. online collaboration.