| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula that works columnwise? | Excel Worksheet Functions | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| How to sort the data entered in different columns (columnwise) | Excel Worksheet Functions | |||
| Excel same Formula in different columns-calculate columnwise? | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Linear Mode
