Posted on 2 Comments

How to fix corrupted styles in Microsoft Word

Styles get corrupted when a document that was created in a newer version of Microsoft Word is edited in a older version. Basically the newer version brings in the style definitions (embedded in the file) that the old version doesn’t “understand” and cannot interpret.
To fix this problem go to Styles and Formatting pane and select Show: Custom; find all instances of the char style and delete them (one at a time)
Sometimes the files cannot be deleted and you can run a macro to remove them:

Sub DeleteChar()
    Dim style As Word.style, doc As Word.Document
    Set doc = ActiveDocument
    Set style = doc.Styles.Add(Name:=”replaced”)
    On Error Resume Next
    doc.Styles(“Name_of_the_Style”).LinkStyle = style
    style.Delete
       
End Sub

Posted on Leave a comment

How to remove the “shortcut” suffix when a shortcut is created

Every time a shortcut is created Windows automatically append the “shortcut” suffix. To remove it you have to edit the registry (this applied to Windows 7)

Shortcut

To open the Registry Editor type regedit in the Search Programs and Files box and press Enter.

regedit

Look for the following key:
HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionExplorer
and double click on link to edit the binary value.

Registry Editor

Now change 1E with 00 and click OK.

Edit Binary 1     Edit Binary 2

Close Registry Editor and restart your computer.
Next time you will create a shortcut the suffix will not be added anymore.

shortcuts 

Posted on 2 Comments

How to use Quick Parts in Microsoft Outlook

Outlook quick parts

Use Quick Parts to insert reusable piece of content or any preformatted snippets you create.
Simply highlight the entire block of text and images you want to add as Quick Parts. Now select the Insert tab and click on the Quick Parts button (which by default the list is empty). Click on the Save Selection to Quick Part Gallery…

In the Create New Building Block window type a name for this quick part, select the Gallery where to save it (you can add several galleries for different categories), and a description.

Click on the OK  button to add it to the gallery. If you click again on the Quick Parts button you will see it in the list.

Next time you need to use that block of text and image just select it from the Quick Parts list and it will be added in the email body.

Quick Parts is also available in Word

Posted on 1 Comment

How to change the default hyperlink font face/size in Excel

Microsoft Excel

I was having a problem with the cells containing hyperlinks –  the font was changing automatically into the default one (even though I have selected all cells and applied a different font).
In order to configure Excel to use the same font face/size as the one you selected for the entire sheet (or group of cells) you need to create a new default template that will load at startup. They didn’t make it easy to do in Office 2007! But here’s how:

  1. Open a new blank worksheet.
  2. Insert > Hyperlink > Paste in any link
  3. Home > Styles > Right click on the ‘Hyperlink style’ > Modify > Set your font options
  4. You probably will want to do the same for the ‘Followed Hyperlink’ style
  5. Delete the hyperlink.
  6. File > Save As > Other formats
  7. Browse to “%APPDATA%MicrosoftExcelXLSTART” (Copy/Paste that into the File name field and press Enter to get there easily)
  8. Save as type: Excel Template (.xltx)
  9. File name: Book.xltx

change hyperlink font in Excel



 

Now whenever you start Excel or create a new workbook, the hyperlink font should be the one you choose.
This Microsoft support article helped me: http://support.microsoft.com/kb/822107 look here for where to save templates for Office 2003, or to see other ways of loading your template.

 

Posted on Leave a comment

How to Enable Multiple Sign-In to Use Multiple Google Accounts

This only works with GMail, Google Calendar, Google Reader, Google Code, Google Voice and Google Sites.

1. Go to the Google Accounts page and sign into your default (primary) account.

2. Under Personal Settings, go to Multiple sign-in and click the Edit link.

image

 

3. Click the On – Use multiple Google Accounts in the same web browser radio button. Check the associated check boxes and click the Save button.

image

 

Now when you login to any of the supported Google products, you will see a dropdown arrow next to your email address in the upper-right corner. Click the arrow and sign in with your additional accounts.

image

Once you have signed into each account, they will be added to the dropdown list. From now on, all you have to do to access the accounts is use the dropdown list and select the desired account.

NOTE: When you have multiple sign-in enabled, you can no longer use the offline Gmail and offline Calendar.

Posted on Leave a comment

How To View Two Parts of the Same Word Document in the Same Time

To view two parts of the same document, click on the View tab on the Word Ribbon and locate the section named Window and the click on the Split button.

Split

Word will immediately place a grey line on the screen that you can move up and down with your mouse. This line is simply where you want the split to be on the screen. Just click the left mouse button where you want the initial split. You can move it anywhere to make one or the other split screens the size you want.

Windows Split

Notice that you now have two views of the same document. You can scroll each one independently of the other and see two places in your word document at the same time.

2 views

Each view of the document is treated like two separate documents even though you are viewing the same one. You can zoom, scroll, and even change the type of view (print, draft, outline, etc.) for each view individually. Any changes you make into one view will be made to the other view as well. You can edit the text in either view by simply clicking on it and typing.

Posted on Leave a comment

How play audio folder on Windows Media Player 12

Someone asked this question on superuser.com the following question:

It’s always been hard for me to add a music folder with subfolders to Windows Media Player’s playlist. I double click a file in the folder (or click on WMP shortcut), WMP opens, and I drag the other files or folders manually to the playlist.
Isn’t there an option to add a right-click context menu item that can automatically add all audio contents in a folder (with subfolders) to WMP playlist?

Below is my answer:
In Windows 7 by default this option is available in the right click menu only for optimized folder for music:
folderoptions
You have to change the Folder Option – set it to Music (right click on the folder and select Properties and then Customize tab)
Now, when you right click on that folder you will see the option to add it to Windows Media Player.
addtowmp