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
"Bob Bridges" wrote:
> 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" wrote:
> > 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?
|
Similar Threads
