Pasting data with hidden columns
This worked. Thanks again!
"Gord Dibben" wrote:
After Special Pasting as you did, re-paste special and "Formats"
Gord Dibben MS Excel MVP
On Thu, 2 Nov 2006 14:33:02 -0800, shark1966
wrote:
This worked! Thanks. When I used Paste Special - Values and Number Formates,
the data lost its formatting (column widths, font, bold text, etc.). Is there
any way to keep that?
"Gord Dibben" wrote:
Select the range including hidden columns.
F5SpecialVisible cells onlyOK
Now do the copy and paste.
Gord Dibben MS Excel MVP
On Thu, 2 Nov 2006 10:48:01 -0800, shark1966
wrote:
I have a spreadsheet with 40 columns - 20 hidden and 20 shown. All 40 columns
have formulas. I want to be able to quickly copy and paste the values from
the 20 shown columns into another worksheet. When I do it now, all columns,
including the hidden ones, paste. How can I get it so only the shown cells
paste?
|