|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com