Forum Discussion

Jeenine's avatar
Jeenine
Copper Contributor
Sep 29, 2022

Formatting cells

I am not the brightest person where tech is concerned.  I am putting together a workbook which requires 100+ sheets all with the same cell format.  I have worked out how to replicate cell widths in e...
  • Martin_Weiss's avatar
    Sep 29, 2022

    Hi Jeenine 

     

    if all sheets have really the same structure, you can just select all sheets and do the change automatically for all of them.

     

    Right-click on the first sheet and then chose "Select all Sheets"

     

    Then change the row height (or anything else you need) and it will apply to all selected sheets:

     

    Just don't forget to unselect them when you are done, otherwise all entries you make in one sheet will be applied to all the other sheets.

     

     

     

Resources