Webhosting in Pakistan
Results 1 to 4 of 4

Thread: Excel Shortcut Keys

  1. #1
    cuticle is offline Junior Member
    Last Online
    13th January 2008 @ 03:08 PM
    Join Date
    28 Jan 2007

    Default Excel Shortcut Keys

    Webhosting in Pakistan
    Shortcut key

    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
    rizwan's Avatar
    rizwan is offline Senior Member+
    Last Online
    22nd April 2014 @ 02:09 PM
    Join Date
    15 Mar 2006


    1st post dear......nice good start
    Great Keep it Up........Post for some other heavily used Programms/Applications
    Carry on..............

  3. #3
    anjanarishta's Avatar
    anjanarishta is offline Senior Member+
    Last Online
    2nd March 2017 @ 02:04 AM
    Join Date
    20 Aug 2006

    Thumbs up salam sab ko


    nice work ......dekhtay hain kitni command kaam karti hay...

  4. #4
    Zolfiqar's Avatar
    Zolfiqar is offline Senior Member+
    Last Online
    12th December 2009 @ 09:14 AM
    Join Date
    12 Jan 2007


    Webhosting in Pakistan
    very nice dear very nice Sharing

Similar Threads

  1. Microsoft Excel shortcut keys
    By uxpos in forum Excel Course From Zaara
    Replies: 23
    Last Post: 25th December 2017, 05:25 PM
  2. MS Excel Shortcut Keys
    By myousafqureshi in forum Computer Articles
    Replies: 65
    Last Post: 4th June 2015, 01:23 PM
  3. Microsoft Excel - Useful Shortcut Keys
    By IT_DOCTOR in forum General Discussion
    Replies: 10
    Last Post: 8th May 2015, 10:48 AM
  4. Microsoft excel shortcut keys
    By kainat khan in forum General Discussion
    Replies: 0
    Last Post: 21st January 2014, 09:09 AM
  5. Shortcut Keys
    By Hero in forum Ask an Expert
    Replies: 4
    Last Post: 3rd April 2009, 03:20 PM


Posting Permissions

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