Visible Excel Cells

dplearning
dplearning used Ask the Experts™
on
I have lost the ability to Paste Visible Cells Only in Excel 2007. I am creating a summary of data from a giant spreadsheet where I need to paste just the visible cells into an existing table in another tab. All columns are being pasted for some reason.  I’m doing something wrong, but I’m stumped as to what that is.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2011
Commented:
Are you just selecting visible cells before you do the copy? (You can press Alt+; to select the visible cells only)
Top Expert 2010

Commented:
Hello dplearning,

Simply hiding a row or column will not prevent you from copying the data there.

You need to be using the AutoFilter to suppress copying of unseen cells.  Of course, even with the AutoFilter,
hidden columns/rows will still paste unless you are applying criteria in the filter.

Regards,

Patrick
Top Expert 2010

Commented:
dplearning,

Or just do what Rory told you :)



Patrick
Most Valuable Expert 2011
Awarded 2010

Commented:
The long way to Rory's shortcut is F5 - Special - Visible cells only

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial