Skip to main content

Tech Tips - Squinting to read your comments? Change your default comment box text (Excel 2000/2002/2003/2007)

Squinting to read your comments? Change your default comment box text (Excel 2000/2002/2003/2007)

You can change your default comment box font, as long as you’re willing to stick with the change in other applications as well. The only way to change your default comment box text is to change your Windows ToolTip display setting, which affects more than just Excel.

To adjust your default comment box font (Windows XP):

  1. Right-click on your Desktop and choose Properties from the resulting shortcut menu.
  2. In the Display Properties dialog box, select the Appearance tab.
  3. Click the Advanced button to open the Advanced Appearance dialog box.
  4. Choose ToolTip from the Item dropdown list, and then set your font preferences.
  5. Click OK to close the Advanced Appearance dialog box. Then, click Apply in the Properties dialog box. Your new settings load. Click OK to return to your Desktop.

To adjust your default comment box font (Windows Vista):

  1. Right-click on your Desktop and choose Personalize from the shortcut menu.
  2. Click Window Color And Appearance in the Personalize Appearance And Sounds window.
  3. Click the Open Classic_Appearance Properties For More Color Options link to open the Appearance Settings dialog box.
  4. Click the Advanced button to open the Advanced Appearance dialog box.
  5. Select ToolTip from the Item dropdown list and then choose your font settings.
  6. Click OK to dismiss the Advanced Appearance dialog box, and then click Apply and OK in the Appearance Settings dialog box to make the change.

 

Link your Word page to a specific place inside an Excel workbook

In our last week's_tip, we showed you how to link your word file to Excel sheet. We’ll now create a link to a specific cell inside an Excel workbook and then we’ll create a link to a named range.
Link to an absolute address in Excel
Press [Ctrl][F9] in Word with the cursor placed where you want to create the hyperlink. Then, type the following inside the curly braces that Word creates for you:
HYPERLINK “C:

    \\MyFolderOne\\MiscDocOne.xls

#’Sheet One’!A1”
Notice that we’ve enclosed the name of the particular sheet in single quotation marks. This is essential if the sheet name contains a space.
Link to an Excel named range
You can also create a link to a named range in Excel. Suppose there’s a named range called Export in the worksheet named Sheet One. You’ll need to type in the following after creating the curly braces with [Ctrl][F9]:
HYPERLINK “C:

    \\MyFolderOne\\MiscDocOne.xls

#’Sheet One’!Export”
If there is a Workbook range named Export in an Excel file named MiscDocOne, then you’ll need to type in the following after creating the curly braces with [Ctrl][F9]:
HYPERLINK “

    C:\\MyFolderOne\\MiscDocOne.

xls#Export”
HYPERLINK

    “C:\\MyFolderOne\\MiscDocOne.

xls#Export”
Do not assign the same name to both a sheet range as well as a workbook range in Excel as that might confuse the application. Ensure that range names are either all sheet-specific or workbook-wide.

 

Thanks & Regards

============================

Mohammed Rahman Mecheri

 

System Analyst – Network & Infrastructure
Kamal Osman Jamjoom Group LLC.
Unit #422, Sultan Business Centre
P.O Box 27844, Dubai, UAE
Tel:       +971 (4) 3355232 Extn: 1339
Fax:      +971 (4) 3355231
Mobile:  +971 (50) 9774048
Email:    mrahman.koj@gmail.com

             mrahman_koj@hotmail.com

             mrahman_koj_est@yahoo.co.uk

Web :    https://about.me/mrahman

============================

 

Comments

Post a Comment

Please write your comment

Popular posts from this blog

Tech Tips - Turn on Delegate Access

Turn on Delegate Access A delegate automatically receives Send on Behalf permissions. This means your delegate can do the following: ·          Respond to a meeting request sent to you, the manager. ·          Receive meeting request responses sent to you, the manager. ·          Compose and send an e-mail message that, when received, will have Delegate Name   on behalf of   Manager Name   next to   From . By default, the delegate can read only the meeting requests and responses sent to the manager. The delegate does not have access to read any other messages in your   Inbox . 1.      On the   Tools   menu, click   Options . 2.      Click the   Delegates   tab, and then click   Add . If the   Delegates   tab or the   Add   button is mi...
Post a Comment
Read more

Multiple Choice Love Letter - Q&A Type Reply (Hilarious)

A teenage college guy sent a love letter (in Q/A format) to his classmate.   My Dearest Ishaa,     Please answer the following questionnaire. For Options   (A) 10 marks, (b) 5marks and (c) 3 marks.   **********   1) Whenever you enter the class room, your sight always falls on me because:   (a) of love (b) you couldn't control seeing me (c) really ... Am I doing it?   **********   2) Whenever professor cracks joke, you laugh and turn and look at me because:   (a) you always like to see me smiling (b) you are testing whether I like jokes (c) you are attracted by my smile   **********   3) When you were singing in the class, I entered and immediately you stopped singing because:   (a) you are so coy to sing before me (b) my presence influenced you (c) you feared that whether I'll like your song   **********   4) When you were showing your childhood photo, when I asked for it, you hide it because:   (a) you fel...
Post a Comment
Read more

Healthy Heart - Tips

(Attchd): Heart Attack + Natural Home therapy for opening the veins of the heart. For Heart Vein opening: Lemon juice              01 cup Ginger juice              01 cup Garlic  juice              01 cup Apple vinegar            01 cup Mix all above and boil on low heat, approximately half  hour, when it becomes 3 cups, take off stove and let cool. After cooling, mix 3 cups of natural honey and keep it in bottle. Every morning before breakfast  use one Table spoon regularly. Your blockage of Vein's will open. No need now for any Angiography  or Bypass... Please pass on this to your real well wishers... Wishing you a healthy life     Thanks & Regards ============================ Mohammed Rahman Mecheri ...
1 comment
Read more