Tuesday, July 14, 2015

MicroSoft Excel Shortcut Key with description

Excel Shortcut keys Free With description
For Microsoft Excel , the following lists of shortcuts might be helpful for you, I have compiled the list which contains (Ctrl + ) combination shortcut keys, the list also contain few other common shortcuts which are handy and as well saves your time while you work on Microsoft Excel. The list also include brief descriptions of the shortcuts and its individual functionality in the line of Text Formatting, navigation and Working With Objects.

List of The Excel Shortcut key with description

MicroSoft Excel Shortcut Keys
Shortcut Keys Description
Ctrl + A Select the Entire WorkSheet
Ctrl + B Applies or Removes bold formatting
Ctrl + C Copies the selected cells
Ctrl + D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
Ctrl + F Displays the Find dialog box
Ctrl + G Displays the Go To Dialog box
Ctrl + H Displays the Find and Replace dialog box
Ctrl + I Applies or removes italic formatting
Ctrl + K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks
Ctrl + L Displays the Create List dialog box
Ctrl + N Create a new, blank file
Ctrl + O Displays the Open dialog box to open or find a file
Ctrl + P Displays the Print dialog box
Ctrl + R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right
Ctrl + S Saves the actives file with its current file name, location and file format
Ctrl + U Applies or removes underlining
Ctrl + V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object,Text, or cell contents
Ctrl + W Closes the selected workbook window
Ctrl + X Cuts the selected cells
Ctrl + Y Repeats the last command or action, if possible
Ctrl + Z Uses the Undo command to reverse the last command or to delete the last entry you typed
Ctrl + Shift + Z Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed
Ctrl + Shift + O Select all cells that contain comment
Ctrl + ( Unhides any hidden rows within the selection
Ctrl + ) Unhids any hidden columns within the selection
Ctrl + & Applies the outline border to the selected cells
Ctrl + _ Removes the outline border from the selected cells
Ctrl + ~ Applies the General number format
Ctrl + $ Applies the Currency format with tow decimal places(negative number in parentheses)
Ctrl + % Applies the percentage format with no decimal places
Ctrl + ^ Applies the the Exponential number format with tow decimal places
Ctrl + # Applies the Date format with the day, Month and Year
Ctrl + @ Applies the Time format with the hour and Minute,and Am or Pm
Ctrl + ! Applies the number format with two decimal place,thousnads separator,and minus sign(-) for negative values
Ctrl + - Displays the Delete dialog box to delete the selected cells
Ctrl + * Selects the current region around the active cell(the data area enclose by blank rows and blank columns)
Ctrl + : Enters the Current Time
Ctrl + ; Enters the Current Date
Ctrl + ' Copies a formula from the cell above the active cell into the cell or the Formula Bar
Ctrl + " Copies the value from the cell above the active cell into the cell or the Formula Bar
Ctrl + + Displays the Insert dialog box to insert blank cells
Ctrl + 1 Displays the Format Cells dialog box
Ctrl + 2 Applies or removes bold formatting
Ctrl + 3 Applies or removes italic formatting
Ctrl + 4 Applies or removes Underlining
Ctrl + 5 Applies or removes Strikethrough
Ctrl + 6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects
Ctrl + 7 Displays or hides the Standard toolbar
Ctrl + 8 Displays or hides the Outline Symbols
Ctrl + 9 Hides the selected rows
Ctrl + 0 Hides the selected columns
www.pctutorialsfree.blogspot.com A largest hub of Computer Programming Tutorials,Tips and tricks,Blogger Templates,Computer Fonts,Computer Shorcut Keys, Tutorials in Urdu and Hindi etc
Copyright Reserved By www.pctutorialsfree.blogspot.com
Note: If any mistake in this table, Please contact Us.
Was this Article is Helpful? Share it to your Friends!

No comments:

Post a Comment