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!!!!!