Office 2016 at Work For Dummies
Book image
Explore Book Buy On Amazon

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

About This Article

This article is from the book:

About the book author:

Faithe Wempen, M.A., has written more than 140 books on computer hardware and software, including Microsoft Office 2016 for Seniors for Dummies and The PowerPoint Bible. A Microsoft Office Master Instructor, she has educated more than a quarter of a million corporate students with her online courses, and hundreds more as an adjunct instructor at Purdue University.

This article can be found in the category: