Hyperlinking to a Sheet in your Workbook


A hyperlink can be used to quickly navigate to another sheet within your workbook. This is useful if you have a lot of sheets, as it will save you from having to click through the sheets trying to find the one you want.

1. Select the cell you want the link to appear in

2. Go to the Insert tab, and in the select Links group select Link

3. In the text to display box, type the text that you want to use as your link

4. On the left-hand side of the window, select Place in this Document

5. From the worksheets listed, select the sheet you want to link to

6. Click OK



This content is aimed at the Intermediate level.   Click here to view our course overview.

How to Edit a Hyperlink


If you want to edit the way a hyperlink, right click on the hyperlink and click on Edit Hyperlink in the menu. This will open the Edit Hyperlink window where you can now change the way your hyperlink works. 



This content is aimed at the Intermediate level.   Click here to view our course overview.

Adding a ScreenTip to a Hyperlink


If you want to personalise your hyperlink, then why not add a ScreenTip. A ScreenTip is a message that gives the user an instruction on what to do with the link. This message will appear when the user hovers over the link. 



This content is aimed at the Intermediate level.   Click here to view our course overview.

How to use the transpose paste function?


If you want to restructure your data so the headers are along the top row rather than the left column or vice versa then why not try the transpose paste option. 

To do this, select your data that you want transpose and copy it. Next, click on the cell you want the data to be pasted and then right click and choose the Transpose option under Paste Options. 



This content is aimed at the Introduction level.   Click here to view our course overview.

How can I move columns of data quickly?


Are you fed up with having to insert a column and then copy and pasting data? Well how about trying this shortcut. Select the data you want to move and use the Click and Drag cursor to move the data. Whilst dragging the data, hold down the shift key. This will let you place data in between columns that have existing data in them.



This content is aimed at the Intermediate level.   Click here to view our course overview.

How to delete comments in my spreadsheet?


If you’ve got any unwanted comments in your spreadsheet, then why not delete them. Just select the cell you want to delete the comment from, right click and select Delete Comment. 



This content is aimed at the Intermediate level.   Click here to view our course overview.

How to place a picture in a cell comment in Excel?


Instead of having text in a comment, how about using a picture. Right click on the cell you want to add a comment to and select add comment. Right click on the comment and select Format Comment and choose Colours and Lines. Once there go into the colour dropdown and select Fill Effects and choose the image you want.



This content is aimed at the Advanced level.   Click here to view our course overview.

How to rename sheets?

Struggling to keep track of what each worksheet shows. Then use the sheet renaming tool to make Worksheets easier to work with.


How to use the Sheet Renaming tool

1. Right click on the sheet tab you want to rename.

2. Select Rename and type in the new sheet name.

3. Press enter to confirm the new name.


This content is aimed at the Introduction level.   Click here to view our course overview.

How to recolour excel tabs?

If you want to colour code your spreadsheet tabs, you can in a couple of easy steps.


How to recolour tabs

1. Right click on a sheet tab and click Tab Colour

2. Select a colour from the colour chart



This content is aimed at the Introduction level.   Click here to view our course overview.

How to freeze panes in Excel?

Isn’t it annoying when you scroll down your spreadsheet and your data headings disappear. If we use Freeze Panes, your headings will remain static. 


How to Freeze Panes

1. Select a cell directly below your headings 

2. Go to the View tab > Window group > Freeze Panes and in the dropdown, select Freeze Panes.



This content is aimed at the Intermediate level.   Click here to view our course overview.

How do I insert a column in Excel?


How to Insert a Column

1. Right click on the letter to right of where you want the column to be added. For example, to insert a column between column C and D we would right click on column header D. 

2. Select Insert from the menu



This content is aimed at the Introduction level.   Click here to view our course overview.

How do I insert a row in Excel?


How to Insert a row

1. Right click on the row number below the row that you want the row to be added. For example, to insert a row between row 8 and 9 we would right click on row number 9. 

2. Select Insert from the menu



This content is aimed at the Introduction level.   Click here to view our course overview.

How to copy a spreadsheet in Excel?

Copying a worksheet to another location, such as another workbook or even in the same workbook, takes just a few steps. Below is an explanation on how to copy a worksheet.


1. Right click on the sheet you want to copy and choose Move or Copy

2. In the ‘To book’ dropdown select the workbook you want to copy the sheet too

3. Select where you want it to be pasted in the workbook

4. Check the Create a Copy box then click OK


This content is aimed at the Intermediate level.   Click here to view our course overview.

How to input a comment into a cell?

Have you ever looked at a spreadsheet and wondered what the data in a cell is showing? By using Comments, you can give a brief explanation of what the cell contains.


1. Right click on the cell you want to place a comment in and select Insert Comment

2. Type into the box the comment you want to add


This content is aimed at the Intermediate level.   Click here to view our course overview.

How do I move data to another cell in Excel?


If you want to move data to another location, use the Cut tool. It’s easy to use, just select the data you want to move then go to the Home tab > Clipboard and select Cut, then choose the cell you want the data to be placed in and then go to Home tab > Clipboard and select Paste. If you’re a fan of shortcuts, use CTRL + X to cut and CTRL + V to paste.


This content is aimed at the Introduction level.   Click here to view our course overview.

How do I copy data to another cell in Excel?


If you want to replicate data, use the Copy tool. It’s easy to use, just select the data you want to copy then go to the Home tab > Clipboard and select Copy, then choose the cell you want the data to be placed in and then go to Home tab > Clipboard and select Paste. If you’re a fan of shortcuts, use CTRL + C to copy and CTRL + V to paste.



This content is aimed at the Introduction level.   Click here to view our course overview.

How to select a whole spreadsheet?

You can select all the cells in a spreadsheet by clicking one button. Just select the triangle in the top left corner as shown in the image. This will then select all your spreadsheet. You can also use the shortcut CTRL + A to select all the cells in a spreadsheet.


This content is aimed at the Introduction level.   Click here to view our course overview.

How do I quickly shift between different workbooks?


When working with many different workbooks in Excel, it can be time consuming to manually click between workbooks. So how about using the shortcut CTRL + TAB to quickly jump from different workbooks.



This content is aimed at the Intermediate level.   Click here to view our course overview.

How to quickly navigate around a spreadsheet?

If you want to navigate around a spreadsheet quickly, how about using a shortcut. By using the CTRL + Arrow Keys you can quickly jump to data. For example, if you press CTRL + Down Arrow, it will move you to the bottom line of data.

If you want to jump back to cell A1 quickly, try the shortcut CTRL + Home. 

To move down a spreadsheet quickly, use the Page Down button on your keyboard. Then if you want to move quickly up your spreadsheet, use the Page Up button on your keyboard.



This content is aimed at the Introduction level.   Click here to view our course overview.