how do I end a worksheet columnwise.

A

Al

I have a 15 column worksheet that I want to be able to quick copy the rows by
selecting the row number and copying the data. Even though I hide the other
240 some columns, it still copy's the entire row. The information I copy
needs to be pasted into another worksheet and has formula's in columns 16-20.
If other spreadsheet is unprotected, it over writes these formulas, if
columns 16-20 are protected I get a paste error.
 
G

Gord Dibben

Select a row then F5>Special>Visible Cells Only>OK

Copy and paste that selection.


Gord Dibben MS Excel MVP
 

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

Copying cells in a protected worksheet 2
Hide columns based on row values 2
Excel Help to copy information from one row at a time to another sheet 1
how do I protect a column on a worksheet 1
How to copy & paste a worksheet but change 1 bit of the formula? 1
Finding muliple duplicate records in spreadsheet 4
use source formatting with protected worksheet 2
Excel Fit to page print options in Excel 1

Top