Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fonts and scrolling (Excel 2000)

    Hello all:

    Two questions:

    1. Can the default font size for comments be changed & how?

    2. Can tiled spreadsheets be sync'ed so they can be scrolled together & how?

    TIA for any and all assistance.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fonts and scrolling (Excel 2000)

    Hi Bill

    1. The font size for comments is picked up from the font size for tool tips. To change the size do the following (instructions for Windows XP)
    <UL><LI>Right-click on the desktop and select Properties
    <LI>On the Appearance tab click Advanced.
    <LI>From the Item dropdown select Tooltip
    <LI>Choose a font Size then click OK twice[/list]2.Synchronized scrolling was introduced in Excel 2003 (called compare side by side).

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fonts and scrolling (Excel 2000)

    Just remembered, you can also manually change the font size in comments.
    Edit the comment, highlight the text and you can then change the font size using the formatting toolbar.

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fonts and scrolling (Excel 2000)

    Tony: Thanks for your reply. We knew about manually changing, the default is what's needed. I'll have to upgrade the user to Excel 2003 for the synchronized scrolling. Thanks again.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Fonts and scrolling (Excel 2000)

    <P ID="edit" class=small>(Edited by sdckapr on 02-Jul-04 07:56. Added PS with a better post)</P>Check out <post#=264633>post 264633</post#> for some code to change the comments after the fact to the desired size/ color, etc. Modify as needed.

    I generally don't recommend changing the tooltip default, since it affects most windows programs not just excel comments.

    Steve
    PS <post#=290956>post 290956</post#> is probably better since it avoids selecting. It also changes the fill color.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fonts and scrolling (Excel 2000)

    1. see the replies to <post#=290786>post 290786</post#>.

    2. Synchronized scrolling was introduced in Excel 2003 (some 15 years after Lotus 1-2-3.) You can synchronize two windows on the same worksheet in code: see Can't Synchronize Windows By Choosing Arrange All

Posting Permissions

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