Summary of 50 most popular Ctrl-using shortcuts in Excel

In previous articles, we have introduced all keyboard shortcuts in Excel. Users use keyboard shortcuts in Excel to work faster and manipulate more accurately. In Excel, the Ctrl shortcut is the most important key. Specifically, there are up to 50 keyboard shortcuts using Ctrl in Excel that users should know. Learn 50 keyboard shortcuts using Ctrl in Excel below.

50 keyboard shortcuts using Ctrl in Excel

Ctrl + Z : Return to the previous step.
Ctrl + Y : Go to the last step.
Ctrl + C : Copy the content of in Excel.
Ctrl + X : Copy and delete the contents of the selected cell.

Shortcut Ctrl V : Paste copied data into Excel cell

Ctrl + Delete : Delete text to the end of the line.
Ctrl + Shift + : (colon) : Insert current time
Ctrl + PageDown : Switch to left sheet
Ctrl + PageUp : Switch to right sheet
Ctrl + W : Close worksheetexcel
Ctrl + O : Open new excel workbook
Ctrl + S : Save excel spreadsheet

Ctrl + Space (Spacebar) : Select all data in the column.
Ctrl + Shift + * (asterisk) : Selects the entire area around the active cells.
Ctrl + A key (or Ctrl + Shift + spacebar ): Select the entire excel worksheet
Ctrl + Shift + Page U p: Select the current and previous sheet in the same Excel file.
Ctrl + Shift + Home : Select to the first of the worksheet.
Ctrl + Shift + End Key : Select to the last cell used on the worksheet
Ctrl + Shift + left arrow / Ctrl + Shift + right arrow : Select or deselect a word from the left, right.
Ctrl + Home : Move to the first cell of a worksheet.
Ctrl + End Key: Move to the last cell containing the content on a worksheet.
Ctrl + F : Displays the Find and Replace dialog box (opens the Find - Find item).
Ctrl + H key : Display the Find and Replace dialog box (Replace available).
Ctrl + G (or F5 ) : Displays the 'Go to' dialog box.
Ctrl + left arrow / Ctrl + Right arrow : Inside a cell: Move to the left or right cell of that cell.
Ctrl + D : Copy the contents of the cell above.
Ctrl + R : Copy the cell contents to the left.
Ctrl + " (double quote) : Copy the cell contents above and in the editing state
Ctrl + ' (apostrophe) : Copy the formula of the cell above and in the editing state
Ctrl + – (minus sign) ): Displays the delete cell/row/column menu.
Ctrl + Shift + + (plus sign) : Displays the insert cell/row/column menu.
Shift + F2 : Insert / Edit a comment cell.

Ctrl + K : Insert a link.
Ctrl + 9 : Hide selected row in excel.
Ctrl + Shift + 9 : Show the hidden row in the selection containing that row.
Ctrl + 0 (number 0) : Hide selected column in excel
Ctrl + Shift + 0 (number 0) : Show hidden column in selection.

Note : In Excel 2010 does not work, to show the newly hidden column, press: Ctrl + Z.

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 underscore.
Ctrl + 5 : Apply or cancel strikethrough formatting.
Ctrl + Shift + $ (dollar character) : Apply currency format with two decimal places.
Ctrl + Shift + ~ (tilde) : Apply the General style number format.

Summary of 50 most popular Ctrl-using shortcuts in Excel Picture 1

Ctrl + Shift + # (hash sign) : Apply date format as: day, month and year.
Ctrl + Shift + @ : Apply time format with hours, minutes and specify AM or PM.
Ctrl + Shift + ^ (caret) : Apply scientific number format with two decimal places.

Ctrl + A key : Display the input method after entering the name of the formula.

Ctrl + Shift + A : Insert arguments in the formula after entering the name of the formula.
Ctrl + Shift + Enter key : Enter the formula as an array formula.
Ctrl + Shift + U : Switch to expand or collapse the formula bar.
Ctrl + ' : Switch the display of the formula in the cell instead of the value.

The keyboard shortcuts using Ctrl in Excel are absolutely necessary, right? To get familiar with Excel, users need to learn 7 Excel 2016 calculation tips. Tips such as creating charts, creating series . help users use Excel most effectively. Please refer to 7 Excel 2016 calculation tips to use the latest version of this table calculation tool.

Many users also wonder why can't edit Excel when opening with Office 2016. Actually, your Excel is not at fault, the reason for not being able to edit on Excel 2016 is very simple. You just need to turn off the Protected View feature on Excel 2016. However, turning off Protected View means that you will have to face virus files, which are harmful to Excel and the computer.

Excel

Kareem Winters

Update 22 September 2022

You should read it

May be interested

Summary of Important Computer Shortcuts You Must Know
computer shortcuts help you perform operations on your computer faster and more professionally. below is a list of important shortcuts that you should remember.
Summary of Shortcut Keys in Excel for Mac / Windows
many marketers use microsoft excel every day, whether it's to create charts, analyze data, or run reports to present at the next team meeting.
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
10 priceless shortcuts for computer users
bill gates once stated that the ctrl + alt + del key combination is a mistake, but this shortcut has quickly become a star in the technology community. besides ctrl + alt + del, on windows and mac there are 10 quite useful keystrokes that not everyone knows.
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.
Summary of shortcuts for Microsoft Excel 2016-P1
in the process of working with excel 2016 spreadsheets, if you know the shortcut keys, your actions will be much faster in the process of using, greatly reduced compared to traditional operations.
Summary of common shortcuts on Facebook
not only limited to browsers or software, popular applications often use shortcuts to improve the user experience. facebook social network is no exception, facebook currently supports many shortcuts. however, the facebook shortcuts are different between browsers and operating systems
Summary of tips, good Excel tips for accounting people
excel is the most popular and powerful calculator. especially for accountants who often work with excel spreadsheets, grasping and mastering tips in excel helps you achieve the highest efficiency. posts below huh
Some shortcuts in Excel you need to know
you often work with excel, but do these keyboard shortcuts ever be used? the use of shortcuts helps you manipulate faster, much more professional.
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.

Summary of 50 most popular Ctrl-using shortcuts in Excel

50 keyboard shortcuts using Ctrl in Excel

You should read it

May be interested

Office information