#Excel 2016 shortcut keys windows mac

CTRL + Shift + ) = Unhide selected columns.

CTRL + Shift + ( =В Unhide selected rows.

Command + i =В Apply or remove italic formatting to selected cells.

Command + b =В Apply or remove bold formatting to selected cells.

Command + Option + 0 =В Apply an outline border to selected cells.

CTRL + Shift + ~ =В Show all valuesВ in general number format.

CTRL + Shift + $ =В Show all values as currency.

CTRL + Shift + % =В Show all values as percentages.

CTRL + r =В Fill selected cell with the content in the cell to the leftВ of selected cell.

CTRL + d =В Fill selected cell with the content in the cell above selected cell.

CTRL + Shift + Tab =В Switch to the previous open worksheet (Mac).

CTRL + Tab =В Switch to the nextВ open worksheet.

Command + Shift + F6 =В Switch to previous workbook window.

Command + W =В Close the active workbook window.

Command + в†“ =В Jump to the bottom of a column.

Command + в†‘ =В Jump to the top of a column.Shift + Enter = Move up through a selection.These simple shortcuts can help you navigate between workbooks, sheets, rows and columns.

(Note:В To access the FВ keys (F1вЂ“F12), youвЂ™ll have to hold the Fn key before pressing any F key - unless youвЂ™ve enabled those keys as standard function keys) Navigation Shortcuts

#Excel 2016 shortcut keys windows mac

Excel ShortcutsВ for Mac to Help You Save Time 10 Best AppSumo Deals for Entrepreneurs & BloggersДЄlthough you can perform these manually, knowing these shortcutsВ will help you save some time and let you focus on things that matter. WouldnвЂ™t it be better if youВ could spend a little less time navigating, formatting, and entering formulas for the data? Hence weвЂ™ve put together a list of keyboard shortcuts for Microsoft Excel.

Many marketers who own a MacBook use Microsoft Excel every day, whether itвЂ™s to analyze data, create a pricing table, or to make a presentation to the client.Д¬reating reports in Excel isВ a laborious, time-consuming task.