Formatting

Home/Formatting

 Stop Zeroes Displaying

 Stop Zeroes Displaying Is it possible to stop zero values displaying in a range? By Neale Blackwood That can be achieved using a Custom Number format. First select the range, then click the Format menu and select Cells (Ctrl + 1 will open the Format Cells dialog box). Click the Number tab and select [...]

 Shading Rows Automatically

Shading rows automatically I've seen spreadsheets with shading on every second row. Is there an easy way to do this, other than manually formatting the rows? By Neale Blackwood Conditional Formatting is the easy way to achieve this effect. Using alternate shading makes reading wide spreadsheets easier. First select the range you want the [...]

 Format Error Cells

Format error cells Is there an easy way to highlight all the cells that have error messages By Neale Blackwood There are a couple of ways. Select cell A1, press F5, click the Special button. Select the Formulas radio button and uncheck all the entries under it except Errors. Click OK. You now have [...]

 Change Default Cell Comments Font Size

Change default Cell comments font size How do I change the default font size of cell comments? By Neale Blackwood You need to change a Windows setting to achieve this. Please note this will change the font size of other objects defined as "ToolTip" in applications. You may want to change it back, so [...]

 Hiding Cell Contents

Hiding cell contents I use the white font colour to hide values in a cell, but if the cell's fill colour is changed, it displays the entries. If you select the cells you can also see them. If Black and White is selected in Page Setup the entry will print. Is it possible to [...]

 Fix For Missing Fill Colours

Fix for missing Fill Colours Excel won't display the cell's fill colours. The colour is there when I print out, but it doesn't display on the screen. The file is OK when I view it on another computer. Is there a setting I need to change? By Neale Blackwood You need to change a [...]

 Easy And Quick Formatting

Easy and Quick Formatting Format Painter By Neale Blackwood One of the more useful toolbar icons is the Format Painter. It looks like a yellow paintbrush. It allows you to click on a cell that has a format you want to use and then click the Format Painter (notice that the mouse cursor shape [...]

 Merge And Center Warning!

Merge and Center warning! Formatting issue By Neale Blackwood Ever had an error message which stated that you couldn't do something to a merged cell? Well the merge format is the culprit. The Merge and Center tool on the toolbar is commonly used to format headings to make them look good by centering a [...]