Forum Discussion

L_Mallis's avatar
L_Mallis
Copper Contributor
Jun 30, 2021

Columns repeat on different sheets

Hi.  I want to have the first two colums of the front sheet repeat on all of the subsequent sheets.  How do I make this happen?  

Thank you in advance.  

excel

1 Reply

  • DKoontz's avatar
    DKoontz
    Iron Contributor
    Jun 30, 2021
    Could you just link the cells? So in your second sheet have A1 be =Sheet1!A1 and A2 be =Sheet1!A2 and so on? Do they need to be dynamic? Copy and pasting would be easier. You can highlight (control click) multiple sheets to make changes to multiple sheets btw.

Resources