Skip to main content

89 Excel Shortcut Keys Begin With [Ctrl] And Follow With The Other Keys | ExcelTip2Day


Hello there.

List of the Excel Shortcut Keys Start with Ctrl and Combine With The 89 Other Keys


I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to tell you about:

Excel shortcut keys begin with "Ctrl"+ the others 89 Keys.


Tip Quiz


What is the shortcut to open the visual basic editor?


Do you use an Excel office?

If yes, now you can find below the list of Excel Shortcut Keys that begin with "Ctrl" and plus with other keys in the keyboard such as:

1. Alphanumeric keys - letters and numbers

2. Punctuation keys - comma, period, semicolon and so on.

3. Special keys - arrow keys, Caps Lock key, control keys, function keys, and more.

Why should we use Excel keyboard shortcut key? What are the benefits of using them (shortcut keys & buttons) on your keyboard?

Benefits:
  • To say goodbye to your mouse, end slavery to it today. Why do we have to carry a mouse unless we don't have to?
  • A useful way to reach the result immediately.
  • More easing method. It is nonsense while your fingers usually type on the keyboard but you have to move your hand to hold mouse for dealing with any functions on the menu bar every time!
  • Save your time and energy. Not much moving your hand.

The Excel shortcut key will return the results displaying as in the table beneath:


Excel Shortcuts
Result
CTRL+ - Delete cell/row/column menu.
CTRL+' (APOSTROPHE) Fill cell formulas down and edit (copy above cell formulas).
CTRL+- WITH ROW / COLUMN SELECTED Delete row / delete column.
CTRL+" Fill cell values down and edit (copy above cell values).
CTRL+. (PERIOD) Move clockwise to the next corner of the selection.
CTRL+; (SEMICOLON) Insert the current date.
CTRL+` (GRAVE ACCENT) Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.
CTRL+0 (ZERO) Hide the selected columns.
CTRL+1 Format cells dialog.
CTRL+1, THEN CTRL+ARROW RIGHT/ARROW LEFT Access border menu in 'format cell' dialog. Once border was selected, it will show up directly on the next ctrl+1.
CTRL+5 Apply or remove strikethrough formatting.
CTRL+6 Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+7 Restrict Selected rows removed from Excluded* 
CTRL+8 Display or hides the outline symbols.
CTRL+9 Hide the selected rows.
CTRL+A Display formula window after typing formula name.
CTRL+A (OR CTRL+SHIFT+SPACEBAR) Select the entire worksheet or the data-containing area. Pressing  "ctrl+a" a second time then selects an entire worksheet.
CTRL+ALT+ARROW RIGHT/CTRL+ALT+ARROW LEFT Move to the right / to the left between non-adjacent selections (with multiple ranges selected).
CTRL+ALT+F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+ALT+V If data exists in clipboard: display the paste special dialog box.
CTRL+ARROW KEYS Move to the edge of the next data region (cells that contain data).
CTRL+ARROW LEFT/CTRL+ARROW RIGHT Inside a cell: move one word to the left / to the right.
CTRL+B (OR CTRL+2) Apply or remove bold formatting.
CTRL+BACKSPACE Show active cell within a selection.
CTRL+C Copy contents of selected cells.
CTRL+D Fill complete cell down (copy above cell).
CTRL+DELETE Delete text to the end of the line.
CTRL+END Move to the last cell with content on a worksheet.
CTRL+F Display the find and replace dialog box (with find selected).
CTRL+F1 Select the active tab of the ribbon and activate the access keys. Press either of these keys again to move back to the document and cancel the access keys. And then arrow left or arrow right.
CTRL+F10 Move workbook windows which are not maximized.
CTRL+F3 Create names from a row and column labels.
CTRL+F4 Create a new blank workbook (excel file).
CTRL+F7 Perform size command for workbook windows which are not maximized.
CTRL+F8 Close excel.
CTRL+F9 Maximize or restores the selected workbook window.
CTRL+G (OR F5) Display the 'go to' dialog box.
CTRL+H Display the find and replace dialog box (with replace selected).
CTRL+HOME Move to the beginning of a worksheet.
CTRL+I (OR CTRL+3) Apply or remove italic formatting.
CTRL+K Insert a hyperlink.
CTRL+L Insert a table (display create table dialog box).
CTRL+N Move to next/previous workbook window.
CTRL+O Save the active file with its current file name, location, and file format.
CTRL+P Display the excel help task pane.
CTRL+PAGE DOWN Move to the first record.
CTRL+PAGE DOWN/CTRL+PAGE UP Select the current and next sheet(s) / select and previous sheet(s).
CTRL+PAGE UP Move to the beginning/end of a field.
CTRL+R Fill complete cell to the right (copy cell from the left).
CTRL+S Display the save as dialog box.
CTRL+SHIFT+! Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+# Apply the date format with the day, month, and year.
CTRL+SHIFT+$ Apply the currency format with two decimal places.
CTRL+SHIFT+% Apply the percentage format with no decimal places.
CTRL+SHIFT+& Apply outline border from cell or selection.
CTRL+SHIFT+* (ASTERISK) Display the list for the current field in a PivotTable report.
CTRL+SHIFT+* (ASTERISK) Select the current region around the active cell.
CTRL+SHIFT+: (COLON) Insert current time.
CTRL+SHIFT+@ Apply the time format with the hour and minute and indicate a.m. Or p.m.
CTRL+SHIFT+[+] If data exists in clipboard: display the insert dialog box to insert blank cells.
CTRL+SHIFT+^ Apply the scientific number format with two decimal places.
CTRL+SHIFT+_ (UNDERSCORE) Remove outline borders from cell or selection.
CTRL+SHIFT+~ Apply the general number format.
CTRL+SHIFT+ Display order menu for insert cell/row and column.
CTRL+SHIFT+ WITH ROW SELECTED Insert row
CTRL+SHIFT+ WITH COLUMN SELECTED Insert column.
CTRL+SHIFT+0 (ZERO) Unhide any hidden columns within the selection*.
CTRL+SHIFT+9 Unhide any hidden rows within the selection.
CTRL+SHIFT+A Insert arguments in formula after typing formula name.
CTRL+SHIFT+ARROW KEY Extend the selection to the last cell with content in row or column.
CTRL+SHIFT+ARROW LEFT/CTRL+SHIFT+ARROW RIGHT Select or unselect one word to the left / to the right.
CTRL+SHIFT+END Extend the selection to the last used cell on the worksheet (lower-right corner).
CTRL+SHIFT+ENTER Enter a formula as an array formula.
CTRL+SHIFT+F Display the format cells with fonts tab active. Press tab 3x to get to font-size. Used to bectrl+shift+p, but that seems just get to the font tab in 2010.
CTRL+SHIFT+F3 Paste a defined name into a formula.
CTRL+SHIFT+HOME Extend the selection to the beginning of the worksheet.
CTRL+SHIFT+O Select all cells with comments.
CTRL+SHIFT+PAGE UP Select the current and previous sheet in a workbook.
CTRL+SHIFT+U Toggle expands or collapses formula bar.
CTRL+SPACE Select the entire column.
CTRL+TAB CTRL+SHIFT+TAB On a field button: select the area you want to move the selected field to.
CTRL+TAB/CTRL+SHIFT+TAB Display the control menu for the main Excel window.
CTRL+TAB/CTRL+SHIFT+TAB In a dialog box: perform the action for the selected button, or select/clear a checkbox.
CTRL+U (OR CTRL+4) Apply or remove an underline.
CTRL+V Paste content from the clipboard into the selected cell.
CTRL+X Cut the contents of selected cells.
CTRL+Y Redo last action (multiple levels).
CTRL+Z Undo last action (multiple levels).


Tip Answer

 a. It's ALT + F11.

 b. It's Ctrl + F11.

 c. It's ALT + Shift + F11.



Check: Excel Shortcut To Open Visual Basic Editor To Create Macro

Link recommendedπŸ‘‰ : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommendedπŸ‘‰ : English Numbers In Words 1 to 1000000

That brings me to the end of my posting. I'm gotta say goodbye for now.

Thanks for reading.



Posted by: Michael Leng



I've known, then I've grown.


See more articles:

Comments

Popular posts from this blog

Ctrl+Shift+*(Asterisk) - Excel Keyboard Shortcut Select Active Cells | Exceltip2day

"Ctrl+ Shift+ *(Asterisk)"  What are these keys beneficial for any Excel office user? Hello, everyone. I'm Michael. Welcome you to my Excel tip blog. Today, I'm going to give you the 3 key buttons to select the current region, which are around the cell(s) in the Excel worksheet. Tip Quiz What's the shortcut keys extending the selection to the first cell in an Excel worksheet? Whenever you fill out any data into cells in the Excel worksheet. For any reason, if you want to select all the active cells within it (Spreadsheet). What is the method you are going to do? Do you have your own the "How-To" for handling it? Whether you have one or have not. I am going to share you the three key buttons, shortcut way on a keyboard of your PC, laptop, notebook, tablet ; it is very simple to deal with it. You just press these buttons “Ctrl + Shift + * (Asterisk)” on the keyboard. This shortcut will result in selecting the current active cells th

5 Alternative Shortcut Ways Minimize Your Excel Workbook, Read It Now! | ExcelTip2Day

"How to Minimize Your Excel Workbook For Window?" Do you use an Excel office program?  If yes, stick around with me. I will show you how to operate your Excel worksheet easily. Hello, I'm Michael Leng. Today I'm very glad to show how to minimize an Excel workbook to an icon. Tip Quiz What to do if your monitor screen upside down? This applies to use for the Excel version 2013, due to I have been using it. And also these methods are for Window program operation. The methods that I have discovered and used, there are 5 ways. 5 methods minimize Excel workbook. ⟴ Use shortcut keys  "Ctrl" and "F9" ⟴   Use shortcut keys  " ALT",  "Spacebar" and "F9" ⟴   Click on the "Minimize workbook" square box. ⟴   Clicking on the "Minimize" command in the "Quick Access Toolbar" ⟴   Use shortcut keys "Window Logo" and "M" To make you more ease seein

Excel Trick Press A Couple Of [Arrow Key] Move One Cell Diagonally | Excetip2day

Hello there. I'm Michael, today, in my blog "Exceltip2day" , I'm going to talk about: The trick of how to move from a cell diagonally to another by using a shortcut key Tip Quiz Do you know what is the shortcut of deleting Cell(s) in Excel Worksheet? How do you move one cell diagonally by using shortcut key? Suppose the cell pointer is in the [ F10 ] active cell. We want to move to G9, H8, I7, etc. diagonally for an example. I have the trick to get the task done moving diagonally one cell to the adjacent cell that you can follow the 4 moving ways as the step below: Look at the image immidiately above, then to just press the bottoms below at the same time for the thick no. 1 to no. 4.  πŸ‘‰   Trick no. 1 To move one cell pointer diagonally from F10 to G9 Up Arrow Right Arrow πŸ‘‰   Trick no. 2 To move one cell pointer diagonally from F10 to G12 Down Arrow Right Arrow πŸ‘‰   Trick no. 3 To move one cell pointer diagonally from F10 to E9 Up Arrow Le