Excel 2016 Entry and Formatting Shortcuts

By Faithe Wempen

Part of Office 2016 For Seniors For Dummies Cheat Sheet

Excel 2016 offers you many tools to save time with everyday tasks. With these keyboard shortcuts, you can 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