Locked lesson.

Upgrade

About this lesson

A summary of Keyboard Shortcuts.

Exercise files

Download this lesson’s exercise file.

Keyboard shortcuts.xlsx
15.8 KB

Quick reference

Keyboard Shortcuts

Understand the benefits of keyboard shortcuts.

When to use

Working in an Excel document.

Instructions

  • The use of keyboard shortcuts can speed up working in Excel.  The full list can be viewed in the exercise file.
  • An Excel expert is someone who knows 20-30 keyboard shortcuts
  • Some handy shortcuts:
    • F7 – This will do a spell check on the document. Ensure all sheets are highlighted prior to using this shortcut
    • F4 – This has two shortcuts:
      • Redo and edit – which will redo the last action performed
      • Toggle between the formula to insert a dollar sign for cell referencing – note that for this shortcut to work the formulae bar must be selected
    • CTRL + S – This will save the document
    • CTRL + C – This will copy the selected cells
    • CTRL + V – This will paste the copied cells
    • CTRL + Z – This will undo the previous action
    • CTRL + F – This will bring up the ‘Find and Replace’ dialog box so that you can search inside the document
    • ALT + = – This will sum a range of cells

Login to download
  • 00:04 I'm about to talk about layout tips and how to set up a worksheet so
  • 00:09 that it works well in a financial model.
  • 00:13 Before I do that, I need to talk about one other thing.
  • 00:17 The last session was all PowerPoint.
  • 00:19 This one is pretty much all Excel.
  • 00:22 I want to talk about keyboard shortcuts.
  • 00:27 Other people, especially when they're first starting off in Excel,
  • 00:30 use the mouse.
  • 00:30 It's intuitive, it's useful for things like hyperlinks and placement,
  • 00:34 positioning.
  • 00:35 Which I think is the same thing as placement most of the time.
  • 00:39 Whereas a keyboard can be a way of speeding up working in Excel
  • 00:43 if you are that sort of person.
  • 00:45 And there's lots of keyboard shortcuts.
  • 00:48 The screenshot example here in this slide shows 546,
  • 00:52 and that's because by my reckoning, they are presently 546 shortcuts.
  • 00:59 Now, here's something you might like.
  • 01:01 You may have seen something like this on websites elsewhere but this is, as far as
  • 01:06 I can tell, the most comprehensive list of Excel shortcuts in existence.
  • 01:11 546 of them to be exact.
  • 01:14 Now, not all of these will work on every single machine.
  • 01:17 It depends what type of chip you've got, whether you're working with
  • 01:20 a personal computer, PC, or a Macbook and what version of Excel you're in.
  • 01:25 But you can see here we have all the different keys you can use.
  • 01:31 I'm going across.
  • 01:32 It might be just pressing the key alone, or the Shift button, or the Ctrl button,
  • 01:38 Alt Shift Ctrl, Shift Alt, Ctrl Alt, and Shift Ctrl Alt.
  • 01:43 Now not all these combinations have actual assignments.
  • 01:48 So, don't get too slighted, there's not trillions of these to actually learn.
  • 01:52 But they say an Excel expert is somebody
  • 01:54 that knows where an awful lot of these are.
  • 01:58 So I've already been through some of these already, in this particular course.
  • 02:03 You can see when we're talking about consistency, I used,
  • 02:06 if I can find it in here, Ctrl \, this one here.
  • 02:09 So Ctrl \ selects unequal cells in rows or columns of selection.
  • 02:16 I've already talked about this.
  • 02:17 You've got this as something you can refer to.
  • 02:19 Treat this as a reference document.
  • 02:20 Where you've actually set it up so
  • 02:22 it should print out nicely on an A3 piece of paper.
  • 02:25 Apologies if you are somewhere in the world where it's letter and not A3, A4.
  • 02:30 You can resize it yourself.
  • 02:33 Now an easy way to resize print out, we'll talk about printing and
  • 02:36 viewing later, is to actually go into page layout, and when you go to page
  • 02:41 setup here it's actually determined what paper size you want here.
  • 02:45 And you can change your paper sizes in here before you decide to print.
  • 02:52 The various ones on here, one your should know, one anyone should know before they
  • 02:57 hit Save, this one for instance, Check Spelling.
  • 03:00 When was the last time you actually reviewed your model
  • 03:03 to see if it actually spell checked?
  • 03:06 Well most people won't.
  • 03:07 Highlight all the sheets, then hit F7 and away you go.
  • 03:10 But there's loads of other ones in here.
  • 03:13 F4 is used for function.
  • 03:16 It will help you to toggle the dollar signs, as I've shown you previously.
  • 03:21 If you're not in the formula bar when you do it though,
  • 03:23 it repeats whatever it is you did last which can be a useful feature in itself.
  • 03:27 The aim really is to get acquainted with this.
  • 03:30 And I will be explaining a lot of these as we go through.
  • 03:33 They say an Excel expert is someone who knowns 20 or
  • 03:36 30 of these keyboard shortcuts.
  • 03:38 So you might want to acquaint yourself as soon as you can.
  • 03:41 This leads us nicely though.
  • 03:43 That if we've got this to hand,
  • 03:44 we can start considering how we're going to layout a model.

Lesson notes are only available for subscribers.

Gift this course