Fonts and scrolling (Excel 2000)

Topic

New Reply

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.

Reply | Quote

Replies

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)

• Right-click on the desktop and select Properties
• On the Appearance tab click Advanced.
• From the Item dropdown select Tooltip
• Choose a font Size then click OK twice
  [/list]2.Synchronized scrolling was introduced in Excel 2003 (called compare side by side).

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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)

• Right-click on the desktop and select Properties
• On the Appearance tab click Advanced.
• From the Item dropdown select Tooltip
• Choose a font Size then click OK twice
  [/list]2.Synchronized scrolling was introduced in Excel 2003 (called compare side by side).

Reply | Quote

(Edited by sdckapr on 02-Jul-04 07:56. Added PS with a better post)

Check out post 264633 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 is probably better since it avoids selecting. It also changes the fill color.

Reply | Quote

(Edited by sdckapr on 02-Jul-04 07:56. Added PS with a better post)

Check out post 264633 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 is probably better since it avoids selecting. It also changes the fill color.

Reply | Quote

1. see the replies to post 290786.

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

Reply | Quote

1. see the replies to post 290786.

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

Reply | Quote