Forum Discussion
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 efficient. (Please give me guidance on how to learn that).
Main Question:
I have identical columns/ row sizes locations everything.. (just the content differs) found in multiple tabs on my excel sheet. (Example: Constructability tab and Site Logistics tab), and let's assume I want to do the same text alignment changes on both or on a total of 20 tabs. So, what I am trying to get to instead of going in each tab, selecting the same rows and columns and doing the changes in 20 tabs, I know it would be faster to type in some code or command to apply the same changes to all at once! Is that possible? That way on the long run similar codes or commands will make my process way faster, because the same logic is used in different scenarios. Thanks!!!
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.
3 Replies
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.
- https://techcommunity.microsoft.com/t5/excel/capitalize-the-first-letter-of-a-word-only-in-a-sentence/m-p/3267323
I also asked about this if you have a response to it. Thanks! Martin_Weiss Thank you! That works.
