Copying worksheets with formulas in hidden columns

[Brian]

I have a "Master" worksheet with hidden columns and rows. When I copy the
Master, the formulas in the hidden columns are are not copied (which are
required). Currently I have to unhide all rows and columns copy the sheet
then hide everything again on all the new sheets. Anyone know of a workaround?

 

[Bob Bridges]

What method are you using to copy the master sheet? If you use
<Shift-Space><Ctl-Space><Ctl-Ins> to copy the data and then some form of
Paste onto a new sheet (I'd probably use <Shift-Ins>, out of habit), then try
/Edit.Move or Copy Sheet.../ from the menu bar.

I just tried hiding some columns and rows and then copying a selection of
cells to a new sheet; the hidden formulae copied over unhidden, so I guess I
also have to ask what method you're using to hide the data.

 

[Brian]

Thanks for that Bob. the copies do now show the formulas in the hidden
columns. I can only assume that I was doing something wrong in earlier
attempts, they seemed to copy over then disappeared. I was using the standard
right click on tab, create copy method. I've now learnt that Select Tab+Ctl
then drag does a copy.

Brian