Hello there.
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.
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
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
Post a Comment