Neale Blackwood CPA colours your world and positions charts.
Q.
Excel wont display the cells fill colours. The colour is there when I print out, but it doesnt display on the screen. The file is OK when I view it on another computer. Is there a setting I need to change?
A.
You need to change a Windows setting. Click Start, then click Control Panel, and open the Accessibility Options. Click the Display tab, and then click to clear the Use High Contrast checkbox. Click OK to close the Accessibility Options dialog box. You may need to restart Excel or your computer for the change to take effect.
Q.
Is there an easy way to position charts so that they line up exactly on the left-hand side?
A.
If you hold down the Alt key (next to the space bar) when you move the chart around you will see that it snaps to the cell grid and makes it easy to line up. This also works for text boxes and other graphic objects you move around on the sheet.