Ask a question Report

Repetitive formulae

HerbMason - Mar 8, 2018 at 01:56 PM - Latest reply: ac3mark 10544 Posts Monday June 3, 2013Registration dateModeratorStatus September 25, 2018 Last seen

- Mar 8, 2018 at 02:00 PM

Excel Ask a question Report

Hello,

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

Repetitive formulae
Spreadsheet - Formulas » Articles
Basic Excel Formulas » How-To - Excel
Apply an IF Function Using Dates and Text » How-To - Excel
Prepare Grades from Marks on Excel » How-To - Excel
Excel - Formula based on the color of cell » How-To - Excel

Your reply

Reply to this topic

1 reply

Report Respond to ac3mark

ac3mark 10544 Posts Monday June 3, 2013Registration dateModeratorStatus September 25, 2018 Last seen - Mar 8, 2018 at 02:00 PM

Thank you

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

=Sheet1!$a$1

Your reply

Reply to this topic

Ask a question