software

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
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 gt;,
quot;aliamp;shazzquot; gt; wrote:

gt; We use a spreadsheet for the years cashbooks, with seaparate worksheets for
gt; each month. Is there a way to insert a new column and its formulas once and
gt; have it copy to each worksheet within the spreadsheet?
gt;
gt; Or do I have to copy and paste for twelve worksheets?
gt;
gt; Any suggestions would be great
gt;
gt; thx, Sharon