Excel Guides

"Adjusting Values with Formulas in Excel"

When working with large amounts of data in Microsoft Excel, you may find yourself in need of a way to automatically adjust values based on a formula. This can be accomplished by using the "Auto Fill" feature, or by creating a named range.

Using Auto Fill

To use the Auto Fill feature, first select the cell or range of cells that contains the formula you want to use. Then, click on the fill handle (the small square in the bottom-right corner of the selection) and drag it down or across to the cells you want to fill. Excel will automatically enter the correct values based on the formula.

Creating a Named Range

Another way to adjust values with formulas in Excel is to create a named range. This is a good option if you want to be able to reference the range elsewhere in your workbook, or if you plan on using the same formula in multiple places. To create a named range, select the cells you want to include in the range, then click Formulas > Name Manager. In the Name Manager dialog box, click New, enter a name for the range in the "Name" field, and then click OK.

Now that you have created a named range, you can use it in formulas just like any other cell reference. For example, if your named range is called "MyRange", you could use the following formula to sum all of the values in that range:

=SUM(MyRange)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.