The most useful Excel keyboard shortcuts 2010 2013 2007
Depending on the needs of each person, you can use the most common keyboard shortcuts for I gathered some excel shortcuts that many people often use for your reference. You can apply to most excel versions from 2003, 2007, 2010, 2013
Enter -> Install data in the box, scroll down
ESC -> Ignore data that is changing
F4 or Ctrl + Y - -> Repeat operation
Alt + Enter -> Start new line in cell
Backspace -> Delete the character to the left or selection
Delete -> Delete the character to the right or selection
Ctrl + Delete -> Delete all text in one 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 a cell and move it 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 data in cells
Backspace -> Delete the left character in the cell editing
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 AutoSum formula
Ctrl +; -> Updated dates
Ctrl + Shift +: -> Enter time
Ctrl + K -> Insert a Hyperlink
Ctrl + Shift + ' -> Copy the value of the upper cell to the cursor position of the current cell
Ctrl + ' -> Copy the value of the upper cell to the position of the current cell
Ctrl + A -> Display Formula Palette after clicking a function name on the formula
Ctrl + Shift + A -> Insert function sign () and arguments after entering the function name in a formula
Ctrl + 1 -> Display the Cell command in the Format menu
Ctrl + Shift + ~ -> General number format
Ctrl + Shift + $ -> Curency number format 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 types for day, month and year
Ctrl + Shift +? -> Numeric format with two decimal places
Ctrl + Shift + & -> Add outer border
Ctrl + Shift + - -> Remove border
Ctrl + B -> Toggle bold mode, not bold
Ctrl + I -> Toggle tilt, not tilt
Ctrl + U -> Toggle underlined mode
Ctrl + 5 -> Toggle non-hyphenation mode
Ctrl + 9 -> Hide lines
Ctrl + Shift + ( -> Show hidden lines
You should read it
- Shift command in Windows
- Instructions for activating Night Shift on iOS 9.3
- Summary of 50 most popular Ctrl-using shortcuts in Excel
- Learn about the keyboard shortcut Ctrl + Alt + Delete, the powerful key phrase on Windows
- How to name, comment and protect cells in Excel
- How to name a cell or Excel data area
- How to Enable Night Shift on a Mac
- How to copy values in Excel
May be interested
- Keyboard shortcuts in Illustrator are often used, keyboard shortcuts are commonly used in AIkeyboard 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.
- 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 shortcutskeyboard 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 knowpubg 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, 2021when 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 computersthe 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 Photoshopadobe 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.