How to number in Excel

How to number in Excel

How to number in Excel and Google Sheets using Autofill Click here for our YouTube video on How to number in Excel We'll show you how to number in Excel, and even take it a step or two further so you can see how you can use Excel's Autofill features to speed up tasks that would otherwise need to be done by typing in data. So for this example, we'll start off with a blank sheet (the technique is the same in Google Sheets as it is in Excel).  Let's say for example we want to create a numbered list from 1 to 10, but can't be bothered typing in all those numbers.  All we need to do is give Excel a hint at what we want to do, and Excel will take it from there!  So let's start off by typing in the number 1 in a cell, and then in the cell directly beneath, the number 2.:   Next, you need to select...
Read More
How do I unhide rows in Excel?

How do I unhide rows in Excel?

How do I unhide rows in Excel? If you'd rather see our video on how to unhide rows in Excel, click here. Sometimes people hide rows of data for all kinds of reasons; the information is irrelevant at the time, the clutter needs to be hidden for easier analysis, or to hide formulas that don't need to be seen all the time.  But once that hidden data is needed again, you'll need to know how to unhide rows in Excel. The method is almost identical to unhiding columns (see our other blog tutorial on how to unhide columns in Excel) and is very quick and easy. So here is our example, we can see that rows 8 and 9 must be hidden, because to the left you can see that the row count goes straight from 7 to 10:   All we need to do is select the rows above and below the hidden ones (in this case 7 and 10) by clicking in the grey...
Read More
How do I wrap text in Excel?

How do I wrap text in Excel?

How do I wrap text in Excel? Link to YouTube video I was surprised to see this was a commonly searched-for term on Google, because on the Home ribbon there is a button clearly labelled "Wrap Text", but occasionally the button is obscured for various reasons that may not be obvious to the beginner.  Also, once the text is wrapped, you may not necessarily see all the text within the cell; again to the beginner this will need explaining as it's not obvious how to change the size of a cell. So let's start off with a simple example, where we have entered a string of text that's too long to fit within a cell:   So to begin with, select the cell(s) you want to wrap the text in, then make sure you're on the "Home" ribbon tab, and click the Wrap Text button.   Note, if your screen is re-sized you may not see the label "Wrap Text", in which case you need to know...
Read More
How do I unhide columns in Excel?

How do I unhide columns in Excel?

How do I unhide columns in Excel? Link to YouTube video So I guess you've come across this article from a Google Search on how to unhide columns in Excel - apparently it is a very searched-for query!  And you are in luck because we are here to show you how to professionally unhide any columns that may be hidden from your inquisitive eyes.  So let's get cracking: Here we have a simple table, but we can clearly see that the columns jump from A to C, so we know column B must be hidden:   You'll be pleased to know that unhiding the column is very easy, simply select the two columns either side of the hidden column (in this example columns A and C) by clicking in the grey box with the "A" in it, and dragging across to also select the "C" column.  Then right-click either one of those column header boxes and select "Unhide":   And there you have it, the column is...
Read More

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 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