Microsoft Excel 2013 Inside Out

Chapter 5. Planning your worksheet design

• Which data should be in rows, and which in columns?

• Will you need to print the worksheet?

• Who is the audience?

• Would your worksheet survive without you?

• Does the worksheet rely on imported data?

• Do you need more than one worksheet?

• Have you allowed room for new data?

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 fill ...