Copying worksheets with formulas in hidden columns

B

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?
 
B

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.
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top