| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a worksheet so that hidden columns remain secret? | Excel Discussion (Misc queries) | |||
| Exclude data from summary totals when hidden | Excel Worksheet Functions | |||
| Is there a way to exclude hidden rows/columns when printing a doc | Setting up and Configuration of Excel | |||
| How do I NOT copy hidden rows to a new worksheet? | Excel Discussion (Misc queries) | |||
| Exclude hidden data from summary totals | Excel Discussion (Misc queries) | |||
Linear Mode
