Login to online classes

11 very useful excel keyboard shortcuts you may not know

  • Last updated on July 29, 2008
Picture of Chandoo

Chandoo

Share

Facebook
Twitter
LinkedIn

  1. f4 key – During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
  2. ctrl key+; key – Inserts current date
  3. ctrl key+ – Copies value from cell above to current cell
  4. shift key+f2 key – Edits a cell comment
  5. alt key+f8 key – Opens macro dialog box
  6. alt key+= key – Auto sum selected cells and places value in cell beneath
  7. ctrl key+shift key+$ key – Currency formats current cell
  8. ctrl key+shift key+& key – Applies outline border to selected cells
  9. ctrl key+shift key+! key – Comma formats current cell
  10. shift key+ctrl key+f key – Activates font drop down list
  11. shift key+ctrl key+p key – Activates font point size drop down list

What is your favorite keyboard shortcut / productivity tip?

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my story • FREE Excel tips book

Want an AWESOME
Excel Class?

advanced-excel-dashboards-course-chandoo
Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst

FREE Goodies for you...

Excel formula list - 100+ examples and howto guide for you
100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks
13 Advanced Pivot Table Skills

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Get started with Power BI

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Related Tips

3 Responses to “Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)”

  1. Dermot McGlone says:
    July 14, 2023 at 11:19 am

    Thanks Chandoo, some great helpful tips here. I'm quite good at Excel (mainly thanks to you!) but I'm always learning. I love the link you gave above to Dynamic Arrays & Spill Ranges, I understand them a bit more now, and can see some uses for them.

    Reply
  2. Sean H. says:
    August 15, 2023 at 4:16 pm

    Great to see you back! Enjoyed when you first started the podcast and super excited to start listening to you again!

    Reply

Leave a Reply