Excel 2016 Entry and Formatting Shortcuts

By Faithe Wempen

Part of Office 2016 At Work For Dummies Cheat Sheet

In Excel 2016 you can use the following keyboard shortcuts to enter and modify data in Excel 2016. These keyboard shortcuts can save you time when entering and formatting data in Excel.

To do this Use the key combination
Enter the current time Ctrl+Shift+:
Enter the current date Ctrl+;
Apply an outline border Ctrl+Shift+&
Remove an outline border Ctrl+Shift+_
Display or hide formulas in cells Ctrl+`
Display Format Cells dialog box Ctrl+1
Hides selected rows Ctrl+9
Hides selected columns Ctrl+0