Shortcuts are basically commands issued by the computer keyboard in which they result in a certain action. In general, shortcuts are rarely used by users, due to the complexity in decorating certain commands that can be easily simplified by mouse clicks, or even by not knowing them. However, it is worth mentioning that the knowledge of the main shortcuts is practically obligatory to do well in the tests, since within the computer discipline, the shortcuts are one of the most charged subjects.
But after all, is there any rule to decorate shortcuts for Excel? What are the main shortcuts? Here are more details on the subject:
Excel Shortcuts Falling Into Evidence
In a general rule, the best way to decorate (or not forget) the shortcuts is to force their use on a daily basis. For example, when working in a spreadsheet in Excel and need to perform certain action, consider the possibility of a shortcut to the desired action. If you do not know which shortcut to use, or if there is a shortcut to a particular function, try to do a brief search to find out.
If there is a shortcut to the operation you want, note down and try to use it the next time you need it. In this way, you will force yourself to use the shortcuts, and will result in a practical way of decorating them.
Below we list the main Excel shortcuts that are usually collected in tests:
CTRL + Minus (-) - Displays the Delete dialog box to delete the selected cells.
CTRL +; - Enter the current date.
CTRL + ` - Toggles between displaying cell values and displaying formulas in the worksheet.
CTRL + ' - Copies a formula from the cell that is above the active cell to the cell or the formula bar.
CTRL + 1 - Displays the Format Cells dialog box.
CTRL + 2 - Applies or removes bold formatting.
CTRL + 3 - Applies or removes formatting in italics.
CTRL + 4 - Apply or remove underline.
CTRL + 5 - Apply or remove strikethrough.
CTRL + 6 - Toggles between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL + 8 - Displays or hides the outline symbols.
CTRL + 9 - Hides the selected lines.
CTRL + 0 - Hides the selected columns.
CTRL + A - Selects the entire worksheet. If the worksheet contains data, this command selects the current region. Pressing CTRL + A again selects the current region and its summary rows. Pressing CTRL + A again selects the entire worksheet.
CTRL + SHIFT + A - Inserts the names and parentheses of the argument when the insertion point is to the right of a function name in a formula.
CTRL + N - Applies or removes bold formatting.
CTRL + C - Copies the selected cells.
CTRL + C (followed by another CTRL + C) - Displays the Clipboard.
CTRL + D - Use the Fill Down command to copy the contents and format of the cell higher than a selected range in the cells below.
CTRL + F - Displays the Find and Replace dialog box with the Find tab selected.
SHIFT + F5 - Also displays this tab, while SHIFT + F4 repeats the last Find action.
CTRL + SHIFT + F - Opens the Format Cells dialog box with the Font tab selected.
CTRL + G - Displays the Go To dialog box. (F5 also displays this dialog box.)
CTRL + H - Displays the Find and Replace dialog box with the Replace tab selected.
CTRL + I - Applies or removes formatting in italics.
CTRL + K - Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for the existing hyperlinks that are selected.
CTRL + N - Create a new blank workbook
CTRL + O - Displays the Open dialog box to open or locate a file.
CTRL + SHIFT + O - Select all cells that contain comments.
CTRL + P - Displays the Print dialog box.
CTRL + SHIFT + P - Opens the Format Cells dialog box with the Font tab selected.
CTRL + R - Use the Fill Right command to copy the contents and format of the leftmost cell of a selected range in the cells to the right.
CTRL + B - Saves the active file with its file name, location, and current format.
CTRL + T - Displays the Create Table dialog box.
CTRL + S - Apply or remove underline.
CTRL + SHIFT + S - Toggles between expanding and reducing the formula bar.
CTRL + V - Inserts the contents of the Clipboard at the insertion point and overrides any selection. Available only after you have cut or copied an object, text, or cell content.
CTRL + ALT + V - Displays the Paste Special dialog box, available only after you cut or copy an object, text, or cell contents to a worksheet or other program.
CTRL + W - Closes the selected workbook window.
CTRL + X - Cut selected cells.
CTRL + Y - Repeat the last command or action, if possible.
CTRL + Z - Use the Undo command to revert the last command or delete the last entered entry.
CTRL + SHIFT + Z - Uses the Undo or Redo command to revert or restore the automatic fix when AutoCorrect Smart Tags are displayed.
CTRL + SHIFT + ( - Displays the hidden rows within the selection.
CTRL + SHIFT +) - Displays the hidden columns within the selection again.
CTRL + SHIFT + & - Apply the outline to the selected cells.
CTRL + SHIFT + _ - Removes the outline of the selected cells.
CTRL + SHIFT + ~ - Applies the General number format.
CTRL + SHIFT + $ - Applies the Currency format to two decimal places (negative numbers in parentheses)
CTRL + SHIFT +% - Applies the Percentage without decimals format.
CTRL + SHIFT + ^ - Applies the Exponential number format to two decimal places.
CTRL + SHIFT + # - Applies the Date format with day, month and year.
[Email protected] - Applies the Time format with the hour and minutes, AM or PM.
CTRL + SHIFT +! - Applies the Number format with two decimal places, thousands separator and minus sign (-) to negative values.
CTRL + SHIFT + * - Selects the current region around the active cell (the data area bounded by empty rows and columns).
CTRL + SHIFT +: - Enter the current time.
CTRL + SHIFT + " -Copy the value of the cell that is above the active cell to the cell or the formula bar.
CTRL + SHIFT + More (+) - Displays the Insert dialog box to insert blank cells.
And you, what shortcuts on that list do you find most useful? Tell us in the comments section below!