Keyboard shortcuts in Excel

You often edit text using the Microsoft Ofice toolkit, but do you know a professional editor who often uses keyboard shortcuts rather than the mouse? Using keyboard shortcuts saves many times more times than usual, TipsMake.com previously listed shortcuts in Word today TipsMake.com will list shortcuts in Excel for you to know. .

Keyboard shortcuts in Excel Picture 1

Group 1: Common keyboard shortcuts

Enter: Move down

ESC: Deselect the data that is changing

F4 or Ctrl + Y: Repeat the previous action

Alt + Enter: Insert new line in cell

Backspace: Delete the left character or selection

Delete: Delete the right character or selection

Ctrl + Delete: Delete all text in a line

Arrow keys: Move up or down one character

Home: Go to the beginning of the line

Ctrl + D: Copy data from top to bottom

Ctrl + R: Copy data from left to right

Shift + Enter: Write data into the cell and move up in the selection

Tab: Writes data into the cell and moves to the right of the selection

Shift + Tab: Writes data into a cell and moves to the left of the selection

F2: Edit the data in cells

Backspace: Delete the character to the left in the currently edited cell

Ctrl + F3: Name the selection

F3: Paste a named name in the formula

F9: Update calculations of open Workbooks

Shift + F9: Update calculations in the current sheet

Alt + =: Insert the AutoSum formula

Ctrl + ;: Update date

Ctrl + Shift +: Enter time

Ctrl + K: Insert a Hyperlink

Ctrl + Shift + ": Copy the value of the cell above the cursor position of the current cell

Ctrl + ': Copy the value of the cell above the cursor position of the current cell

Ctrl + A: Display the Formula Palette after clicking a function name on the formula

Ctrl + Shift + A: Insert the sign () and the arguments of the function after entering the function name into the formula.

Group 2: Group of data format keys

Ctrl + 1: Display the Format Cell window

Ctrl + Shift + ~: General number format

Ctrl + Shift + $: Format a Curency number with two decimal places

Ctrl + Shift +%: Percentage number format (without decimal places)

Ctrl + Shift + ^: Exponential numeric format with two decimal places

Ctrl + Shift + #: Format data type for day, month and year

Ctrl + Shift + ?: Format a Numer style with two decimal places

Ctrl + Shift + &: Add an outer border

Ctrl + Shift + -: Remove border

Ctrl + B: Toggle bold, not bold mode

Ctrl + I: Toggle italic mode, not italic

Ctrl + E: Toggles the text mode in the middle

Ctrl + U: Toggle the underlined mode toggles

Ctrl + 5: Toggle non-hyphenation mode

Ctrl + 9: Hide lines

Ctrl + Shift + (: Display hidden lines

keyboard shortcuts in excel

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

List of common shortcuts for Google Sheets on Android (Last part)
the interface and working style of google sheets is similar to excel, even simpler. using keyboard shortcuts helps you enter table data smarter and faster.
Keyboard shortcut in Excel, how to delete lines in Excel with keyboard shortcuts
keyboard shortcut in excel, how to delete lines in excel with keyboard shortcuts. normally, when working with excel if you want to delete a certain line, you will select all the rows then right-click and select delete. but instead of manipulating the mouse you have t
Pubg keyboard shortcuts - All the Pubg keyboard shortcuts you need to know
pubg keyboard shortcuts - all the pubg keyboard shortcuts you need to know. to become a professional gamer and survive in the world of pubg (playerunknowns battlegrounds), in addition to the powerful configuration computer, the keyboard, the correct mouse, the shortcut keys for quick operation are quite important for each gamer.
Useful keyboard shortcuts in Microsoft Word (Part 2)
tips make introduce to you how to use the shortcut set with the f key from f1, f2, f3, ..., f12 with detailed explanation, easy-to-understand illustrations.
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.
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.
Summary of 60+ latest keyboard shortcuts on Windows computers
the tips for using shortcuts super fast on windows computers. quick guide on how to use simple and easy to understand keyboard shortcuts. let's find out together now!
How to change keyboard shortcuts in Photoshop
adobe photoshop allows you to change keyboard shortcuts related to any function of the application. this article will show you how to change keyboard shortcuts in photoshop on windows and mac, as well as how to reset keyboard shortcuts to their default values.
Useful keyboard shortcuts in Microsoft Word (Part 3)
to continue the previous post, tips make would like to summarize for you how to use the shortcut keys with the f key from f7, f8, ..., f12 with detailed explanation, easy-to-understand illustrations.
MathType keyboard shortcuts - All MathType keyboard shortcuts you need to know
for math students and teachers, mathtype is an indispensable software in computers. to edit in mathtype quickly and effectively, we should use the shortcut on mathtype and readers, please refer to the keyboard shortcuts on mathtype summarized in the article below!

Keyboard shortcuts in Excel

You should read it

May be interested

Office information