Document Excel Worksheets with Pictures that Include Row and Column Headings

When you document your Excel worksheets, give your readers complete information by including row and column headings in your figures.


When you document your Excel worksheets, give your readers complete information by including row and column headings in your figures.This image is a picture of a section of an Excel worksheet. Be sure to include pictures like this when you create your own documentation about Excel. Doing so makes your discussions about Excel formulas and formats much easier to read and understand.

Best of all, you can create a picture like this quickly and easily.

Balance sheet with Excel row and column headers

To do so, you temporarily need to tell Excel to include the row and column headings when you print your figure. To do so, first, in the Page Layout, Page Setup group in your Ribbon, choose Print Titles:

In the Page Setup dialog box, in its Sheet tab, check the Row and column headings check box. Then choose OK.

The Page Setup dialog with row and column headings checked.

Next, select the range you want to copy. In the Balance Sheet image above, I selected the range A1:F6.

Excel's Copy Picture dialog.To copy the picture to your Clipboard, in your Ribbon’s Home, Clipboard group, choose Copy, Copy Picture. In the Copy Picture dialog, choose the As shown when printed option button. Then choose OK.

Paste the picture as you always would. In Excel, or Word, or any other Windows program, select where you want your picture to be placed and then choose Ctrl + V.

Finally, when you’re done copying your pictures, be sure to return to the Page Setup dialog and remove the checkbox. Otherwise, your printed Excel reports will include the row and column headings.

One final note…

When you copy the picture it won’t show your print range. If you want to include it in your picture, you’ve got to add it manually. To do so, you have two choices.

First, you could add a border with a dashed line style. But with that method, you might create more work for yourself when you want to remove the border.

Second, you can illustrate the print range using Excel’s Rectangle shape. To do so, in your Ribbon’s Insert, Illustrations group, choose Shapes. In the Rectangles section, choose the Rectangle. Then click and drag your mouse pointer to create the rectangle.

By default, the rectangle has a solid border and obscures your contents behind its fill color. To cure both these problems, with the rectangle selected, in your Ribbon’s Drawing Tools, Format, Shape Styles group, choose Shape Fill, No Fill. And then, in the same group, choose Shape Outline, Dashes, and then choose the dash style you want.