MICROSOFT EXCEL SHORTCUTS

MICROSOFT EXCEL

  • Microsoft Excel is a spreadsheet application.
  • It is a part of MS Office.
  • It features Calculation, graphic tools, Pivot tables and a macro programming language called Visual Basic for Application (VBA).

MICROSOFT EXCEL SHORTCUTS

 

Shortcut Keys

Shortcut keys Description
F2 Edit the select cell
F5 Go to the specific cell
F7 Spell check selected text and /or document
F11 Create a chart
Ctrl +Shift+; Enter the current time
Ctrl+; Enter the current date
Alt+Shift +F1 Insert a new worksheet
Shift+F3 Open the excel formula window
Shift+F5 Bring up search box
Ctrl+A Select all the contents of the worksheet
Ctrl+B Bold highlighted section
Ctrl+I Italic highlighted section
Ctrl +K Insert Link
Ctrl +U Underline highlighted section
Ctrl +5 Strike through highlighted section
Ctrl+P Bring up the control dialog box to begin printing
Ctrl +Z Undo last section
Ctrl + F9 Minimize current window
Ctrl+ F10 Minimize currently selected window
Ctrl +F6 Switched between work books/ windows
Ctrl+Page Down/Ctrl+Page Up Move to the next / previous worksheet in current workbook.t
Ctrl + Tab Move between two or more open Excel files
Alt+ = Create a formula to sum all of the above cells
Ctrl + ‘ Insert the value of the above cell into cell currently selected
Ctrl + Shift + ! Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Ctrl+Shift+$ Apply the Currency format with two decimal places.
Ctrl+Shift+# Apply the Date format with the day, month, and year
Ctrl+Shift+% Apply the Percentage format with no decimal places
Ctrl+Shift+@ Apply the Time format with the hour and minute, and indicate A.M. or P.M.
Ctrl+y Redo last action (multiple levels)