Copying of cells to exclude hidden lines
Posted by Dominic on August 09, 2001 2:04 AM
I have used, the command in German Date. Gültigkeit to hide certain lines, ie where it shows the + or - symbol and you can then open or hide the lines. And I only want to copy the visible lines/cells to a new page
How do I do it
Posted by Garrincha on August 12, 2001 11:08 PM
Select the whole range of cells (including the hidden ones).
Go to Edit>GoTo>Special>VisibleCellsOnly.
Copy and paste.
