Video Transcript
Here is the full transcript of the video above -- Use Shortcut to Paste in Excel Filtered List - From Same Rows.
Introduction
In my previous video, I showed you the problems you can run into when you try and copy and paste in a filtered list.
For example, if I filter this list to only show the chocolate chips, and then try to copy these dates, and paste them into this column, it doesn't paste correctly.
So I'm going to do a copy (we can see they're copied here) and then paste, and only two of them show up. The rest have been pasted in the background, in the hidden rows.
So I'm going to undo that, and I'm going to show you a tip that I learned from my friend, Khushnood Viccaji, and it makes copying and pasting much easier.
Select Visible Cells
First, I'm going to select the cells that I want to copy.
Then press Ctrl and select the cells where you want to paste the data.
To get this information from here to here, we're going to make sure only the visible cells are selected.
So press the Alt key and semi-colon(;)
And now only the visible cells in our selection are selected, and you can see little lines to separate them.
Copy to the Right
Now to get from here to here, we're going to fill, and we can fill to the right.
So I'm going to use the keyboard shortcut, which is Ctrl + R and it takes this data, and puts it in the cell to the right.
Even though it wasn't to the immediate right, that shortcut works well for getting information to the next cell that's selected on the right.
So none of the other data was overwritten. We can see that all the data went into the correct cells.
Now in this case, we were filling to the right, so we could use a keyboard shortcut.
Copy to the Left
But if these dates weren't filled in and we wanted to copy from here to the left, there's no shortcut for that.
So I'm going to select these cells first, and then the cells where I want to paste.
Again, to select just the visible cells (press) Alt + Semi-colon; go to the HOME tab, and here's the fill.
If I click that I can fill left, and now the dates from this cell are filled into the selected cells at the left.
Get the Workbook
For more Excel tips and tutorials, and to download the sample file for this video, please visit my Contextures website at www.contextures.com
