Quick Links



Home > Member Services > Publications > Magazines & Journals > INTHEBLACK > Excel > Excel yourself — October 2006

Excel yourself — October 2006


Neale Blackwood CPA colours your world and positions charts.

Q. 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?
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.
   

Reference: October 2006, volume 76:09, p. 16


Page last updated: Friday, 7 March 2008

Top arrow Top


Login Log in
Print-friendly version Print-friendly version
Add to my links Add to my links
Email this page Email this page