Thread: [Solved] how to gave comments to multiple cells at a time
View Single Post
 
Old 02-03-2012, 11:36 PM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
  
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default how to gave comments to multiple cells at a time
columns consist of 1,2
i selected only 1 value of cells
i want to add comments to all the 1 value cells
by selecting all 1 by shift + ctl +down
i can put same comments to all the cells?

If you want to have the same comment applied on many cells you could
apply it to a single cell, then use the copy and paste special tool bar commands (under Edit)
In Paste Special select "Comments"

but value is going of that cell
Reply With Quote