Also available as a toolbar button (a box with 4 filled in black rectangles)
tools, customize, commands, edit (on left), Visible Cells only
drag the icon to the toolbar.
Also available as a shortcut: Alt+; (semi-colon)
Then use your Copy (ctrl+c) and Paste (ctrl+v)
Shortcut Keys in Excel 2000 (Excel Vers. 9)
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"JE McGimpsey" wrote ...
Select your range, then choose Edit/Goto/Special and select the Visible
cells only radio button. Copy and Paste.
In article ,
"Steve" wrote:
Is there a way to copy and paste several rows of information and formulas,
without pasting the hidden rows that lye in between?