In all our previous blog posts in this series on Excel we have covered using Formatting and validation on empty cells in order to maintain consistency of newly added data. These same skills for formatting can also be applied to worksheets already containing data that you wish to change the formatting to a style of…
Validating is a way of preventing the incorrect entry of data. It can also produce warning screens and error messages to give information to users entering the data. Example 1 You wish to have a column in a worksheet that displays the date in the format of 28 June 2018. You can use the formatting…
This post is a continuation from our last blog about Detailed Formatting in Excel. In this post we will look at the remaining options on the Format Cells>Number Tab Format Number We will be exploring the Format Number tab when formatting cells in order to apply specific formats from Percentage to Custom Select the Column,…
Following on from previous posts this post will look at the specific variations of formatting that can be applied to blank cells to ensure consistency through cells containing the same data type and also to ensure the worksheet is displaying data in the format you prefer to use. TOP TIP: To format whole columns without…
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…