An Excel worksheet with the sheet and cell reference Sheet2!H11 typed in the name box. The down arrow in Excel's name box is selected, and the range named Monthly_Totals is highlighted.

How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references.

Enter the new name of the column in the Name text box. Click the "Scope" drop-down menu and select "Workbook" to apply the change to all of the sheets in the workbook. Click "OK" to save your changes.

To change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name, follow this procedure: Open the Excel spreadsheet to find the chart ...

Here's how to edit a drop-down list in Excel in each case, using the software on your PC or Mac computer. Check out the products mentioned in this article: MacBook Pro (From $1,299.99 at Best Buy) ...

Feed it a cell reference or text string, and Excel will handle the rest. Let’s say you're migrating data from a database ...