Sep 25, 2012 - Naming a range in Excel for Mac. One of the more useful features in Excel that I see a lot of end users overlook is Named Ranges in Excel.
![Microsoft office for mac Microsoft office for mac](/uploads/1/2/5/4/125437291/427843978.png)
As with most programs that you will install on your computer, Excel 2011 for Mac includes a default combination of settings that are meant to appeal to a wide range of users. Among these settings is the default “Save as” format, which is set to.xlsx. This is the new standard for Excel files after the introduction of Microsoft Office 2007, and it extends to versions of the software for the Mac operating system as well. If you want to change the default file format in Excel 2010 in Windows, for example, you could. But to change the default file save setting in Excel 2011, follow the instructions below. Configure the Default File Save Format for Excel 2011 for Mac The.xlsx file format is the default for most of the recent versions of Excel, and even older versions of the software can be to allow those versions of the software to open and edit newer file types.
Conversely, you can use the instructions below to set a different file type for new files created in Excel 2011, such as the older.xls default, or the commonly used.csv file type. Each of those file types have their limitations when compared to the.xlsx file type, but your situation will dictate which file type is the best choice for you. Step 1: Launch Excel 2011.
Step 2: Click Excel at the top of the window, then click Preferences.
Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 You can create formulas that are easy to understand by using descriptive names to represent cells, ranges of cells, formulas, or constant values. Use the provided sample data and the following procedures to learn how to assign names to cell references and create formulas that use them. Copy the sample data To better understand the steps, copy the following sample data to cell A1 on a blank sheet. Create a blank workbook or sheet. Select the following sample data. Select cells C2 through C5, which are the actual sales for the East, West, South, and North regions. On the left of the formula bar, in the Name box, type MyRegions and then press RETURN.
![Name Manager Excel For Mac 2011 Name Manager Excel For Mac 2011](/uploads/1/2/5/4/125437291/867602327.png)
The name 'MyRegions' is assigned to the cells C2 through C5. Select cell C9, and then type Average sales for my regions. Select cell C10, type =AVERAGE (MyRegions), and then press RETURN. The result is 2661.5. Select the cell that contains 2661.5. On the Home tab, in the Number group, click the Number Format menu, and then click Currency.
The result is $2,661.50, which is the average actual sales for the East, West, South, and North regions. Tips:. To review and manage the names that you have assigned, on the Insert menu, point to Name, and then click Define.
You can create a list of all the names that are assigned to cells in a workbook. Locate an area with two empty columns on the sheet (the list will contain two columns — one for the name and one for the cells referenced by the name). Select the cell that will be the upper-left corner of the list.
On the Insert menu, point to Name, and then click Paste. In the Paste Name dialog box, click Paste List. Select cells C2 through C5, which are the actual sales for the East, West, South, and North regions.
On the left of the formula bar, in the Name box, type MyRegions and then press RETURN. The name 'MyRegions' is assigned to the cells C2 through C5. Select cell C9, and then type Average sales for my regions. Select cell C10, type =AVERAGE (MyRegions), and then press RETURN. The result is 2661.5. Select the cell that contains 2661.5.
On the Home tab, under Number, click Currency. The result is $2,661.50, which is the average actual sales for the East, West, South, and North regions. Tips:. To review and manage the names that you have assigned, on the Insert menu, point to Name, and then click Define. You can create a list of all the names that are assigned to cells in a workbook.
Locate an area with two empty columns on the sheet (the list will contain two columns — one for the name and one for the cells referenced by the name). Select the cell that will be the upper-left corner of the list. On the Insert menu, point to Name, and then click Paste. In the Paste Name dialog box, click Paste List.
Guidelines for creating names Guideline Description Allowed characters The first character of a name must be a letter or an underscore character. Remaining characters in the name can be letters, numbers, periods, and underscore characters. In some languages, Excel may replace certain characters with underscores.
Syntax Spaces are not allowed. Underscore characters and periods can be used as word separators — for example, SalesTax or First.Quarter. Cell reference conflicts Names cannot be the same as a cell reference, such as Z$100, BIN9, or R1C1. Maximum number of characters A name can contain up to 255 characters. If a name that is defined for a range contains more than 253 characters, you cannot select it from the Name box, but you can still use it in formulas.
Case sensitivity Names can contain uppercase and lowercase letters, but Excel does not differentiate between them. For example, if you have named one cell 'Sales' and then name another cell 'SALES' in the same workbook, the second name will replace the first name.