Copy Worksheet and Exclude Hidden fields

  • Thread starter Thread starter Charles Gonzalez
  • Start date Start date
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
 
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.
 
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
 
Back
Top