•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Paste content into every other cell
I want to copy a column of strings from one file and paste it into another file. The problem is that I want to paste the content into every third row (skipping 2 rows pretty much).
I tried using a filter to only show the row types I want to paste into (every 3rd row), selecting the cells I wanted to paste into, pressing ALT + ; to select only visible cells, THEN finally pasting. But it didn’t work.
Is this even possible? Or is there a work around I can use?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#copy
#paste
#column
#file
#rows
#filter
#visible cells
#select
#third row
#content
#shortcut
#selection
#workaround
#skipping
#action