Use function key shortcuts. Excel for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don't have to press the FN key every time you use a function key shortcut. Excel is a powerful spreadsheet, but you can't call yourself a power user until you've mastered the essential keyboard shortcuts. Here are the 10 everyone needs to know.

The complete list of Microsoft Excel shortcut keys, we all use Microsoft excel now and then, however, most of us do not know what are the shortcut keys for Microsoft excel. In this article, I will share the complete list of Microsoft Excel shortcut keys. MICROSOFT EXCEL SHORTCUT KEYS CTRL combination shortcut keys: Key Description CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn Switches between worksheet tabs, from right-to-left.

CTRL+SHIFT+( Unhides any hidden rows within the selection. CTRL+SHIFT+) Unhides any hidden columns within the selection. CTRL+SHIFT+& Applies the outline border to the selected cells.

CTRL+SHIFT_ Removes the outline border from the selected cells. CTRL+SHIFT+~ Applies the General number format.

CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses). CTRL+SHIFT+% Applies the Percentage format with no decimal places. CTRL+SHIFT+^ Applies the Exponential number format with two decimal places.

CTRL+SHIFT+# Applies the Date format with the day, month, and year. Applies the Time format with the hour and minute, and AM or PM. Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. CTRL+SHIFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. CTRL+SHIFT+: Enters the current time.

CTRL+SHIFT+” Copies the value from the cell above the active cell into the cell or the Formula Bar. CTRL+SHIFT+Plus (+) Displays the Insert dialog box to insert blank cells. CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells. CTRL+; Enters the current date. CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet. CTRL+’ Copies a formula from the cell above the active cell into the cell or the Formula Bar. CTRL+1 Displays the Format Cells dialog box.

CTRL+2 Applies or removes bold formatting. Latest version of fl studio for mac. CTRL+3 Applies or removes italic formatting. CTRL+4 Applies or removes underlining. CTRL+5 Applies or removes strikethrough. CTRL+6 Alternates between hiding objects, displaying objects and displaying placeholders for objects.

CTRL+8 Displays or hides the outline symbols. CTRL+9 Hides the selected rows. CTRL+0 Hides the selected columns. CTRL+A Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.