jmt

Link Text Box contents to cell contents Text box feature By Neale Blackwood Text boxes are useful because you can easily place them anywhere on your spreadsheet. You can link the contents of a text box to a cell. First draw a text box on your sheet. Then when the text box is selected [...]

Hiding sheet gridlines Display Feature By Neale Blackwood When you are designing a spreadsheet for others it can be useful to turn off the gridlines on some sheets to make them look more like pages and less like spreadsheets. You can then use colours and borders to emphasise the areas where the user should [...]

Color code your sheet tabs Built-in feature By Neale Blackwood Colour is a powerful communicator. Effective use of colour in your spreadsheets can make them easier to use and understand. One of the ways to use it is to colour code your sheet tabs. Eg you might have sheets for instructions, workings, data, input [...]

Wrapping Text Macro solution By Neale Blackwood The Wrap Text format is often used to reduce the width of a column and still allow the contents to be displayed, as it creates line breaks with a cell. Excel has an icon in the Home Ribbon in the Alignment Section to Wrap Text. The macro [...]

Display Fraction Custom entry By Neale Blackwood Ever needed to display a fraction in a cell and have it used in calculations? Well you can achieve that fairly easily by entering a zero and a space before entering the fraction. Entering "0 3/4" in a cell will display 3/4 and use 0.75 in calculations. [...]