Copy Worksheet and Exclude Hidden fields
 

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

Copy Worksheet and Exclude Hidden fields
 

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
---
"Charles Gonzalez" wrote:
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

Copy Worksheet and Exclude Hidden fields
 

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.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm



"Charles Gonzalez" <Charles wrote in message
...
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

Copy Worksheet and Exclude Hidden fields
 

F5SpecialVisible cells onlyOK

Copy/paste


Gord Dibben MS Excel MVP

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

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