Menu
Ask a question Report Reply to this topic

Repetitive formulae

HerbMason - Mar 8, 2018 at 01:56 PM - Latest reply: ac3mark 9199 Posts Monday June 3, 2013Registration dateModeratorStatus April 23, 2018 Last seen
- Mar 8, 2018 at 02:00 PM
Excel Ask a question Report Reply to this topic
Hello,

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

See more 

1 reply

Reply to this topic
Report Respond to ac3mark
ac3mark 9199 Posts Monday June 3, 2013Registration dateModeratorStatus April 23, 2018 Last seen - Mar 8, 2018 at 02:00 PM
0
Helpful
To lock in cell references, pre-pend the adddress with a $, as in: 
=Sheet1!$a$1


Respond to ac3mark
Ask a question