Tag Archives: Office

Add Reminders To Outlook Appointments

photo credit: Andrew Coulter Enright If like me your Outlook calendar can get a bit hectic and others can add meetings to your calendar sometimes you end up simply “reacting” to your schedule and jumping from one appointment to the … Continue reading

Posted in Microsoft, Misc, Office, Productivity, Technology, Work | Tagged , , , , , , | Leave a comment

Multiple Excel Text Boxes With Common Content

I have just had to place a textbox object onto 17 worksheets within the same excel workbook, each text box containing the same commentary text. Type it once and then copy the text box and paste, job done. Of course … Continue reading

Posted in Microsoft, Office, Windows, Work | Tagged , , , , | Leave a comment

Microsoft Office–VBA Editor Keeps Opening

For weeks now I have had the mild annoyance that the VBA code editor for various Excel spreadsheet’s appear to be opening at “random”. I finally tracked it down to me unlocking my PC. If I have excel running then … Continue reading

Posted in Microsoft, Office, Windows, Work | Tagged , , , , | Leave a comment

Changing Excel Cell Values To Uppercase

A nice quick tip, I had lots of cell values in a mixture of cases that should have been uppercase. Create a macro: sub MakeUpper() for each myCell in Selection   myCell.Value = UCase(myCell.value) next myCell end sub Add a … Continue reading

Posted in Microsoft, Office | Tagged , , , , | Leave a comment

Update All Fields In MS Word

Sometimes you find a feature in a product that is just blatantly missing. One of those in Microsoft Word is the ability to update all the fields in the document with the latest value in a field. I use both … Continue reading

Posted in Microsoft, Office, Work | Tagged , , , , , | 1 Comment

Favourite Shortcut Keys – Outlook

photo credit: laffy4k If you look at the left hand menu you will see the items: Mail Calendar Contacts Tasks etc These can be quickly accessed by using the following shortcut keys: (Ctrl+1) – Mail (Ctrl+2) – Calendar (Ctrl+3) – … Continue reading

Posted in Microsoft, Office, Technology | Tagged , , , , , | 2 Comments

Microsoft Word 2007 Keyboard Shortcuts

I use Microsoft Office 2008 on my work laptop. Whilst I am no touch typist; I wish I could take the productivity hit whilst I learn, I do prefer to use the keyboard for most functions, growling when I have … Continue reading

Posted in Microsoft, Office, Work | Tagged , , , | Leave a comment

Microsoft Excel 2007 Annoyances

I have had office 2007 on my laptop for ages now. Like everyone I am still using the “old” file formats until the rest of the world catches up. On the whole I have been impressed by the ribbon interface. … Continue reading

Posted in MIG, Maxima, Maxima Information Group, Microsoft, Work | Tagged , , , , , , | Leave a comment