"Offering free computer help, hints, and tips to the Internet populace." Now with over 3,820 tips!

Microsoft Excel 2010

For Worksheet Drafts Print Default Headings And / Or Gridlines

SUMMARY: Don't want to spend time manually creating border lines or headers for a particular draft worksheet? Have Excel 2010 print default gridlines and column headings.

Though a simple tip, if you didn't know how to do this before, you'll be happy to know this option is available. By default, Microsoft Excel 2010 does not print gridlines, expecting that you will add your own borders to presented data. The letter column headings are also not printed, as you are expected to create your own descriptors for data.

Sometimes you may be working on an in-progress worksheet or one where time is of the essence and the worksheet style does not matter. In these situations you can quickly toggle the printout of gridlines and headings to help organize your data:

Example of a worksheet in Excel 2010 with gridlines and headings printed

1. Click the "Page Layout" tab in the Ribbon.

2. Inside the "Sheet Options" section, check the "Print" checkboxes underneath "Gridlines" and/or "Headings" as desired.

Return to the Microsoft Excel 2010 page.

Print this tip

Get the Newsletter

blog comments powered by Disqus

Thanks For Sharing!

Newest Tips:

Windows 8
Speed up Your Taskbar Thumbnail Previews
General Computers
[MODIFIED] Why Do Install Programs Ask Me to Close Everything or Restart?
Screen Capture
[MODIFIED] Greenshot for Windows can Upload to Dropbox, Flickr, Picasa, and More
Google Chrome
[MODIFIED] View Memory and CPU Usage, Network Activity of Each Tab

Follow Us!

About MalekTips and the Author

The MalekTips website was created in 1998 by Andrew Malek of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language. MalekTips also provides information and links to public-domain, open source, freeware, shareware, and commercial software available for download.