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

7 Responses to “CP014: How to create awesome dashboards – 10 step process for you”

  1. Paul says:
    July 20, 2014 at 2:37 pm

    Very interested in topic unfortunately I get no sound when I play it.

    Reply
  2. Budala Ebnezer says:
    July 25, 2014 at 4:42 am

    Where can I get add ins for excel 2007

    Reply
  3. Andy Serna says:
    July 25, 2014 at 7:48 pm

    I would like to join your email newsletter.

    Reply
  4. Shashank Verma says:
    February 25, 2015 at 5:53 am

    Hello Chandoo,
    i am one of the great fan of your. i am one MIS executive in realstate company.And i try make dash board for CRM(Client Relation Management) Dept formance and anlysis process.Its get created not so effective according to can u suggest me .what i hve to give or take for makeing it for effective and attractive?.

    regards,
    Shashak verma

    Reply
  5. Amit Kulkarni says:
    June 7, 2016 at 8:27 pm

    Hi,

    I want to create an interactive dashboard in excel (Google Drive) which should have multiple data along with beautiful charts..

    I handle two teams in IT Tech support so were preparing 2 different dashboards.. however need to club and want to create single report, can anyone help something like

    Reply

Leave a Reply