multiple worksheets
We use a spreadsheet for the years cashbooks, with seaparate worksheets for
each month. Is there a way to insert a new column and its formulas once and have it copy to each worksheet within the spreadsheet? Or do I have to copy and paste for twelve worksheets? Any suggestions would be great thx, Sharon |
multiple worksheets
If all the worksheets have the same layout, group the sheets (select the
leftmost worksheet tab, then shift-click the rightmost). Make your changes. Then right-click one of the tabs and choose Ungroup Sheets, or all subsequent changes will occur in all sheets. In article , "ali&shazz" wrote: We use a spreadsheet for the years cashbooks, with seaparate worksheets for each month. Is there a way to insert a new column and its formulas once and have it copy to each worksheet within the spreadsheet? Or do I have to copy and paste for twelve worksheets? Any suggestions would be great thx, Sharon |
All times are GMT +1. The time now is 11:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com