Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste data over the hidden rows in a sheet with a filter
I have one sheet with a filter and one with non. How can I copy and paste
data from the sheet without a filter to the sheet with a filter without pasting it in the hidden rows. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste data over the hidden rows in a sheet with a filter
You can right click on the cell or row where you want to paste the data and
select "Insert copied cells" on the menu. This will give you options to shift the data around. Hope this helps, Miguel. "hezemeftez" wrote: I have one sheet with a filter and one with non. How can I copy and paste data from the sheet without a filter to the sheet with a filter without pasting it in the hidden rows. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste data over the hidden rows in a sheet with a filter
Excel doesn't work like that.
Maybe you can sort the data on that filtered worksheet so that it's grouped the same way you want to paste. Then sort it back and reapply the filtering. hezemeftez wrote: I have one sheet with a filter and one with non. How can I copy and paste data from the sheet without a filter to the sheet with a filter without pasting it in the hidden rows. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
paste excel sheet excluding hidden rows | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Multiple worksheet queries | Excel Worksheet Functions |