Create a multi cell array
Open a new, blank workbook. Prepare your worksheet data, say like this:- Sales Person Car Type Number Sold Unit Price Total Sales Barnhill Sedan 5 2200 Coupe 4 1800 Ingle Sedan 6 2300 Coupe 8 1700 Jordan Sedan 3 2000 Coupe 1 1600 Pica Sedan [...]
Read More →Excel – Space-delimited content
Split space-delimited content To complete these steps, copy the following sample data to a blank worksheet. 1 2 3 4 A Syed Abbas Molly Dempsey Lola Jacobsen Diane Margheim Select the range of data [...]
Read More →Using track changes in a document being changed by multiple users
If you have a document which is going to be used by multiple users, track changes is a good way to see where changes have been made by another user. You can then accept these changes if you like them, or make further changes do [...]
Read More →Creating a Word document template
This is helpful if you use a document frequently and you don’t want to have to keep re-typing or reformatting the information. A template is a document type that creates a copy of itself when you open it. It allows you to have predefined page [...]
Read More →Adding a Page Number in a Word Document
Quite frequently, when completing a long document, you want to insert page numbers. Sometimes this can be tricky. Here is a brief overview of how to do this:- Adding a header or footer that includes a page number Add a header or footer that includes [...]
Read More →
Tutorials
We have spent some time detailing common stumbling blocks people come across. Feel free to pass these helpful links onto your friends and colleagues too.
Ms Harpen
