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

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

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

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

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