Copy Worksheet and Exclude Hidden fields

C

Charles Gonzalez

I have several worksheets that I need to copy.... However I don't want it to
copy the fields that I have hidden. Is there a way to have it copy only the
fields that are not hidden?

Thanx,
Charles
 
D

David McRitchie

Hi Charles,
If you talking about hidden columns and or rows,
You can use keyboard shortcut
Select only visible cells in the current selection Alt+; (semi-colon)
There is a toolbar button that looks like a square of four black rectangles
that you could put into your pre Excel 2007 toolbars.
 
G

Gord Dibben

F5>Special>Visible cells only>OK

Copy/paste


Gord Dibben MS Excel MVP

On Mon, 11 Aug 2008 15:50:00 -0700, Charles Gonzalez <Charles
 
Top