how to create a name range in mac excel 2013

Now, click on the tab for the first worksheet in your range (2013). Then click on the Sum button and choose the formula you want to use. If you don’t want to type the formula in, it is possible to do most of it with the mouse instead.įirst, click in the cell where you want the total to appear and type the equals sign. If we want to get an average of our electricity spend over the years, we can do that too: To enter a range of worksheets, type them with a colon in between, then the exclamation mark, then follow this by the cell address: Our total electricity cost is in cell B14, so we only need to enter that once. W hat if we want to add up our total electricity cost for the past six years? Rather than type each of the worksheets in, we can enter them as a range, as long as the data we want is in the same cell on every sheet. (Note that Excel puts single quotes around the worksheet names after your press Enter, but you don’t need to type these.) In that case we would click in the cell where we want the total to appear and type: So to start simply, let’s say we want to add the July electricity figures from 20. When using data from another worksheet in a formula, you enter the worksheet name, followed by an exclamation mark (!). The data is in the same format on all of the sheets, that’s crucial.Īt the most basic level, all you need to use data from different sheets is the cell addresses and the worksheet names. This can be incredibly useful, when you have similar figures for different periods across worksheets and want to use data from all of those p eriods.įor our example, we have a file with expenses for a number of years, a different worksheet for each year. 3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet.

How to create a name range in mac excel 2013