Forum Discussion

akesserwani's avatar
akesserwani
Copper Contributor
Mar 17, 2022
Solved

Making the same edit on similar rows and columns located on multiple tabs in the same Excel file

Hi,   I've never used coding to make multiple changes or get done with certain functions on Excel faster. So, not sure if that's an option but I am very interested in it if it is just to be more ef...
excel
Formulas and Functions
  • Martin_Weiss's avatar
    Martin_Weiss
    Mar 21, 2022

    Hi akesserwani 

     

    if the layout of all these worksheets is really identical, you could just select all the sheets that you would like to change and then do the change.

    Just hold down the Ctrl-key and then click on all the sheet tabs that you want to change. As long as they are selected, all changes that you enter in the first sheet will be applied to all other selected sheets.

     

    Note:

    This does not work if the data you want to change is located within a formatted table. 

Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Mar 21, 2022

Hi akesserwani 

 

if the layout of all these worksheets is really identical, you could just select all the sheets that you would like to change and then do the change.

Just hold down the Ctrl-key and then click on all the sheet tabs that you want to change. As long as they are selected, all changes that you enter in the first sheet will be applied to all other selected sheets.

 

Note:

This does not work if the data you want to change is located within a formatted table. 

Resources