Know And Ask

Never Stop Learning

Education know this 

Advance Excel Shortcuts

Amit Singh Rawat_Knowandask 3 Comments , , ,

Advance Excel To Learn

Know this, companies are looking for candidates with skills, make yourself industry ready to learn Advance Excel and Microsoft Word.

Check below few shortcut keys and make sure to use these while working on Excel.

Microsoft excel

Few Advance Excel Shortcuts:

F1 = For help

F2 = To Edit

F3 = Paste Name

F4 = Repeat Last Action

F5 = Go To

F6 = Next Pane

F7 = Spelling Check

F8 = Extend mode

F9 = Recalculate All Workbooks

F10 = Activate Menubar

F11 = New Chart

F12 = Save As

Advance Excel Shift+ functions:

Microsoft excel #knowandask

Shift+F1 = What’s This?

Shift+F2 = Edit Cell Comment

Shift+F3 = Paste Function Into Formula

Shift+F4 = Find Next

Shift+F5 = Find

Shift+F6 = Previous Pane

Shift+F8 = Add To Selection

Shift+F9 = Calculate Active Worksheet

Shift+F10 = Display Shortcut Menu

Shift+F11 = New Worksheet

 

Shift+F12 = Save

 

Also read at knowandask:

Microsoft word Shortcuts To Learn.

Advance Excel Ctrl + functions:

Ctrl+F3 = Define Name

Ctrl+F4 = Close

Ctrl+F5 = Restore Window Size XL

Ctrl+F6 = Next Workbook Window

Ctrl+F7 = Move Window

Ctrl+F8 = Resize Window

Ctrl+F9 = Minimize Window

Ctrl+F10 = Maximize or Restore Window

Ctrl+F11 = Insert 4.0 Macro Sheet

Ctrl+F12 = File Open

Ctrl+A = Select All

Ctrl+B = Bold

Ctrl+C = Copy

Ctrl+D = Fill Down

Ctrl+F = Find

Ctrl+G = Go to

Ctrl+H = Replace

Ctrl+I = Italic

Ctrl+K = Insert Hyperlink

Ctrl+O = Open

Ctrl+P = Print

Ctrl+R = Full Right

Ctrl+S = Save

Ctrl+U = Underline

Ctrl+V = Paste

Ctrl+W = Close

Ctrl+X = Cut

Ctrl+Y = Repeat

Ctrl+X = Undo

Ctrl+X = New Worksheet

Amit Singh Rawat_Knowandask

Amit Singh Rawat: Owner/ Founder of Knowandask a Digital Learning platform to educate yourself learn spread knowledge and share knowledge.

3 thoughts on “Advance Excel Shortcuts”

  • business solutions
    September 9, 2018 at 1:27 pm
    Permalink

    Thanks to my father who informed me regarding this webpage, this web site is truly awesome.

  • KnowandaskPost author
    September 11, 2018 at 5:20 am
    Permalink

    Thanks for your comment, we will definitely keep on updating such information for people.

  • Urvashi Sharma
    May 2, 2022 at 12:38 pm
    Permalink

    Hi….
    Mastering formulae, VBA (Visual Basic for Applications) programming, and other Excel features for managing difficult jobs are all part of advanced Excel skills. Excel can be used for more complicated tasks such as data analytics and simulation by experts.

Leave a Reply

Your email address will not be published.