Results 1 to 2 of 2
  1. #1
    the DAVE guy

    Cell Comments (97- SR-2)

    How do I keep Excel Cell Comments from changing the size and aspect ratio (height vs. width) and location relative to the cell? When I make changes to a spreadsheet and save it. Lots of the comments have narrowed down to little line thickness slits, grown to really large windows and/or been stretched way out to Tim-Buc-Tu.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Burwash, East Sussex, United Kingdom
    Thanked 229 Times in 210 Posts

    Re: Cell Comments (97- SR-2)

    Select the cell the comment is in. Choose edit comment. Right-click on the comment border (your cursor should change into a 4-way arrow when you're over the right bit) and choose Format Comment. On the Properties tab there are various options for moving or sizing with cells. Choose whichever suits you.
    Hope that helps.

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts