Microsoft Office Tutorials and References
In Depth Information
The Layers of Excel
A characteristic of Excel is its virtual layers. These layers are laid one over another,
which is helpful in designing your prototype. Understanding these layers can help
you create different effects in Excel. The layers are
Layer 1: Background image; an imported file can be used as a tiled background.
Layer 2: Cell background color; these colors will cover any part of a background
Layer 3: Cell text; the text will appear superimposed on a background image or
the background color.
Layer 4: Graphical images, auto shapes, and other drawing elements form the
top layers. You can adjust overlap order of graphics within layer 4 by
using send-to-front and send-to-back functionality. In practice, avoid using
more than three graphical layers.
4. With the entire worksheet still highlighted, right-click any cell and choose
Format Cells (Figure 3.8).
5. Select Text in the Category list (Figure 3.9, page 46).
Selecting Text from the list stops Excel from autoformatting numbers.
Autoformatting of numbers can result in unintended consequences to the prototype
by automatically converting dates, percentages, and other number formats.
6. Click the Alignment
tab and set the vertical alignment to Top (Figure 3.10,
Setting the alignment to top makes text appear at the top of every cell by
default. You can set middle or bottom if you prefer. Whatever alignment you
choose, it is useful to have as a default across all your prototypes.
7. Click the Font tab and set the font to Arial, the font style to Regular, and the
size to 10 (Figure 3.11, page 48).
The font settings become the default whenever you enter text in the canvas
worksheet. If you have a style guide for the user interface that you are
designing, you can use those font characteristics in your design. Don't worry if you'll
need more styles for your design
you can easily override the default setting
in individual cells.