| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste special
how do you paste only shown rows on a spreadsheet to a new workbook? I have
hidden rows that I do not want to copy over. thanks! i am working in office 2007 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste special
If the rows are hidden because of a filter, simply select the cells (not the
whole worksheet) by clicking and dragging. Ctrl-C to copy the selected cells Switch to the new Sheet and Paste. Any €śhidden€ť rows will not be pasted. Hope that helps, Frank "beana" wrote: how do you paste only shown rows on a spreadsheet to a new workbook? I have hidden rows that I do not want to copy over. thanks! i am working in office 2007 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste special
Perfect, thanks!!
"FrankWood" wrote: If the rows are hidden because of a filter, simply select the cells (not the whole worksheet) by clicking and dragging. Ctrl-C to copy the selected cells Switch to the new Sheet and Paste. Any €śhidden€ť rows will not be pasted. Hope that helps, Frank "beana" wrote: how do you paste only shown rows on a spreadsheet to a new workbook? I have hidden rows that I do not want to copy over. thanks! i am working in office 2007 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste special
F5SpecialVisible cell onlyOK
Copy and paste. Gord Dibben MS Excel MVP On Thu, 10 Dec 2009 11:01:02 -0800, beana wrote: how do you paste only shown rows on a spreadsheet to a new workbook? I have hidden rows that I do not want to copy over. thanks! i am working in office 2007 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
paste special
Welcome. Happy to help.
"beana" wrote: Perfect, thanks!! "FrankWood" wrote: If the rows are hidden because of a filter, simply select the cells (not the whole worksheet) by clicking and dragging. Ctrl-C to copy the selected cells Switch to the new Sheet and Paste. Any €śhidden€ť rows will not be pasted. Hope that helps, Frank "beana" wrote: how do you paste only shown rows on a spreadsheet to a new workbook? I have hidden rows that I do not want to copy over. thanks! i am working in office 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
| 'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions | |||
Linear Mode
