Category Archives: Microsoft Office

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 https://sourceforge.net/projects/movewindows/
Download link: https://sourceforge.net/projects/movewindows/files/latest/download

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.
http://www.gmayor.com/downloads.htm
Look for Datecalc.zip on that page.