Webhosting in Pakistan
Results 1 to 2 of 2

Thread: MicroSoft Excel short cuts

  1. #1
    khurshid akhtar is offline Junior Member
    Last Online
    1st November 2011 @ 11:26 PM
    Join Date
    15 Jan 2008

    Smile MicroSoft Excel short cuts

    Webhosting in Pakistan
    Excels Keyboard Shortcuts

    Shortcut key
    Action Menu equivalent comments Version
    Ctrl+A Select All None All
    Ctrl+B Bold Format, Cells, Font, Font Style, Bold All
    Ctrl+C Copy Edit, Copy All
    Ctrl+D Fill Down Edit, Fill, Down All
    Ctrl+F Find Edit, Find All
    Ctrl+G Goto Edit, Goto All
    Ctrl+H Replace Edit, Replace All
    Ctrl+I Italic Format, Cells, Font, Font Style, Italic All
    Ctrl+K Insert Hyperlink Insert, Hyperlink Excel 97/2000
    Ctrl+N New Workbook File, New All
    Ctrl+O Open File, Open All
    Ctrl+P Print File, Print All
    Ctrl+R Fill Right Edit, Fill Right All
    Ctrl+S Save File, Save All
    Ctrl+U Underline Format, Cells, Font, Underline, Single All
    Ctrl+V Paste Edit, Paste All
    Ctrl W Close File, Close Excel 97/2000
    Ctrl+X Cut Edit, Cut All
    Ctrl+Y Repeat Edit, Repeat All
    Ctrl+Z Undo Edit, Undo All
    F1 Help Help, Contents and Index All
    F2 Edit None All
    F3 Paste Name Insert, Name, Paste All
    F4 Repeat last action Edit, Repeat. Works while not in Edit mode. All
    F4 While typing a formula, switch between absolute/relative refs None All
    F5 Goto Edit, Goto All
    F6 Next Pane None All
    F7 Spell check Tools, Spelling All
    F8 Extend mode None All
    F9 Recalculate all workbooks Tools, Options, Calculation, Calc,Now All
    F10 Activate Menubar N/A All
    F11 New Chart Insert, Chart All
    F12 Save As File, Save As All
    Ctrl+: Insert Current Time None All
    Ctrl+; Insert Current Date None All
    Ctrl+" Copy Value from Cell Above Edit, Paste Special, Value All
    Ctrl+' Copy Fromula from Cell Above Edit, Copy All
    Shift Hold down shift for additional functions in Excel's menu none Excel 97/2000
    Shift+F1 What's This? Help, What's This? All
    Shift+F2 Edit cell comment Insert, Edit Comments All
    Shift+F3 Paste function into formula Insert, Function All
    Shift+F4 Find Next Edit, Find, Find Next All
    Shift+F5 Find Edit, Find, Find Next All
    Shift+F6 Previous Pane None All
    Shift+F8 Add to selection None All
    Shift+F9 Calculate active worksheet Calc Sheet All
    Shift+F10 Display shortcut menu None All
    Shift+F11 New worksheet Insert, Worksheet All
    Shift+F12 Save File, Save All
    Ctrl+F3 Define name Insert, Names, Define All
    Ctrl+F4 Close File, Close All
    Ctrl+F5 XL, Restore window size Restore All
    Ctrl+F6 Next workbook window Window, ... All
    Shift+Ctrl+F6 Previous workbook window Window, ... All
    Ctrl+F7 Move window XL, Move All
    Ctrl+F8 Resize window XL, Size All
    Ctrl+F9 Minimize workbook XL, Minimize All
    Ctrl+F10 Maximize or restore window XL, Maximize All
    Ctrl+F11 Inset 4.0 Macro sheet None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro All
    Ctrl+F12 File Open File, Open All
    Alt+F1 Insert Chart Insert, Chart... All
    Alt+F2 Save As File, Save As All
    Alt+F4 Exit File, Exit All
    Alt+F8 Macro dialog box Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions Excel 97/2000
    Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor Excel 97/2000
    Ctrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create All
    Ctrl+Shift+F6 Previous Window Window, ... All
    Ctrl+Shift+F12 Print File, Print All
    Alt+Shift+F1 New worksheet Insert, Worksheet All
    Alt+Shift+F2 Save File, Save All
    Alt+= AutoSum No direct equivalent All
    Ctrl+` Toggle Value/Formula display Tools, Options, View, Formulas All
    Ctrl+Shift+A Insert argument names into formula No direct equivalent All
    Alt+Down arrow Display AutoComplete list None Excel 95
    Alt+' Format Style dialog box Format, Style All
    Ctrl+Shift+~ General format Format, Cells, Number, Category, General All
    Ctrl+Shift+! Comma format Format, Cells, Number, Category, Number All
    [email protected] Time format Format, Cells, Number, Category, Time All
    Ctrl+Shift+# Date format Format, Cells, Number, Category, Date All
    Ctrl+Shift+$ Currency format Format, Cells, Number, Category, Currency All
    Ctrl+Shift+% Percent format Format, Cells, Number, Category, Percentage All
    Ctrl+Shift+^ Exponential format Format, Cells, Number, Category, All
    Ctrl+Shift+& Place outline border around selected cells Format, Cells, Border All
    Ctrl+Shift+_ Remove outline border Format, Cells, Border All
    Ctrl+Shift+* Select current region Edit, Goto, Special, Current Region All
    Ctrl++ Insert Insert, (Rows, Columns, or Cells) Depends on selection All
    Ctrl+- Delete Delete, (Rows, Columns, or Cells) Depends on selection All
    Ctrl+1 Format cells dialog box Format, Cells All
    Ctrl+2 Bold Format, Cells, Font, Font Style, Bold All
    Ctrl+3 Italic Format, Cells, Font, Font Style, Italic All
    Ctrl+4 Underline Format, Cells, Font, Font Style, Underline All
    Ctrl+5 Strikethrough Format, Cells, Font, Effects, Strikethrough All
    Ctrl+6 Show/Hide objects Tools, Options, View, Objects, Show All/Hide All
    Ctrl+7 Show/Hide Standard toolbar View, Toolbars, Stardard All
    Ctrl+8 Toggle Outline symbols None All
    Ctrl+9 Hide rows Format, Row, Hide All
    Ctrl+0 Hide columns Format, Column, Hide All
    Ctrl+Shift+( Unhide rows Format, Row, Unhide All
    Ctrl+Shift+) Unhide columns Format, Column, Unhide All
    Alt or F10 Activate the menu None All
    Ctrl+Tab In toolbar: next toolbar None Excel 97/2000
    Shift+Ctrl+Tab In toolbar: previous toolbar None Excel 97/2000
    Ctrl+Tab In a workbook: activate next workbook None

  2. #2
    Tanha Hassan's Avatar
    Tanha Hassan is offline Senior Member+
    Last Online
    14th December 2012 @ 03:54 PM
    Join Date
    24 Nov 2007
    Achi pari k Pass


    Webhosting in Pakistan
    nice effort brother.....but is ko aap proper section main post karyin na

Similar Threads

  1. Solved short cuts need
    By Kashifkl in forum Solved Problems (IT)
    Replies: 5
    Last Post: 8th October 2011, 06:22 PM
  2. Chating Short Cuts
    By ~*SEEP*~ in forum Baat cheet
    Replies: 46
    Last Post: 12th October 2009, 08:56 PM
  3. >>>Microsoft EXCEL 2003 Short Keys<<<
    By xXxpert in forum General Discussion
    Replies: 5
    Last Post: 29th July 2009, 10:23 AM
  4. Short cuts
    By assanjan in forum General Discussion
    Replies: 6
    Last Post: 24th July 2008, 09:52 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts