If you want even more keyboard shortcuts in addition to these, Microsoft details even more of them on its website.Īlan Edwards, CISM, is chief information officer at Computerware, Inc., in Vienna, Virginia. Apply the Time format with the hour and minute, and AM or PM: Ctrl + Shift + Apply the Number format with two decimal places, thousands separator, and minus sign for negative values: Ctrl + Shift + !Īs you might expect, this is only a small fraction of what Excel can do if you know enough about it.Apply the Date format with the day, month, and year: Ctrl + Shift + #.

However, to save you a bit of time, you can do it quicker using a keyboard shortcut combination that will execute the same command. Apply the Scientific number format with two decimal places: Ctrl + Shift + ^ To delete a worksheet in a Microsoft Excel workbook, you would normally right-click on the worksheet tab and select ‘Delete’.Up Arrow key Move one cell down in a worksheet.

Shift+Tab Move one cell up in a worksheet. Apply the Percentage format with no decimal places: Ctrl + Shift + % Reference: Keyboard shortcuts in Excel 2016 Navigate in cells: keyboard shortcuts To do this Press Move to the previous cell in a worksheet or the previous option in a dialog box.Apply the Currency format with two decimal places: Ctrl + Shift + $.Apply the General Number format: Ctrl + Shift + ~.Enter the current time: Ctrl + Shift + :.You can also use various keyboard shortcuts to enter values into your cells: Move to the previous sheet in the workbook: Ctrl + Page Up.

Move to the next sheet in the workbook: Ctrl + Page Down.

Move to the beginning of the worksheet: Ctrl + Home.

Navigate between cells and menu options: Arrow Keys.

Excel keyboard shortcuts worksheet