Excel cut-n-paste behaviour
Alexei Danchenkov
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.
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.
Is there a way to cut-and-paste only the cells in the filtered rows?
Stepan1010
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:
Good Luck.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Lock a window to the foreground without focus
- Next: Excel, merge two sheets with one column as key
Related
TOP Ranking
- 1
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 2
pump.io port in URL
- 3
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 4
Unable to use switch toggle for dark mode in material-ui
- 5
grouping by column variables and appending a new variable based on condition
- 6
BigQuery - concatenate ignoring NULL
- 7
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 8
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 9
Python Read Directory And Output to CSV
- 10
Remove adjacent duplicates in linked list in C
- 11
Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use
- 12
How to keep curl session alive between two php processes?
- 13
Limit number of characters in uitextview
- 14
JMeter: Why get error when try to save test plan
- 15
Always setting the text cursor on Textbox
- 16
MTKView Displaying Wide Gamut P3 Colorspace
- 17
Vector input in shiny R and then use it
- 18
How to implement an authentication method using Spring Boot and JPA?
- 19
Laravel getting value from another table using eloquent
- 20
org.springframework.web.client.HttpClientErrorException: 401 null
- 21
When I click any button in my view page the form is submitted
Comments