Pasting data with hidden columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Select the range including hidden columns.

F5>Special>Visible cells only>OK

Now do the copy and paste.


Gord Dibben MS Excel MVP
 
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?
 
After Special Pasting as you did, re-paste special and "Formats"


Gord Dibben MS Excel MVP
 
Back
Top