Microsoft Office Tutorials and References
In Depth Information
Chapter 5: Planning your worksheet design
Planning your worksheet design
Which data should be in rows, and which in
columns? ....................................... 123
Will you need to print the worksheet? .............. 125
Who is the audience?............................. 126
Would your worksheet survive without you? ........ 127
Does the worksheet rely on imported data? .........127
Do you need more than one worksheet? ............129
Have you allowed room for new data?..............129
IN THIS CHAPTER , we pose seven simple questions that might help you greatly when you
plan a worksheet. Although it’s not necessary to spend time planning every worksheet
you create, a little consideration can be helpful when planning worksheets you need to
pass on or share with others.
Which data should be in rows, and which in columns?
Sometimes the answer is rather obvious, but generally speaking, you’ll want the data that is
most abundant to ill rows rather than columns. Consider the readability of your data when
you make this decision. For example, a month-oriented worksheet like the one shown in
Figure 5-1 can work well with the month labels either across the top or down the left side
of the worksheet. But in this case, having the month labels down the side makes it easier
to view the worksheet on the screen and makes it easier to it it on a printed page. The
worksheet in Figure 5-1 contains only four columns of detail data, but if your worksheet
has more categories of detail data than the number of months, you might want to run the
months in columns instead.
Usually, the detail you accumulate in a worksheet best its into rows from top to bottom—
relatively speaking, a deep and narrow worksheet. It is not unheard of to build a
spreadsheet that is shallow and wide (only a few rows deep, with lots of columns), but you might
regret it later. A shallow, wide worksheet can be annoying if you must continually pan to
the right to find information or if you have to deal with odd column breaks when printing.
If you have a wheel mouse, scrolling up and down is extremely easy to do using the wheel,
but panning right and left requires clicking and dragging. And after you have the
worksheet filled with data, it’s time-consuming to change it—especially when you could have
designed it differently from the start.
You might also prefer the worksheet to be long rather than wide so that you can use the
Page Up and Page Down keys to navigate around the screen. When oriented horizontally,