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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment