how do I end a worksheet columnwise.
 

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.

how do I end a worksheet columnwise.
 

Select a row then F5SpecialVisible Cells OnlyOK

Copy and paste that selection.


Gord Dibben MS Excel MVP

On Thu, 13 Dec 2007 12:41:02 -0800, Al wrote:

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.

how do I end a worksheet columnwise.
 

Or paste special and skip blanks, thanks for the tip my Nortern friend

"Gord Dibben" wrote:

Select a row then F5SpecialVisible Cells OnlyOK

Copy and paste that selection.


Gord Dibben MS Excel MVP

On Thu, 13 Dec 2007 12:41:02 -0800, Al wrote:

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.