Hyperlinking to a website in Excel


To create a link to a website, firstly we need to go to the Insert tab and select Link. This will then open the Insert Hyperlink window. On the left-hand side select Existing File or Webpage. Next, in the Text to Display box, type in the text that you want to have as the Link. At the bottom of the window in the address bar type in the URL address of the website you want to link too. Finally click Ok and you will now have the link in your spreadsheet. 



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

Hyperlinking to a file in Excel


To create a link to a website, firstly we need to go to the Insert tab and select Link. This will then open the Insert Hyperlink window. On the left-hand side select Existing File or Webpage. Next, in the Text to Display box, type in the text that you want to have as the Link. In the Navigation Pane select search for the file you want to link too. Finally click Ok and you will now have the link in your spreadsheet. 



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

How to delete a row in Excel


If you want to delete a row of data from a spreadsheet then right click on the row number and select Delete from the menu.



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

How to delete a column in Excel


If you want to delete a column of data from a spreadsheet then right click on the column letter and select Delete from the menu.



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

How to delete multiple rows in Excel


If you want to delete multiple rows of data from a spreadsheet then select the rows you want to delete. Next, right click on a row number you have selected and click Delete from the menu.



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

How to delete multiple columns in Excel


If you want to delete multiple columns of data from a spreadsheet then select the columns you want to delete. Next, right click on a column number you have selected and click Delete from the menu.



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

How to split your screen in excel?


If you want to split your screen so you can see multiple areas of a spreadsheet at a time, then why not got give the Split tool ago. 

To use the tool, select the cell on your spreadsheet that you want to be the cross-section of the split and then go to the View tab. On the Ribbon click on Split and this will split your screen into quarters. You can then use the multiple scroll bars across the bottom and right hand side to navigate around your data. 



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

How to hide a worksheet


If there is a worksheet in your spreadsheet that you don’t want to see, then you can use the Hide tool.

To use this tool, right click on the sheet tab that you want to hide and then from the menu select Hide. This will then Hide the selected sheet.



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

How to unhide a worksheet


If you have hidden a worksheet then you may also need to unhide it. To unhide a worksheet, right click on a sheet tab and select unhide. From the unhide window, select the worksheet you want to unhide and click OK. 



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

How to hide an Excel window


If you want to hide an excel window whilst you’re working on another task, then you can use the Hide tool. This will hide the window and your formulas will still be able to reference the hidden sheet.

To hide a window, go to the View tab and select Hide on the Ribbon. This will then hide the window. 



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

How to unhide an Excel window


If you want to unhide an Excel window, then select the View tab and click on Unhide. This will open the Unhide window. Select the window you want to unhide and then click OK.



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

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.