Chapter 4

Making a Worksheet Easier to Read and Understand

IN THIS CHAPTER

Bullet Aligning numbers and text

Bullet Applying cell styles to data in cells

Bullet Splashing color on a worksheet

Bullet Preparing a worksheet before you print it

This short and pithy chapter explains how to dress a worksheet in its Sunday best in case you want to print and present it to others. It explains how to align numbers and text, insert rows and columns, and change the size of rows and columns. You find out how to decorate a worksheet with colors and borders as well as create and apply styles to make formatting tasks go more quickly. Finally, this chapter describes everything you need to know before you print a worksheet, including how to make it fit on one page and repeat row labels and column names on all pages.

Laying Out a Worksheet

Especially if you intend to print your worksheet, you may as well make it look sharp. And you can do a number of things to make worksheets easier to read and understand. You can change character fonts. You can draw borders around or shade important cells. You can also format the numbers so ...

Get Office 365 All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.