Absolute Cell Reference for Range of Cells

I would like to reference a range of cells from one sheet to another, all within the same spreadsheet. When grows and columns are changed in the source sheet, I would like the second sheet to reflect that change, so I believe I need absolute references. I know I can do this for single cell by referencing the cell, clicking on the arrow and locking horizontal and vertical. Is there a way to do that for an entire range of cells?

Thanks for your help.

MacBook Pro (Retina, 15-inch, Late 2013), OS X El Capitan (10.11.5)

Posted on Jul 4, 2016 9:00 AM

Jul 9, 2016 9:59 AM in response to SGIII

Hi SG,

"I'm not a big fan of the recent configuration of how forum software displays posts."

Nor am I.

The I is definitely missing from the version you posted above, but it was present in the one in my message, which was taken from the same source! I had clicked on the image to load the 'magnified' version, then control clicked on that one, Copied, and pasted it onto the sheet of a Numbers document, rescaled it there, did a screen shot of the formula editor, and placed that in my post above. Same source (or maybe not), different image. Weird.

But, re-investigaing today, I did stumble on a way of displaying a (much) clearer version of these large screen shots:

Control-click on the image in the post, then choose Open Image in new Tab. Bingo! Full frame copy of the image, with the little magnifier mouse pointer to enlarge it even more!

Regards,

Barry