Excel Shortcuts Part 1 – the F1 and F11 function keys and undo/redo shortcut keys, have you used them? Watch the video to learn more

Excel shortcuts part 1: Excel iconThis week’s hint and tip is on Excel shortcuts part 1. Part 1 of these shortcuts covers the function buttons F1 and F11 and also the shortcut keys for undo and redo. These are covered in our courses but we decided to do a hint and tip on them as well. We are going to go through them now below.

 

F1 Function Key

The F1 is a universal function key shortcut within the Microsoft Office packages for Help. Pressing this key when you are within Excel will bring up the side pane for Help where you can search for the issue or problem you have.

F1 key brings up help screen

As well as this, it also has another shortcut feature when used with the Ctrl key on your keyboard. If you hold down the Ctrl key and then press the F1 key on your keyboard it will hide the ribbon at the top of your screen. When the ribbon is hidden on your screen, pressing the shortcut combination again displays the ribbon.

Excel shortcuts part 1: Ctrl and F1 key hides ribbon in Excel

 

F11 Function Key

The F11 is a very useful and powerful function key within the Excel package as it can be used to create a chart! Once you have selected your data, pressing the F11 key will quickly produce a chart in your spreadsheet. This can be very useful as it saves time when creating charts.

Select data and press F11 key produces a chart

As well as this shortcut, the F11 key has another shortcut feature when used alongside the Shift key on your keyboard. If you hold down the Shift key and then press the F11 key it will insert a new worksheet in your spreadsheet.

Holding down Shift key and pressing F11 produces a blank new worksheet

 

Shortcut Keys for Undo and Redo

There are lots of shortcut key combinations in all of the Microsoft Office packages and we are going to go through 2 now. These shortcut key combinations can be used in all of the other Microsoft Office packages as well. The shortcut keys we are looking at are for Undo and Redo. Undo is often used a lot more than Redo but having the shortcuts for both can still be very useful.

The shortcut key combination for Undo is the Ctrl key and the letter Z on your keyboard. Whereas the shortcut key combination for Redo is the Ctrl key and the letter Y on your keyboard. Using this shortcuts can save you time when working in Excel on a daily basis.

Pressing Ctrl key and Z key for undo and Ctrl key and Y key for redo

 

Summary of the Shortcuts above…

  • F1: Brings up Help
  • Ctrl+F1: Hides or displays the ribbon
  • F11: Creates a chart after selecting data
  • Shift+F11: Inserts a blank new worksheet
  • Ctrl+Z: Undo
  • Ctrl+Y: Redo

 

The video below shows you how you can use these shortcuts in your spreadsheets to save you time. Some of these you might know already but some you might not!

Take a look below at the video to find out more and then try them out on your own computer!

We hope you have enjoyed this hint and tip on Excel shortcuts part 1. Why not take a look at our previous video hint and tip on how to create the beep sound in Excel?
Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy