Keyboard Shortcut for double clicking Fill Handle to paste value in rest of column?
Is there a keyboard shortcut to apply the same function of double clicking on the Fill Handle (bottom right hand side of cell plus sign) so that you can copy and paste a certain value of a cell to the rest of the cells in that column?
Pictures Attached showing desired shortcut.
Fill Handle Double Click.PNGFill Handle Pasted In Cells.jpg
Thanks.
Select cell, press and hold Shift and and use arrow down for as long as you need, press Ctrl+D
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello. Thanks for your input. Whilst dealing with large amounts of data, is there away to arrow down/scroll down/highlight all the way down to the end of the column you are trying to paste into all at once with a certain shortcut, or is this the only method? Just looking for a time saver without having to switch back to the mouse.
Thanks.
..........
Last edited by bachfantasia; 01-03-2014 at 06:29 PM.
..........
In the directions I provided in post #3 you don't use mouse at all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks