3D Cell References | CSE 148 – Excel Exam 2

3D Cell References explained

"NOOOOOO!" you scream, as you sit up in bed abruptly.

You wake up from your terrifying dream, dripping in sweat. To ensure you made it back to the real world, you glance at the table across from you. "Thank goodness" you say to yourself, as you notice the 3 empty beer cans and 2 crushed seltzers sitting on your desk. "I'm still in college".

In this terrible dream, you were a year into working your full-time job in the real world. You woke up, went to work, and sat in your cubicle all day. The worst part of the dream came at the end, when you went home to...

...budget. In this nightmare, you sat on your laptop and made a month-by-month financial review in Excel, with each month having its own sheet.

How terrifying!

As you reviewed your expenses from month-to-month, you realized that you should make a sheet that summarized expenses from each month's sheet into one "year-in-review" sheet. To do so, you used a 3D cell reference.

3D cell references enable you to reference the same individual cell or range from multiple different worksheets.

Coding a 3D Cell Reference

The first step to 3D referencing is to take note of all the worksheets that you'll be referencing, not cells.

PAID CONTENT

This is the end of the preview. To unlock the rest, get the Excel Cram Kit (Exam 2) or Lifetime Access.

Already purchased? Click here to log in.

Leave a Comment