Formatting Blank Cells By formatting blank cells you can force the data that is entered to be formatted how you would like it. See below examples of how data can look when entered on both an unformatted and formatted worksheet. Setting Formatting Select either the entire row/column or cells you wish…
Do you want your data to look consistent at all times? Do you require dates in specific consistent formats? Do you need the text case to be consistent? Need to prevent or remove extra spaces from text cells? All of the above items are things that are regularly inconsistent in worksheets, especially when there are…
Have icons/tools disappeared from your MS Office Toolbar? If the item you are missing is an add-in i.e. not part of basic MS Office functionality then you may be able to resolve the issue as follows: Check for Disabled Items Disabled items can occur if the application you are working in encounters an error, it…
Table of Contents not working how you want it to? Here are some of the most common TOC errors and how to fix them.
The formatting of a table of contents does not always appear exactly as you would like. You can easily modify the fonts, colours indents etc. You can also apply these to different levels of the table of contents to make it easier to differentiate between multiple sub-levels of headings. Formatting a Table of Contents You…
When creating or editing a long document you may benefit from creating a Table of Contents for the document as finding the clauses/paragraphs you wish to look at can be time consuming and tedious. The Benefits of a Table of Contents Once created if you change the document i.e. add new paragraphs or alter page…
Things not working correctly in Mattersphere? There are some common issues that can occur that you can fix yourself with relative ease. If you are unsure what the issue is please try the following steps before contacting IT Support as these may resolve the problem and ultimately save you time. Unexplained Issues – Clear the Cache BE…
Introduction Excel is a very complex tool that likes to behave in a certain way and sometimes that isn’t always convenient to what you are working on. Below are some simple tips to help resolve issues or generally make your Excel work a little more controllable. Want to put a new line into the same…
Fusion are offering up to 4 hours of free training, onsite at client premises during January 2018, this is exclusively for existing MatterSphere clients*
What is Track Changes? Track Changes is a setting in a Word document that allows you to view any changes that have been made.