Excel keyboard shortcuts

Sharing is caring!

This list gives you a glance of (nearly) all shortcut combinations in Excel. Please take the time to read it. I’m sure you’ll find many of them useful.

Below is a listing of all the major shortcut keys usable in Microsoft Excel. See the computer shortcuts page if you are looking for shortcut keys used in other programs.

ms excel shortcut keys

Shortcut Description
F2 Edit the selected cell.
F3 After a name has been created, F3 will paste names.
F4 Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text or document.
F11 Create chart from selected data.
Ctrl+Shift+; Enter the current time.
Ctrl+; Enter the current date.
Alt+Shift+F1 Insert New Worksheet.
Alt+Enter While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell.
Shift+F3 Open the Excel formula window.
Shift+F5 Bring up search box.
Ctrl+1 Open the Format Cells window.
Ctrl+A Select all contents of the worksheet.
Ctrl+B Bold highlighted selection.
Ctrl+I Italic highlighted selection.
Ctrl+K Insert link.
Ctrl+S Save the open worksheet.
Ctrl+U Underline highlighted selection.
Ctrl+D Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.
Ctrl+R Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.
Ctrl+1 Change the format of selected cells.
Ctrl+5 Strikethrough highlighted selection.
Ctrl+P Bring up the print dialog box to begin the printing process.
Ctrl+Z Undo last action.
Ctrl+F3 Open Excel Name Manager.
Ctrl+F9 Minimize current window.
Ctrl+F10 Maximize currently selected window.
Ctrl+F6 Switch between open workbooks or windows.
Ctrl+Page up Move between work sheets in the same document.
Ctrl+Page down Move between work sheets in the same document.
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 the cell currently selected.
Ctrl+Shift+1 Format number in comma format.
Ctrl+Shift+4 Format number in currency format.
Ctrl+Shift+3 Format number in date format.
Ctrl+Shift+5 Format number in percentage format.
Ctrl+Shift+6 Format number in scientific format.
Ctrl+Shift+2 Format number in time format.
Ctrl+Arrow key Move to next section of text.
Ctrl+Space Select entire column.
Shift+Space Select entire row.
Ctrl+- Delete the selected column or row.
Ctrl+Shift+= Insert a new column or row.
Ctrl+Home Move to cell A1.
Ctrl+~ Switch between showing Excel formulas or their values in cells.

 

 

Comments 66

  • Hello! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My blog looks weird when viewing from my iphone 4. I’m trying to find a template or plugin that might be able to resolve this problem. If you have any suggestions, please share. Thank you!

  • Nice article for the easy shortcuts on excel. It helps in making excel workflow a bit faster. Keep updating. Ashish

  • Hi, I do think this is a great web site. I stumbledupon it 😉 I will return yet again since I bookmarked it. Money and freedom is the best way to change, may you be rich and continue to guide other people.

  • Have you ever thought about writing an ebook or guest authoring on other sites? I have a blog centered on the same ideas you discuss and would really like to have you share some stories/information. I know my audience would appreciate your work. If you are even remotely interested, feel free to shoot me an e mail.

  • Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you can do with a few pics to drive the message home a little bit, but other than that, this is fantastic blog. A fantastic read. I’ll certainly be back.

  • One of the most popular ways is to seek out a wholesale liquidator who focuses
    on sneakers.

  • Surfing is not the toughest sport but it surely should be on this checklist because it takes dedication and lots of energy to do it.

  • Various top manufacturers release sneakers shoes of different designs and
    style every year and all of them sell nicely.

  • Whether buying the highly popular and desired Adidas forest hills or your investing in a celebrity, you
    might be certain it’s a shoe that’s incomparable.

  • Zainteresowany ostatnio firmami produkującymi sprzęt do tenisa ziemnego w tym i rakietami
    tenisowymi napotkałem na zagranicznej stronie rakiety tenisowe firmy Adidas.

  • Replace sneakers which have worn out and, as a rule, purchase running shoes which can be half a
    dimension larger than your normal shoe size to permit the foot to maneuver.

  • Are you looking for dog gates for stairs?

  • Adidas withdrew the suit, and the two groups established guidelines as to what three-stripe
    designs would be thought-about uses of the Adidas trademark.

  • We want to keep him securely in his room.

  • Its design is implausible and the price is cheap.

  • Regarding assists, though Jordan was a guard, he hardly ever introduced the ball up the court docket.

  • The beauty worth of the shoes are obviously sacrificed
    to a great extent to fulfill this objective.

  • My grand daughter is now kept firmly downstairs.

  • For more information about Creighton University’s renewable energy project, please
    visit If you reside in Omaha, Nebraska or the surrounding metropolitan area and are contemplating or have completed a solar energy
    project, please send me an email describing the initiative and your contact information to
    [email protected] Selamat menikmati informasi
    yang kami sajikan dan semoga informasi ini dapat membantu
    anda dalam bermain judi online dan taruhan bola. This array is
    approximately 10 feet above ground at the lowest point.

  • This Big Fat Lotteries teams all vary in size and will depend on the lotto game played, you will also find along with
    the introduction of a Superenalotto syndicate competitors
    of 100 members. “Each time of year has something that
    sets it apart from others. This array is approximately 10 feet above
    ground at the lowest point.

  • Thank you a bunch for sharing this with all of us you actually recognize what you’re speaking about!
    Bookmarked. Please also discuss with my site =). We could have a hyperlink change contract between us

  • I actually admire your skill to listen to from the
    Lord and share on a unorthodoxed subject of shoes.

  • Menjadi Konsultan SEO: Sebuah Jasa seo murah
    Memulai bisnis di internet memang tidak mudah karena peluang yang ada sering sulit ditemukan. Meskipun sudah menemukan peluang bisnis, seseorang sering tidak
    mampu melakukan yang terbaik untuk sukses.
    jasa seo murah tentu sangat erat kaitannya dengan penjualan produk atau jasa.

    Dan salah satu yang bisa dipilih asalah menjadi konsultan SEO.
    Bisnis jenis ini sedang menjadi idola karena banyak dibutuhkan oleh orang banyak.
    Apa itu bisnis konsultan SEO? Mungkin anda bertanya tentang salah satu dari jasa
    seo murah ini.

    Sebelum kita banyak membahas tentang bisnis konsultan SEO tentu harus dipahami dulu apa
    yang dimaksud dengan SEO itu sendiri. SEO adalah singkatan dari
    search engine optimization yang merupakan sistem untuk membuat website lebih
    terindeks oleh search engine khususnya Goole.
    Setiap orang yang mempunyai website tentu ingin websitenya ada di urutan teratas pencarian Google.
    Terkait dengan hal ini, SEO akan membuat apa yang diperlukan agar rank
    atau traffic website bisa lebih baik.

    Tentu untuk memulai jasa seo murah dengan menjadi konsultan SEO
    memerlukan keahlian khusus. Dan salah satu faktor yang menentukan kesuksesan bisnis ini adalah bukti.
    Maksudnya adalah jasa SEO yang ditawarkan benar-benar bisa membuat peringkat website di search engine lebih baik.

    Bila hal ini bisa terjadi, sudah bisa dipastikan menjadi konsultan SEO akan mendatangkan hasil yang memuaskan.

    Kunjungi website kami site di Jasa SEO Terbaik

  • Nike’s new plan of introducing Nike air max 24-7 and Nike self-lacing
    shoes combines entertainment and sports activities together.

  • magnificent issues altogether, you just gained a emblem new reader. What may you recommend about your publish that you made some days ago? Any certain?

  • Have you ever thought about adding a little bit more than just your articles?
    I mean, what you say is fundamental and all. But just imagine if you added some great
    visuals or videos to give your posts more, “pop”!
    Your content is excellent but with pics and video clips, this website
    could undeniably be one of the best in its
    niche. Terrific blog!

  • Internet hype may cause these footwear to promote for thousands of dollars typically.

  • There exist numerous Adidas sneakers which adopt
    suede, canvas, leather and other forms as their materials in order to make
    these sneakers appropriate for many activities and give individuals nice comfort.

  • The larger spending, along with funding in more of its own shops, prompted
    Adidas to chop its target for working margins – working revenue as a
    share of gross sales – to six.5-7.0 % for 2014 from 8.5-9.zero percent beforehand.

  • For a slightly more scientific treatise on the benefits of working slowly, check out the Maffetone Method, by Phil Maffetone,
    M.D.

  • Say I adore you with this Valentine’s Day
    reward basket.

  • In this fashion, Nike is ready to reach a wide variety of consumers and consumers who usually tend to buy.

  • Okay,? Leee mentioned after wһich he stopped аnd thought.

    ?Ꭲhe perfect factor about Ԍod is ??? hmmmm?????..?
    He pսzzled because he haad so many іssues that were nice
    about God buut he needed to pick the most effеctive
    one so hhe would wiin the game. ?That hhe knows everything.
    That?s actuallу cool. Meaning he will help me with my
    һomeԝork.? Larry concluded with a proud expression on his face.

  • WE WΙᒪᒪ.? They both shouted they usually ran to the beɗ
    roopm bickering about who will gget to go first.

  • Not just sports activities shoes, we now have the widest assortment of adidas floaters as well.

  • These Adidas SL72’s were mainly seen on the podiums of the 1972 Olympics
    and have gained a cult following amongst many.

  • For stubborn stains that do not reply to brushing,
    choose up a suede shampoo and use a damp sponge to use a
    small quantity of suede cleaner to your stained shoes.

  • Nike did bring these back into manufacturing a few years ago and I
    bought a few pair.

  • Thoroughly, I long inquired about to have the ability to arise when it
    comes to UGG sneakers and likewise a denim mponyiskirt and
    longest tail.

  • Kobe’s legacy in the footwear world has rightfully earned him a
    legion of followers and helped shift the styling of
    modern basketball sneakers.

  • El Institute of Biomechanics of Valencia (IBV) and the Spanish shoe
    firm KELME have designed a prototype working shoe with an built-in gadget that improves training
    management and prevents accidents.

  • Joachimsthaler, who has consulted for Adidas for years however is at the moment
    working with Nike, is aware of Liedtke effectively but doubts he will
    depart radically from the course set by Hainer.

  • Free Run’s have been in the marketplace for numerous years and progressed
    into a variety of delightful types which might be great for men and women.

  • The footwear feature a leather-based upper with a suede toecap
    and the Adidas brand on the outsole for treads.

  • They’re set to launch Saturday February 13, 2016 on in addition to retails comparable to Champs, Foot Locker,
    Foot Action, Jimmy Jazz both in store and
    online.

  • Donc avant d’aller plus loin : le pare-feu!

  • Log within the websites of , or , there, many low-cost Nike shoes with excellent high quality
    can be found.

  • Running benefits who explains from private expertise the numerous benefits accessible together with your God given workout machine.

  • One day whereas shopping in a local metropolis I
    got here across a sports shop and determined to check out what
    have been the perfect sneakers for shin splints they had in inventory.

  • International manufacturers like, Tansmith sneakers
    and Life Stride sneakers have a wonderful collection of leather-based sneakers, oxfords, loafers
    and boots.

  • What you are left with is a $one hundred eighty band that is a high-quality funding if you happen to’re already locked
    into the Under Armour ecosystem.

  • The pricing of boxing sneakers is akin to other footwear, particularly athletic sneakers.

  • In keeping with footlocker, Nike is releasing the
    James Harden HyperChase in a James Harden camo pattern.

  • I visited several blogs except the audio quality for audio songs existing at this web page
    is in fact superb.

  • Hello, after reading this awesome paragraph i am too glad to share my knowledge here
    with colleagues.

  • If you might be an avid basketball participant then it would be best to
    put sturdiness on the top of your checklist.

  • To find these wrestlers try a simple search as soon as you go
    online if Adidas fight speeds, nike kolat pace.

  • Laver wore nylon-mesh uppers to perform the feats and Adidas added a suede cap to the shoe for type.

  • Nike, which declined to remark for this story, has completely given up on releasing excessive-profile sneakers on its SNKRS app, no less
    than as it meant from the beginning Last time a
    restricted release came out, practically a month ago, the applying principally
    acted as a barebones web browser that simply allow
    you to enter the raffle from within.

  • Nike employs a selective- demand commercial targeted on the high priced shoes
    used for traditional sports (Goldman S, 2000, pp154).

  • Excellent post. I used to be checking continuously this
    weblog and I’m inspired! Very helpful information particularly the closing
    section 🙂 I deal with such info much. I used to be seeking this particular info for a long
    time. Thanks and good luck.

  • Shoes for Crews has a 60 day trial interval the place you can return any footwear you don’t like
    for a full refund: no questions asked.

  • Most runners stated that after they’re out of the door, the mind routinely goes
    into operating mode anyway.

  • I had some math challenges on this run…my Garmin was slow to sync up
    initially so I began it a little way into my run.

  • Analysts estimate the share rose to 35 p.c
    in 2015 as Adidas scored catwalk hits with relaunched Stan Smiths and
    Superstar baseball sneakers, both white leather-based styles first standard
    in the Nineteen Seventies that have been reissued in new colours.

  • What’s up colleagues, how is all, and what you would like to say on the topic of this
    article, in my view its in fact remarkable in support of
    me.