Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying worksheets with formulas in hidden columns
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying worksheets with formulas in hidden columns
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying worksheets with formulas in hidden columns
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying formulas from worksheets | New Users to Excel | |||
How do I avoid copying data from hidden rows/columns? | Excel Discussion (Misc queries) | |||
Copying Formulas Between Worksheets | Excel Discussion (Misc queries) | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
Copying Formulas to Other Worksheets | Excel Worksheet Functions |