Philippine News

Social Icons

Date Published:

2:33 PM March 14, 2019

Date Updated:

2:33 PM March 14, 2019

in: Blogging
Share to Facebook Share to Twitter More...

List of Microsoft Excel Keyboard Shortcuts / Shortcut Keys

MICROSOFT EXCEL KEYBOARD SHORTCUTS – Here is a list of the shortcut keys in using the Microsoft Excel.

Aside from Microsoft Word, another software that is widely used by many people is Microsoft Excel. It is a spreadsheet that works in Windows, Android, iOS, and macOS.

The MS Excel is utilized for its unique set of features including the graphing and the calculation. It is often used by students and employees working in an office. It is also usually utilized in the payroll of workers.

In using this software, there are several Microsoft Excel keyboard shortcuts or shortcut keys that you can memorize and use for a faster work pacing. These shortcuts may also be functions that are not available in single keyboard button.

Microsoft Excel Keyboard Shortcuts
Photo Courtesy of Neowin

Based on an article posted on Turbo Future, here is a list of the useful Microsoft Excel keyboard shortcuts or shortcut keys you may use:

F2: Edit the active cell
F5: Displays the Go To box.
F7: Open the Spelling dialogue box to check a selected range.
F11: Create a chart of data in the current range in a separate sheet.
Alt + Shift + F1: Insert a new worksheet.
Shift + F3: Opens Insert Function dialogue box.
Shift + F5: Opens the Find and Replace dialogue box.
Ctrl + Shift + Colon (:): Enter the current time.
Ctrl + Semicolon (;): Enter the current date.
Ctrl + A: Select all content in the worksheet.
Ctrl + B: Bold highlighted selection.
Ctrl + I: Italicize highlighted selection.
Ctrl + K: Open the Insert hyperlink dialogue box.
Ctrl + U: Underline highlighted selection.
Ctrl + 5: Apply strikethrough formatting.
Ctrl + P: Brings up the print dialog box.
Ctrl + Z: Undo.
Ctrl + F9: Minimize a workbook window to an icon.
Ctrl + F10: Maximize a selected workbook window.
Ctrl + F6: Switch to the next workbook window when multiple are open.
Ctrl + Page Up: Move to the previous sheet in a workbook.
Ctrl + Page Down: Move to next sheet in a workbook.
Ctrl + Tab: Switch to next tab in dialogue box.
Ctrl + Apostrophe (‘): Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + !: Apply the Number format.
Ctrl + Shift + $: Apply the Currency format.
Ctrl + Shift + #: Apply the Date format.
Ctrl + Shift + %: Apply the Percentage format.
Ctrl + Shift + ^: Apply the Exponential format.
Ctrl + Shift + @: Based on the article, it is to apply the time format.
Ctrl + Arrow Key: Move to the edge of the current data region in a worksheet.
Ctrl + Space: Select an entire column in a worksheet.
Shift + Space: Select an entire row in a worksheet.

READ ALSO: Microsoft Word Shortcut Keys: Full List of Shortcut Keys for MS Word

Share to Facebook Share to Twitter More...
{ 0 comments… add one }

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.