How do I split a cell in Excel?

by AlexNo Comments
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 subtract in Excel?

How do I subtract in Excel?

by AlexNo Comments
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 Add a Column in Excel?

How do I Add a Column in Excel?

by Alex1 Comment
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