Forum Discussion
MacKensie Chapman
Nov 03, 2018Copper Contributor
EXCEL HELP
How do I make the first row in an excel sheet carry thru every page
Wyn Hopkins
Nov 04, 2018MVP
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