This video explains how to copy or fill a range of data or headings on one worksheet across to all or a range of selected worksheets in Excel. To learn more about Excel contact InIT Learning and Get on Course for Success. In-house (@ yours) and scheduled open courses available.
How to Customise the Background and Title Bar in Microsoft Office
The customise feature in the Microsoft Office feature has no real practical use other than to be more pleasing to your own eyes. The video shows you how to change background and title bar colours in Office 2010 and Office 2016.
Avoid the Embarrassment of Sending Wrong Emails by Delaying them.
Have you ever sent an email and as you click send realise that you have sent it to the wrong person, forgot some crucial information or forgot the attachment. The new Outlook does now recognise if you have mentioned attachment in your text and have forgot to attach it but if you delay your email by a few minutes at least you have a small window of opportunity to stop it being sent.
here is how to set that feature up.
Entering the degree symbol while typing in Microsoft Word.
- Hold Shift + Ctrl and press the @ key.
- Let go
- Press the space bar
Mini Toolbar Word, Excel and PowerPoint
To access the mini toolbar simply right click a cell in Excel or right click on selected text in Word or PowerPoint. In addition to the shortcut menu you will see a mini toolbar where you can select one of the common formatting commands.
When working in Microsoft Outlook it is sometimes useful to hide some of the panels so you can just view your emails or just view your calendar. The quickest way is to click the button on the bottom right of your Outlook just next to the zoom slider control.
Shortcuts to highlight text in Word
How to view windows side by side using the keyboard or mouse
Internet Browser Tips
One of the popular features of courses delivered by InIT Learning is the tips in the use of keyboard shortcuts. These can make work more productive and efficient.
Here are some tips when using most browsers.
Alt + D Moves the cursor to the address bar
Ctrl + + to increase the size of the font.
Ctrl + – to decrease the size of the font.
Ctrl + 0 Resets the text.
F11 puts the browser into Full Screen mode (F11 again returns the browser back to normal mode).
I just had a really strange problem with the AxtiveX Control that I had in a Form. The controls suddenly stopped working and in addition I was not able to delete and insert a new control. If you have the same problem here is the quickest way to solve it.
Start Windows/File Explorer
Select the system drive (usually C:)
Use the Search box to search for *.exd
Delete all the found files