Forum Discussion

MacKensie Chapman's avatar
MacKensie Chapman
Copper Contributor
Nov 03, 2018

EXCEL HELP

How do I make the first row in an excel sheet carry thru every page

 

1 Reply

  • If you select the 2nd sheet, hold shift and select the final sheet you will group them together. Then in cell A1 of the 2nd sheet type =Sheet1!A1 (or whatever sheet 1 is called). This then puts the same formula on all sheets - i.e. all reference the first cell of sheet 1