Copy and Paste

S

Steve

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

JE McGimpsey

Select your range, then choose Edit/Goto/Special and select the Visible
cells only radio button. Copy and Paste.
 
D

David McRitchie

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
 
Top