Learn why people trust wikiHow. Co-authored by wikiHow Staff Updated: May 15, Learn more Open Excel on your PC or Mac. Open the file you want to edit.

How can we improve Excel for Mac?

Click and drag the mouse over the data range. This highlights and selects the cells. Type a name for your range. A1:F20 in your formulas. The named range is now saved.

Excel Dropdowns Done Right: Data Validation and Named Ranges

Include your email address to get a message when this question is answered. Already answered Not a question Bad question Other. Related wikiHows.


  • ;
  • mac pro frozen on blue screen;
  • Changing the Reference in a Named Range (Microsoft Excel).
  • ;
  • proxy finder mac os x;
  • Define and use names in formulas;
  • ;

Article Summary X 1. Did this summary help you? Versions: , [add].

EAF #21 - Excel Mac 2011 - Dynamic Named Ranges That Expand and Contract

Sources: Office:Mac microsoft. Shortcuts published under Creative Common License where possible.


  1. backup samsung galaxy s4 to mac;
  2. big fish games mac free online;
  3. what is time capsule on mac;
  4. mac operating system free download full version;
  5. epson l355 series driver mac;

    6. Website: Copyright Terms of Use. A wiki-style reference database for keyboard shortcuts.

    Comments Table of Contents: Function keys Moving and scrolling in a sheet or workbook Previewing and printing Entering data on a sheet Working in cells or the Formula bar Formatting and editing data Working with a selection Selecting cells, columns, or rows Charts Data forms Filters and PivotTable reports Outlining data Toolbars Windows Dialog boxes. Turn off the Mac OS X keyboard shortcut for this key.

    Use names in formulas - Excel for Mac

    You must select the row starting with the active cell. You must select the column starting with the active cell. Charts F11 Insert a new chart sheet.