Skip to content

Naming ranges in Excel

September 16, 2013

Naming ranges can be a huge time saver working with Excel when you are using the same data throughout a workbook.  Although you can use absolute references such as $B$1:$F$22, you can also give it a specific name such as cost_analysis when doing calculations.  The video shown will demonstrate how it works.  A range can either be a group of cells or a single cell.

Advertisements

From → Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: