O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making printing easier to read

When viewing large amounts of data on a computer screen it can be difficult to locate lines of data, especially when you need to scroll to the right; however, there are features that you can use such as freezing panes and highlighting. When printing, most of these options are not available.

In this recipe, you will learn how to utilize conditional formatting to add multi-colored bars to enhance visibility when printing Excel spreadsheets.

How to do it...

We will begin by selecting all of the values within the spreadsheet in order to apply formatting:

  1. Select all rows and columns of the Excel spreadsheet, by clicking the box to the right of column A and above row 1, or utilizing the keyboard shortcut Ctrl + A.
  2. From within ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required