Menu

Previous Topic Next Topic

Repetitive formulae

[Closed]

Report

HerbMason - Updated on Mar 8, 2018 at 04:26 PM
Blocked Profile - Mar 8, 2018 at 02:00 PM

Hello,

how do I construct multiple pages with the same set of formulas?

Related:

Repetitive formulae
Spreadsheet formula - Articles
Excel @ in formula ✓ - Forum - Excel
1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
How to copy data from one sheet to another in excel using formula - How-To - Excel
How to unhide formula bar in excel - How-To - Excel

1 reply

Answer 1 / 1

Blocked Profile
Mar 8, 2018 at 02:00 PM

To lock in cell references, pre-pend the adddress with a $, as in:

=Sheet1!$a$1

Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Recommended

DON'T MISS