Microsoft Office Tips & Tricks

InIT Software Training Blog – On Course for Success

Windows Taskbar

How to navigate the programs pinned to the Taskbar

Windows Taskbar

The programs that are pinned to the Windows taskbar and the open programs that have been minimised to the taskbar can be opened by holding the windows key down and then pressing a number key.

Windows Key + 1 = the first pinned program

Windows Key + 2 = the second pinned program

and so on.

Audio Available

Excel – How to use the Evaluate Formula Tool

Find Formula issues with the Evaluate Formula Tool – How to use the tool

This video shows you how to use the Evaluate Formula Tool in Microsoft Excel. This is a great tool if you have created a formula and it’s not quite working properly or you have inherited a spreadsheet and you want to see what is happening with a rather complex formula.


Access Database Zoom Box

How to use the Access Zoom Box

The Access Zoom Box allows you to temporarily change the font properties within the zoom dialog box e.g. colour and size of font in order to make viewing or editing easier.

Word: Cut or Copy to Spike

How to Cut or Copy to Spike in Word

The Spike is a feature I don’t see used very often. When you normally copy and paste the copy goes into the clipboard, but you can only copy one section at a time. The spike allows you to copy several sections one at a time and stacks them together so when you past from the spike all the sections are pasted. This also removes the copied sections from the spike.

Remove Page Break Lines in Excel

Remove Page Break Lines in Excel

This video explains how to remove those really annoying page break lines on an Excel worksheet using one line of VBA code. Any level of user can do this.

 VBA Code

Sub PrintLines()
'Removes page break dotted lines
'Create in Personal Macro workwook
'Place link in Quick Access Tool Bar
ActiveSheet.DisplayPageBreaks = False
End Sub

Save As

F12 Key – Save As

Save As
The F12 key is a great way to select the Save As dialog box.

Ctrl + S is the shortcut for Save.

Pressing the F12 function key gets you to the Save As dialog much faster than clicking the File ribbon tab for the backstage view and then clicking Save As.

Virtual Desktops

Windows 10 Virtual Desktops

This is an ideal way to organise the work you are working on during the day. This is great if you a multitasking several jobs at once.  Also if you wish to toggle through the desktops without the mouse then hold the windows key and use the arrow left and right arrow keys.