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)
|
No comments:
Post a Comment