Thursday 16 June 2016

Shortcut to copy paste single value or Formula on number of visible cells at a time

________________________________________________________________________________________
________________________________________________________________________________________
________________________________________________________________________________________
Excellent shortcut to copy and paste a single value or formula to number of cells at a time


Dear all many a times its so happen that we need to copy any particular value or formula to paste it on an excel worksheet only on the visible cells at a time. But i guess we fail to do so because when we paste that value it by default also gets pasted on the hidden cells.

Shortcut: ALT :(Colon)

Well! No more worry for the same. The shortcut appended below will take care of the problem very simply!!!!!!

All we need to do is copy paste the value

Now say suppose we want to paste value A in the table having values greater than or equal to 100. for this we hide the cells having value less than 100


Using filter option we only select the cells having value greater than or equal to 100


we type in 100 in that option and what we get would look like this




Now to paste A on only these cells we need to first copy the value....in this case A. thereafter we need to select the entire table were we want to paste the value in such a fashion



after selection the array now all we need to do is press ALT : (Colon) and the file would look like this


there after just enter and the final result will look like this




and now when we open the filter we get the result something like this.......

only the visible cells have value A that we pasted after using the shortcut.



Happy Reading!!!!!

1 comment:

  1. E Learning Microsoft Office: Shortcut To Copy Paste Single Value Or Formula On Number Of Visible Cells At A Time >>>>> Download Now

    >>>>> Download Full

    E Learning Microsoft Office: Shortcut To Copy Paste Single Value Or Formula On Number Of Visible Cells At A Time >>>>> Download LINK

    >>>>> Download Now

    E Learning Microsoft Office: Shortcut To Copy Paste Single Value Or Formula On Number Of Visible Cells At A Time >>>>> Download Full

    >>>>> Download LINK 0I

    ReplyDelete