Author: Oscar Cronquist Article last updated on August 02, 2018

Making your sheets easy to read is a fundamental approach of creating useful worksheets. Your message must be crystal clear, a misinterpreted sheet can be devastating. A sheet must be easy to read and follow.

The above picture is an example of a simple sheet with some random numbers. It is really hard to follow let us say Kiwis monthly numbers to the right. Scrolling and larger columns is also a troublemaker for readers. Sheets printed out on paper has the same problem.

Zoom level

Use the zoom in and out buttons located at the bottom right of your Excel window to use your screen area more efficiently.

The "Zoom to Selection" tool located on tab "View" on the ribbon allows you to quickly zoom in to your selected cell range.

The "Zoom to Selection" tool is quicker than trying to use the + and - zoom buttons which are not that granular to make it a perfect fit.

The shortcut keys to zoom to selection is Alt + w + g. First press and release Alt then press and release w and lastly press and release g on your keyboard.

Font size

Increase the font size to make the text easier to read.

  1. Select the data.
  2. Go to tab "Home" on the ribbon.
  3. Click the font size drop-down list.
  4. Select a size.

Create an indent

Follow these steps to add an indent to all cells on the worksheet:

  1. Click the upper left button of your cell grid to select all cells.
  2. Click on the indent button on tab "Home" on the ribbon.

This moves all values to the right making the worksheet more visually appealing.

Resize column width

The picture below shows columns with variable width based on cell contents.

It is also visually appealing to have the same width of all columns. Follow these steps to make all columns on your worksheet equally large.

  1. Click the upper left button of your cell grid to select all cells.
  2. Click and hold with left mouse button on the column line with the largest width to see it's column width.
    The picture below demonstrates the line to click and hold in order to see the width of column A.
  3. Now click and hold on a column line of a smaller column.
  4. Drag to the right to increase the column width, make it as big as the largest column.

Voila! All columns now have the same width as the largest column on your worksheet.

Lock first row and column while scrolling

Excel allows you to keep specific rows and columns visible while the remaining worksheet scrolls. This makes it easier to read huge data tables, you always have the headers visible.

  1. Go to tab "View" on the ribbon.
  2. Click "Freeze Panes" button
  3. You now have three options:
    1. Freeze rows and columns based on the selection.
    2. Freeze top row.
    3. Freeze the first column.

There is a thin line between the frozen column or row and the rest of the worksheet.

You also have the option to convert the data set to an Excel defined table, this will automatically keep the headers visible while scrolling the data. The image above shows you an Excel defined table.

  1. Click a cell in the data set you want to convert to an Excel defined table
  2. Press CTRL + T
  3. Select checkbox if the table contains headers.
  4. Click OK button.

Two worksheets visible on the same screen

You can create a new window of the same workbook by pressing the "New Window" button on tab "View" on the ribbon.

The click the "Arrange All" button to arrange windows. Select check box "Windows of active workbook" to only arrange the current workbook.

  • Tiled is good for many different windows.
  • Horizontal and Vertical is, in my opinion, best for two worksheets.
  • Cascade lets you see all Excel window names in a nice layout.

Use the Split button found on tab "View" on the ribbon to divide the same worksheet into two or more views.

This allows you to scroll each view independently letting you examine, for example, two different datasets, located on the same worksheet, simultaneously.

If you select a cell next to the column letters or row numbers and then click the "Split" button Excel will divide the worksheet into two windows, see image above.

Any other cell selected will divide the view into four different windows.

Tip! Click and hold on a split line and then drag to change its location.

Create a chart

Insert a chart to create a better experience and enhancing the message you want to send.

Check out the charts category for more in depth articles.

Use sparklines to visualize data

Sparklines is a new tool in Excel 2010, it visualizes data in a single cell in a simplistic form. No x and y-axis only the line.

  1. Select the cell range containing the data you want to use.
  2. Go to tab "Insert" on the ribbon.
  3. Click "Sparklines" button.
  4. The data range should now be selected, you will only need to select the location of the spark lines.
  5. Click OK button.

Highlight every other row

The following article explains how to highlight every other row using Conditional Formatting.

Highlight every other row

Here is how to highlight every other row using conditional formatting. Conditional formatting formula: =ISEVEN(ROW())*OR($B3:$D3<>"") Alternative CF formula: =EVEN(ROW())=ROW() This […]

Highlight selected row

This article explains how to highlight the row or column based on the selected cell.

Highlight row and column of selected cell

Today I would like to share with you these small event handler procedures that make it easier for you to […]