| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: copy and paste only shown not hidden cells into new sheet
I have a worksheet in which I hide information when I don't want to use it,
and make custom views. Now, I would like to take this a step further. How can I copy this custom view and paste it into a new worksheet without all of the hidden rows and columns coming with it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel: copy and paste only shown not hidden cells into new sheet
Select the range to copy
edit|goto|special click visible cells only Edit|copy and edit|paste MU wrote: I have a worksheet in which I hide information when I don't want to use it, and make custom views. Now, I would like to take this a step further. How can I copy this custom view and paste it into a new worksheet without all of the hidden rows and columns coming with it? -- Dave Peterson |
| 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 excel sheet excluding hidden rows | Excel Discussion (Misc queries) | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
| How do I edit, copy and paste text in excel cells? | New Users to Excel | |||
Linear Mode
