Forum Discussion
Solved
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...
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.
Thank you Martin. This has been most helpful for me. It has saved me hours of tedious copying on what has proved to be a 150 worksheet workbook.