Category Archives: Microsoft Office

Excel Documents Opening Twice

A client recently called me because whenever she tried to open an Excel document, it opened twice.

After some research, I found that the issue only occurred with Password Protected Excel sheets when the Preview Pane is turned on in Windows Explorer.

The only real option to avoid confusion is to turn off Preview whenever you open a Password Protected Excel document.

Thanks for vinnyp for the answer given here:

Although that link discusses older versions of Excel, the issue my client was having was with Excel 2016.

Windows program lost off screen

I recently had a client whose Microsoft Outlook window would not show. After using Windows System Restore a few times to fix it, i was forced to look into it further.

I discovered that something was causing it to go off-screen. Maximising it helped by using Task Manager, but it wasnt a solution and when not maximised, the problem was still there.

I downgraded to 32Bit office, to see if that would help but i still needed to get it back onto the screen.

Thats when I found this program which checks all running applications are within the available screen.

More info
Download link:

I repost if the 32bit downgrade didnt help.



Sorting by Surname when Firstname and Surname are in one column

Microsoft Excel – Howto Sort

This is a guide to sorting by Surname when the Firstname and the Surname are in one column.

Here goes.

You can’t without putting the firstname and the surname in separate columns.

However, there is an easy way to separate them.

1. Highlight all column that contains the firstname and surname.

2. Click the Data tab then click ‘Text To Columns’

3. Select the Delimited option and click Next>

4. Under Delimiters, check ‘Space’ and uncheck anythying else. Then press Next>

5. Click Finish and you should find that the Firstname and Surname have been separated to allow you to sort by Surname.



Adding Suffix to Date in Microsoft Word

This is a guide to adding a suffix (th nd st) to dates in Microsoft Word

Microsoft have not made it simple.

1) Put the cursor to the Insert position where you want the date to be.
2) In the ribbon bar click on the Insert tab, then Quick Parts, then Field.
3) Under Field Name, select Date and then click the Field Codes button.
4) In the Field Codes text box, type in this DATE \@ d \*Ordinal
5) Press OK and you’ll get the first part of the date with the suffix.
6) Press the Space bar to leave a space between the day and month.
7) Click on the Insert bar again, and Quick Parts again.
8) Then click Field, Choose Date again and click the Field Codes button again.
9) In the Field Codes box, type in DATE \@ “MMMM yyyy” including the speech marks.
10) Press OK and you should be done.

It wasnt easy to find that solution!
If you are interested, I got it out from this website which has an example document on how to manipulate dates in Word.
Look for on that page.