Summary of the most useful Excel keyboard shortcuts you should know

As you all know, Excel is an extremely popular application used today, from students, students, office workers or to senior professionals. all of them are using Excel to study. and work.

And to use Excel proficiently and professionally, using keyboard shortcuts in Excel is a sure thing.

I have not seen a pro Excel that does not use keyboard shortcuts (hotkeys).

Using Excel keyboard shortcuts will help you shorten the operation time a lot, help you work faster, more efficiently and really using these shortcuts is indispensable for a professional accountant. Karma.

A sincere advice for office people, especially accountants: The more you remember the hotkey the better, it will be extremely useful in your work if you know how to take advantage of it.

At first, everyone must be afraid to use keyboard shortcuts, myself too because I am used to manipulating the mouse, but try to practice and consider it a habit and forget the other mouse. everything will be much simpler.

Going to the main problem, this article I will share with you the frequently used shortcuts on Execl, you should open an Excel file and read and follow it at the same time to be more effective.

Basic keyboard shortcuts in Excel you need to know

Applies to all versions of Excel (Excel 2003, Excel 2007… 2019….)

1. Working with the Ctrl key in Excel

STT	SHORT KEYS	FUNCTION
first	Ctrl + F	Find a word, phrase or number quickly.
3	Ctrl + Surname	Search and replace any phrase.
4	Ctrl + O	Open files stored on your computer.
5	Ctrl + FEMALE	Open a new Excel sheet.
6	Ctrl + X	Cut
7	Ctrl + W	Close the work window
8	Ctrl + EASY	If you want to copy the content of the line above to the line below, you just need to place the mouse pointer in the box below and press this shortcut combination.
9	Ctrl + A	Highlight all, similar to black out the entire text in word.
ten	Ctrl + Z	Cancel the last action to return to the previous action.
11	Ctrl + (-)	Delete the highlighted cell, row, column.
twelfth	Ctrl + L or Ctrl + T	Show create table dialog
13	Ctrl + Page up (Page down)	Move quickly between sheets in a spreadsheet.
14	Ctrl + U or Ctrl + 4	Underline text or un-underline text.
15	Ctrl + CHEAP	Copy the contents of the left cell to the right cell.
16	Ctrl + Enter	Fills the current entry in the selected range of cells.
17	Ctrl + Delete	Delete all letters in a line.
18	Ctrl + Q	Shows Quick Analysis option for selected cells that contain data.
19	Ctrl + Y	This command will repeat the last command or action
20	Ctrl + B or Ctrl + 2	Helps you bold or unbold by highlighting words and phrases to be transferred.
21	Ctrl + I or Ctrl + 3	Enable/disable italic mode by highlighting that word or phrase.
22	Ctrl + U or Ctrl + 4	Enable/disable underline mode.
23	Ctrl + 5	Enable/disable centerline mode.
24	Ctrl + 9	Hide rows in spreadsheets.
25	Ctrl + 0	Hide columns in spreadsheets.
26	Ctrl + 8	HIDE/Show outline icon.
27	Ctrl + (;)	Displays the day, month, and year in the cell where you place the mouse pointer.
28	Ctrl + 1	Displays the Cell command in the Format Cells menu.
29	Ctrl + KY	Insert a hyperlink (Hyperlink)
30	Ctrl + (')	Similar to Ctrl +
thirty first	Ctrl + Spacebar	Select all columns in the worksheet.
32	Ctrl + End	Move the mouse pointer to the bottom of the text, on the formula bar.
33	Ctrl + Shift + (#)	Format the Data type for the day, month, and year.
34	Ctrl + Shift + (&)	Create a border for 1 cell, or multiple cells you select.
35	Ctrl + Shift + (-)	Remove the border of the cell.
36	Ctrl + Shift + (~)	Apply the General number format.
37	Ctrl + Shift + 0	Show hidden columns.
38	Ctrl + Alt + 5, then Tab key several times	This will cycle through floating shapes, such as text boxes or images.
39	Ctrl + Alt + ( ' )	Copy the formula in the cell above the current cell to the cell or Formula Bar.
40	Ctrl + Shift + ( _ )	Removes outlines from selected cells.
41	Ctrl + Shift + (	Show hidden lines, as opposed to Ctrl + 9
42	Ctrl + Shift + (:)	Displays the time in the cell where you place the mouse pointer.
43	Ctrl + Shift + (%)	Applies to % format, no decimal places.
44	Ctrl + Shift + (+)	Insert more blank cells above, below, left, right
45	Ctrl + Shift + Page Down	Select the current and next sheet in the workbook
forty six	Ctrl + Shift + Page Up	Select the current and previous sheet in the workbook.
47	Ctrl + Shift + F Or Ctrl + Shift + P	Display Font, font size, font color to change.
48	Ctrl + Shift + A	Insert the () and function arguments after entering the function name into the formula.
49	Ctrl + Shift + Home	Extend cell selection to the top of the sheet
50	Ctrl + Shift + Spacebar	Selects all objects present on the worksheet while an object is selected.
51	Ctrl + Alt + DRAW	Opens a special paste dialog box.
52	Ctrl + Shift + U	Expand or shrink the formula bar
53	Ctrl + Shift + ($)	Apply the Currency format with two decimal places (negative numbers enclosed in parentheses).
54	Ctrl + Shift + End	Highlight all text in the formula bar, from the position of the mouse pointer to the end.

2. Working with the Shift key in Excel

STT	SHORT KEYS	FUNCTION
first	Shift + F10	Open right-click menu menu
2	Shift + Tab	Has the effect of moving to the previous cell in Excel or the previous option in the dialog box.
3	Shift + F2	Add or edit cell comments
4	Shift + Arrow Keys	Extend cell selection
5	Shift + Enter	Complete a cell entry and select the cell above.
6	Shift + Spacebar	Highlight entire rows in a sheet
7	Shift + F9	Calculate the current sheet.
8	Shift + F3	Perform function insert

3. Working with the Alt key in Excel

STT	SHORT KEYS	FUNCTION
first	Alt + Surname	Go to Tab HOME.
2	Alt + P	Move to the Page Layout tab
3	Alt + FEMALE	Go to the INSERT . Tab
4	Alt + A	Go to DATA . tab
5	Alt + W	Go to the VIEW tab
6	Alt + CODE	Go to the Formulas tab (recipe tab)
7	Alt + F	Open the Office Button window
8	Alt + CHEAP	Move to Review tab tab
9	Alt + Page Down	Move one screen to the right in Excel.
ten	Alt + Page Up	Move one screen to the left in the worksheet.
11	Alt + F11	Open the Microsoft Visual Basic For Applications editing toolkit.
twelfth	ALT + Enter	Newline in a cell.
13	Alt + F8	Create, run, edit, or delete macros.

Above are all the shortcuts in Excel that you should know, these shortcuts will be frequently used during your work with Excel, so try to remember a lot to become a real PRO soon. use it in Excel.

Hopefully this article will be useful for you. Good luck with your studies and more success!

keyboard shortcuts in Excel Excel

Micah Soto

Update 18 May 2021

You should read it

May be interested

How to use keyboard shortcuts when Paste Value in Excel?
how to use keyboard shortcuts when paste value in excel? here is a summary of keyboard shortcuts when paste value in excel, how to use keyboard shortcuts when paste value in excel, invite you to track.
Invaluable keyboard shortcuts in Excel
the use of shortcuts helps you accelerate your work many times. the following article introduces the most commonly used keyboard shortcuts in excel.
Summary of common keyboard shortcuts in Windows
proficient use of shortcuts on windows will help you save time, greatly increase productivity. here i summarize the common keyboard shortcuts, commonly used in windows 7, 8, 10 for your reference.
Summary of useful keyboard shortcuts when using Microsoft Outlook on the web
outlook is microsoft's free email service, with many features and utilities included. in many cases, working remotely requires access to virtual machines and productivity apps like microsoft 365 via the internet and a web browser.
Useful keyboard shortcuts in Microsoft Word (Part 1)
tips make introduces a summary of useful keyboard shortcuts in microsoft word that you can apply to different versions of word: 2003, 2007, 2010, ...
Summary of keyboard shortcuts in Word you should know if you want to be better
full sharing keyboard shortcuts in word help you compose documents faster. the most important and necessary keyboard shortcuts in ms word
Summary of all keyboard shortcuts when using Spotify on PC makes operation easy and fast
to make it easier for you to work with spotify, you should know the shortcut keys that spotify offers to users. here is a summary of all keyboard shortcuts when using spotify on pc for you to manipulate easily and quickly.
Summary of shortcuts for Microsoft Excel 2016-P2
while performing spreadsheet operations, if you know some of the shortcuts will save you time, the process will be greatly shortened.
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.
Keyboard shortcuts in Illustrator are often used, keyboard shortcuts are commonly used in AI
keyboard shortcuts in illustrator are often used, keyboard shortcuts are commonly used in ai. for graphic software, remembering the keyboard shortcuts will help you save a lot of time working and manipulating. illustrator's keyboard shortcuts are diverse and popular, forcing users to use only to be able to remember them all.