Copy and Paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste with Hidden Rows/Columns Excel 2007 3
Copy paste data from a column to a row 0
Copy & Paste 2
copy/paste row with one formula 6
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
copy/paste with hidden rows don't want hidden parts to paste 1
Paste value error 1
Paste Special 3

Back
Top