Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using spreadsheets to quickly sort the garbled tables. For example, I have an address sheet with columns for region, city (republic, zipcode, address, etc.). Some cities are erroneously in the region column, so I filter out regions column to not include blank fields to quickly work on those and then cut some selected number of cells containing the city names.cutting the filtered cells

When I paste the clipboard to the cities column, even though I do not see it, the filtered-out regions (that I haven't seen) get copied to the city column. This destroy underlying city names, but I don't notice it until much later, when I suddenly discover region names in the city column.enter image description here

Is there a way to cut-and-paste only the cells in the filtered rows?

share|improve this question

migrated from stackoverflow.com Oct 2 '12 at 17:55

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

There are a plethora of ways to solve this problem. However, it looks like it is difficult to maintain the pasting structure of a non-continuous selection. So I would just use a worker column with cell logic:

WorkerColumnExample

Good Luck.

share|improve this answer
    
Thanks, Stepan1010, I understand the difficulty in implementation, and I see how your example works, but it seems somewhat complicated to enter formulas, while I was looking for a quick and dirty way to toss some cells around. Still, since the filtered rows are visible, there might be the way to remember, which ones are selected for cut-and-paste purposes, or so I thought. Otherwise I will stick with your answer. – Alexei Danchenkov Oct 2 '12 at 16:43
    
I found a way that does not spoil the cells by mistake. I don't filter. I sort the rows, thus moving blanks or unusual cell content to the edges. This allows me to do my cut-and-paste stuff without damaging anything. – Alexei Danchenkov Oct 3 '12 at 12:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .