Buzz
In previous articles, we introduced all the shortcuts in Excel. Users employing shortcuts in Excel expedite work, ensuring precision. In Excel, Ctrl shortcuts are paramount. Discover the 50 Ctrl shortcuts in Excel that users should be familiar with. Explore these shortcuts with Mytour.
Excel Shortcuts List Used with Ctrl
50 Ctrl Shortcuts in Excel
Ctrl + Z: Undo the previous action.
Ctrl + Y: Redo the last action.
Ctrl + C: Copy content in Excel.
Ctrl + X: Copy and delete selected cell's content.
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: Move to the sheet on the left.
Ctrl + PageUp: Move to the sheet on the right.
Ctrl + W: Close the Excel spreadsheet.
Ctrl + O: Open a new Excel spreadsheet.
Ctrl + S: Save the Excel spreadsheet.
Ctrl + Space (Spacebar): Selects entire data in the column.
Ctrl + Shift + * (asterisk): Selects the entire area around active cells.
Ctrl + K: Insert a hyperlink.
Ctrl + 9: Hide the selected row in Excel.
Ctrl + Shift + 9: Unhide the hidden row within the selected range containing that row.
Ctrl + 0 (number 0): Hide the selected column in Excel.
Ctrl + Shift + 0 (number 0): Unhide the hidden column within the selected range.
Note: In Excel 2010, it does not function; to reveal a recently hidden column, press: Ctrl + Z.
Ctrl + 1: Display the Format dialog box.
Ctrl + B (or Ctrl + 2): Apply or remove bold formatting.
Ctrl + I (or Ctrl + 3): Apply or remove italic formatting.
Ctrl + U (or Ctrl + 4): Apply or remove underline.
Ctrl + 5: Apply or remove strikethrough formatting.
Ctrl + Shift + $ (dollar sign): Apply currency format with two decimal places.
Ctrl + Shift + ~ (tilde): Apply General number format.
Ctrl + Shift + # (hash sign): Apply date format as: day, month, and year.
Ctrl + Shift + @: Apply time format with hours, minutes, and indicate AM or PM.
Ctrl + Shift + ^ (caret): Apply scientific number format with two decimal places.
Ctrl + A: Display input method after entering the formula name.
Ctrl + Shift + A: Insert parameters into the formula after entering the formula name.
Ctrl + Shift + Enter: Enter the formula as an array formula.
Ctrl + Shift + U: Toggle expand or collapse mode of the formula bar.
Ctrl + ': Switch display mode to show the formula in the cell instead of the value.
Using Ctrl shortcuts in Excel is essential, right? To get acquainted with Excel, users need to learn 7 Excel 2016 calculation tricks. Techniques like creating charts, building strings... help users use Excel most efficiently. Check out these 7 Excel 2016 calculation tricks to utilize the latest version of this spreadsheet tool.
Many users also wonder why they can't edit Excel when opened with Office 2016. In fact, your Excel is not faulty; the reason you can't edit on Excel 2016 is straightforward. Simply turn off the Protected View feature on Excel 2016. However, disabling Protected View means facing potential virus-infected files that may harm Excel and your computer.
