Copy and Paste
 

Is there a way to copy and paste several rows of information and formulas,
without pasting the hidden rows that lye in between?

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?

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?