Copy Worksheet and Exclude Hidden fields

[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

 

[Max]

Think you could try copying only the visible cells in the selections via:
Pressing F5 > Special > Check "Visible cells only" > OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik

 

[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.

 

[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