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 |