Friday 2 January 2015

Adding same text to multiple selected cells without VBA


Adding same text to multiple selected cells without VBA.

Quite simple!

- Select multiple cells

- Insert text. Assuming 0 to any one of  the selected cell.

- Instead of TAB/Enter use CTRL + ENTER

Here we go. All selected cell would automatically populate with the same text.

 

No comments:

Post a Comment