Chapter 5. Planning your worksheet design

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

Get Microsoft Excel 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.