Pasting data with hidden columns

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

Gord Dibben

Select the range including hidden columns.

F5>Special>Visible cells only>OK

Now do the copy and paste.


Gord Dibben MS Excel MVP
 
G

Guest

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

Gord Dibben

After Special Pasting as you did, re-paste special and "Formats"


Gord Dibben MS Excel MVP
 

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

Similar Threads

Hide columns based on row values 2
Copy columns, but not hidden ones 3
PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns 7
Statistical functions on non-consequtive columns 7
Copying worksheets with formulas in hidden columns 2
VBA - retrieve data on last create named range from previous inserted named range 0
Do not paste in hidden cells 9
how do I end a worksheet columnwise. 2

Top