How do I split a cell in Excel?

How do I split a cell in Excel? Link to YouTube video If you've arrived on this page through a Google search, you will be both disappointed and pleased to know that: You can't actually split cells in Excel But you can kind of work around it, so it looks like you've split a cell. OK, so point 1 doesn't need a lot of coverage; there just isn't an option to "split cell" like there is in Microsoft Word.  When I first came across this restriction, I had just begun working with Excel, and I was certain that I just wasn't looking hard enough.  18 years later and I still haven't stumbled across that feature so here's how to work around it instead. So let's imagine you have made the table below, and you decide that you actually want to split column B so that instead of "Name / Surname" you have two separate columns:   Instead of splitting column B (or splitting any of the...
Read More
How do I Divide in Excel?

How do I Divide in Excel?

https://youtu.be/fe34GZCrIwM Link to YouTube video How do I Divide in Excel? We've covered multiplication and subtraction in previous tutorials and videos, but how do we divide in Excel?  This is another commonly searched-for question on Google, and the technique is the same in Excel as it is in Google Sheets.  Once you're familiar with this technique you will have a much better understanding of how Excel works. So let's start off with a very simple calculation; 4 ÷ 2. The number 4 is in cell A1, and number 2 is in cell A2: To begin with, you need to understand that division in Excel is a kind of formula, and whenever you type a formula in Excel you must begin it with the equals symbol =, and the formula is after the equals sign.  Secondly, you need to know that the symbol for divide in Excel is not ÷, it is / (the forward-slash symbol).  So if we want the answer to this sum to be in...
Read More
How do I multiply in Excel?

How do I multiply in Excel?

https://youtu.be/zw8P3eXVd40 Link to YouTube video How do I multiply in Excel? To an Excel expert, this is extremely easy - but it's a commonly searched-for question on Google, so let's get stuck in. Once you're familiar with this technique you will have a much better understanding of how Excel works. (The technique is exactly the same in Google Sheets). So let's start off with a very simple calculation; 4 x 2. The number 4 is in cell A1, and number 2 is in cell A2: To begin with, you need to understand that multiplication in Excel is a kind of formula, and whenever you type a formula in Excel you must begin it with the equals symbol =, and the formula is after the equals sign.  Secondly, you need to know that the symbol for multiply in Excel is not x, it is * (the star symbol).  So if we want the answer to this sum to be in cell A3, we click in cell...
Read More
How do I lock cells in Excel?

How do I lock cells in Excel?

https://youtu.be/lvzB9FK1z6o Link to YouTube video How do I lock cells in Excel? If you have created an Excel workbook with calculations in it that you don't want your colleagues to be able to accidentally delete or overtype, you will need to lock the relevant cells.  You may be surprised to hear that by default, all the cells in Excel are locked by default!  But if that is the case, then why can they be edited?  That's because it is a two stage process. So let's imagine you've made this sweet spreadsheet at work, and you want your colleagues to be able to update the cells A3 to B8 (the cells in white) but have the green cells locked down: As I said, by default all the cells are actually locked already, what you need to do now is select the cells that you want to be unlocked, i.e. in this case cells A3 to B8.  Highlight and select this cell range, then right-click and select...
Read More
How do I subtract in Excel?

How do I subtract in Excel?

https://youtu.be/EQKOczg9l6I Link to YouTube video. How do I subtract in Excel? This is another very simple question to answer, but a commonly searched-for problem, so you're not alone if you're stuck on this.  The method is exactly the same if you want to know how to subtract in Google Sheets. Let's take a very simple example, we have 100 and we want to subtract 10.  The number 100 is in cell A1, and the number 10 is in cell A2: To begin with, you need to understand that subtracting in Excel is a kind of formula, and whenever you type a formula in Excel you must begin it with the equals symbol =, and the formula is after the equals sign.  So if we want the answer to this sum to be in cell A3, we click in cell A3 and type: =A1-A2 and then press ENTER on your keyboard: And there we have it, the answer to 100 minus 10 is now in cell A3: So in a...
Read More
How do I merge cells in Excel?

How do I merge cells in Excel?

Link to our YouTube video So how do I merge cells in Excel?  This is another basic technique in Excel that gets a lot of searches on Google, so you're not alone if you're struggling with this one! Let's say we have a table and we want to make one of the cells merge across the top of the subheader cells (like here we want the year to span across the whole table):   We need to highlight from cell A2 where the year is across to cell E2 by clicking in cell A2 and dragging the mouse across to highlight all the cells we wish to merge:   Then, in the default "Home" tab of the ribbon, click on "Merge and Centre":   And BAM, your cells are merged:   This only works how you'd expect if the rest of your cells are blank.  Excel only keeps the upper-leftmost data in a range if you have data in more than one of the cells, so use this with caution.  ...
Read More
How do I Add a Column in Excel?

How do I Add a Column in Excel?

How do I add a column in Excel? Link to our YouTube video How do I add a column in Excel? - This is a really simple, but apparently it is a commonly searched for problem!  So if you've found this article because you can't add a column then you are not alone. First of all, select the entire column to the right of where you want to insert the new one.  For example, if you wanted to insert a column between columns B and C, then you would click in the grey area at the top of column C (see image below for where you need to click to select an entire column): Once you have selected the column, you then need to right-click in that same place to come up with a context menu, then click "Insert". And that's that, the new blank column appears, what was in Column C now becomes Column D: The exact same technique is used to insert new rows,...
Read More

Combining Excel Workbooks

You may have several Microsoft Excel files that are used to control a particular area of your business, and you may be thinking to yourself, "how do I combine all these Excel workbooks into one?"  You can move or copy tabs (excel sheets) between workbooks very easily with a few clicks: Link to our tutorial on YouTube Step 1:  Open all the workbooks you want to combine. Doing this makes it possible to copy or move the tabs between the workbooks. Step 2:  Decide which of your workbooks is going to be your new "main" workbook. Or if you want to create a new "main" workbook, create a new blank workbook now, and save it with a filename such as "Workbooks combined.xlsx" or whatever is suitable to you. Step 3:  Now select a workbook which is not your "main" workbook. Now you have selected another workbook that is not your "main" workbook, you are ready to move or copy the relevant tabs over to your main...
Read More

How to link between two workbooks (files) in Excel

Often we need to summarise information from one (or many) Excel files into another.  Doing this is very easy; to begin, you will need both of your files open; the file that you want to retrieve the information from, and the file you want the information to go to.  If you open each workbook side by side on your screen it makes this process the easier.  Select the data on the sheet you want to copy from, copy it, then in your destination workbook select where you want your linked data to go, right-click with your mouse and select the "Paste Link" icon: You will notice if you select a cell in your destination workbook that it now contains a formula that refers to a corresponding cell in your source data workbook.  Here you can see that cell F2 is referring to Workbook 1.xlsm, Sheet1, cell F2: If you make any changes to your source data workbook, they will be automatically changed...
Read More

The fastest and easiest way to make a graph/chart in Excel

How do I make a graph or chart in Excel? If you've never made a graph or chart in Excel then it can be quite daunting the first time, but Excel has made it very easy to make a professional looking graph with just a few clicks. The first stage is to make a spreadsheet of your information; the important thing here is to make sure you put column headings because these will be used as the Axis names on your graph.  Also, making sure you format your numbers correctly (e.g. if it's in pounds then format 10000 pounds as £10,000) as this will also give Excel some clues as to what is the best format to use in the graph. Then highlight all your data, including the column headers, click on the Insert tab, and "Recommended Charts" and Excel will give you a gallery of the charts it thinks are the most appropriate.  Select one you like, click OK, and Excel will...
Read More