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

How do I choose my password?

How do I choose my password? Your password is more than just a key to your online account. If your password falls into the wrong hands, someone can easily impersonate you while online, sign your name to online service agreements or contracts, engage in transactions, or change your account information. So, choose your password carefully and then keep it safe from others. A password is like a toothbrush: Choose a good one and don't share it. A Yahoo! password can be any length, and can contain spaces, symbols, or numbers. With so many options, you should be able to come up with a password that's easy for you to remember but impossible for someone else to figure out. A password is a secret that only you should know. Here are some tips for choosing a strong password - one that is difficult to guess. . Choose a password you'll remember. It should be memorable for you (so that you don't have to write it down or leave it in the open), but difficult for others to guess....
Post a Comment
Read more

Tech Tip - How to Search Like a Pro

Technology Tip - How to Search Like a Pro The internet is big, really, really big.  And it keeps growing bigger every day.  If you want to search it effectively you’re going to need to develop a couple of tricks to help you narrow the search.  Here’s a few real easy ones to integrate into your next search: Using +, - and “ “ (quotes) to narrow your searches: Lets say you were looking up apples on   Google.com .  If you just type in “apples” you get 22 million returns.  A few more sites than you can check in an afternoon so lets narrow the search down.  Let's say that what you're really interested in is   green apples .  To see all the apple websites that also have the word “green” on them type this: Now you will only see those apple sites that also have the word green on them.  Unfortunately we are still getting almost 6 million returned websites: To narrow the search even more lets elimina...
Post a Comment
Read more