In Excel if you want to clear the data but not the formatting of a cell then we can use the Clear Contents tool to do this. 

To use it, firstly select the cells you want to clear. Next go to the Home tab and select Clear. From the dropdown select clear contents. This will then remove any data from them cells.

If you have hyperlinks in your spreadsheet that you want to remove, then you can do so by using the Remove Hyperlinks tool. 

To use it, select the cell that contain the hyperlink. Next go to the Home tab and click on Clear. From the dropdown select Remove Hyperlink. This will clear the Hyperlinks. 

If you have comments in your spreadsheet and you want to remove them, then you can by using the Clear Comments tool.

To use this tool, select the cells that contain comments and then go to the Home tab and select Clear. In the dropdown, select Clear Comments and this will remove them from your spreadsheet.

If you have hyperlinks in your spreadsheet and you want to remove them, then you can by using the Clear Hyperlinks tool.

To use this tool, select the cells that contain Hyperlinks and then go to the Home tab and select Clear. In the dropdown, select Clear Hyperlinks and this will remove the link from your spreadsheet. The formatting will remain.

If you want to clear everything in your spreadsheet then you can use the Clear All tool.

To use this tool, firstly select all the cells that you want to clear. Next, click on the Home tab and select Clear. From the dropdown choose Clear All. This will clear everything that was applied to them cells.

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. 

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. 

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.

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.

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.

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.

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. 

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.

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. 

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. 

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.

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

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. 

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. 

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. 

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.

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. 

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.

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.

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

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.

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

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

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

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

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.

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.

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.

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.

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.