Top 10 Favourite Shortcuts in Excel

Top 10 Favourite Shortcuts in Excel

1. CTRL+1 – Format

Format Cells dialiog box

Shortcuts in Excel - InvestinU

2. CTRL+SHIFT+L – Turn on/ off filters

Switching on and off filters on a list of data

3. CTRL+Arrow keys – Navigate around a list or a workbook

If you need to quickly navigate a list or show the total number of columns or rows in a worksheet, Ctrl and the arrow keys make this very easy

4. CTRL+SHIFT+Arrow Keys – Highlighting a list or range of data

Highlight any sized list.

5. F4 – Change cell reference style while editing formulas

Hit the F4 Key:

Once – $A$1

Twice – A$1

Three – $A1

Four – A1

6. F2 – Edit a cell

Edit the contents of the cell your in.

7. F3 – Show Names

For simple workbooks I do not use names. But if I am making a dashboard or Excel model, I define several names and use them all the time. This is where F3 comes in handy. Just press F3, no matter where you are (formula editing, conditional formatting, data validation etc.) and you get a list of all the defined names. Pick one and press ok to add it to the formula etc. you are typing.

8. CTRL+K – Add Hyperlink

Hyperlinks make your work book accessible & pretty. So I use them all the time, especially, if I have more than a couple of sheets. Select a cell or shape and press CTRL+K to launch hyperlink box. Type the destination URL or location and you are done.

9. CTRL+T – Insert Table

Tables are flexible, they can grow & shrink, they allow you to write readable formulas (structural references). Just select any cell in a range of related data, and press CTRL+T to make it table.

10. CTRL+S – Save

There is no point making something elaborate in Excel if you forgot to save. So I press CTRL+S every now and then.

If you found this article helpful InvestinU offers a range of training tools for Microsoft 365 which can be found here.

You can check out our FacebookInstagram, or Linkedin pages for more updates and to get in touch today!

Oct 11, 2013

Eoin Lynch
Shortcuts in Excel

   About InvestinU

   Meet The Team

   In the Media

   Testimonials

  Training

   Bespoke Online Webinars

   Expert Advisory Sessions

   Microsoft 365 Support

   Customised Training

   One-to-one Consultancy

   Bite-Size Learning

   Design

   Document Design

   Template Design

   Redesigning Documents

   Forms Creation (Word or Adobe PDF)

   Design Solutions

   Company Branding

   Logo Design

   Web

   E-commerce Websites

   Brochure Websites

   SEO

   Social Media Management

   Content Creation (Blog)

    Development

   App Development

   Excel Automation

   Excel Dashboards / Reports

   Bespoke Database Systems

    Microsoft Packages

   Invest365 Microsoft Webinars

   Invest365 Microsoft Support

   Expert Advisory Sessions

   Invest365 Microsoft Ultimate