| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I cut & paste non-adjacent rows or columns ONLY in auto-fil
If I copy/paste from an auto-filtered sheet I copy/paste only the highlighted
rows. If I CUT/paste, I cut and paste all the intermediate cells hidden by the auto-filter. I don't want that! (Note: in the paste sheet the intermediate cells are hidden until I [FORMAY/ROW/UNHIDE]. Also once you de-select back to ALL [UNDO] is not available! |
|
#2
|
|||
|
|||
|
Amododa,
You cannot cut/paste multiple area selections. So, you need to copy/paste, and then go back to your filtered list and use Edit / Go To... / Special / Visible Cells only, then delete. HTH, Bernie MS Excel MVP "Amadoda" wrote in message ... If I copy/paste from an auto-filtered sheet I copy/paste only the highlighted rows. If I CUT/paste, I cut and paste all the intermediate cells hidden by the auto-filter. I don't want that! (Note: in the paste sheet the intermediate cells are hidden until I [FORMAY/ROW/UNHIDE]. Also once you de-select back to ALL [UNDO] is not available! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Linear Mode
