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

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!