Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Great discovery?
I often use a vertical merged cell on the left hand side of a table range for
presentation effect. After merging, any data in cells other than .cells(1) is lost. This can be worked around easy enough but I sometimes would find it more convenient to have all cells contain data. I found by accident that this can be achieved by pasting data into the merged cells using PasteSpecial/Formulas. Only the the first value will be displayed of course but the other cells now contain data or formulas that can be referred to. Hope this is of some use to some of you -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel Budget in Great Plains Dynamic | Excel Discussion (Misc queries) | |||
Office 2003 integration - Great Plains | Excel Discussion (Misc queries) | |||
does anyone have a great Interest only amortization schedule wher. | Excel Discussion (Misc queries) | |||
How can I get Excel Spreadsheets to have that great Access look? . | Excel Discussion (Misc queries) |