May 23, 2013

Same Formatting Across Spreadsheets in Excel 2010

Do you ever need the same heading information and/ or formatting in multiple sheets? Instead of inserting the information multiple times into each spread sheets here is how you can enter it only once. Simply hold down the CTRL and click on each Sheet tabs that you would like to group. Typically, the tab for the sheet you are in is white while the others are grey, but now all the sheets that you have grouped will be white.  Once you have entered the information and completed the formatting you would like to appear on all your sheets, remember to go back and select an individual Sheet tab to ungroup the sheets. 

No comments:

Post a Comment