As far as I know, there is no way to position a comment.
You can change the size using VBA code.
You may want to consider using Data Validation...
with Settings to allow any value
with Input Message check marked and your text entered
with Error Alert not check marked.
You can position the displayed message manually and it looks like a comment.
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html (editorial review )
..
..
..
"Esradekan" <(E-Mail Removed)>
wrote in message
news:d2ef7b00-4ce5-4491-a6da-(E-Mail Removed)...
On Sep 12, 11:23 am, Esradekan <esrade...@gmail.com> wrote:
> I wish to insert comments for particular cells, but wasnt the comment
> to appear in a specific location, not the default location. How can I
> do that?
>
> TIA
> Esra
Oh, using Excel 2007.
Thanks
Esra