January 2, 2008

Where’s That Located on the Printout?

Ever wish you had your gridlines, column letters and row numbers on the printout of an MS Excel worksheet?

On some of the larger worksheets or on worksheets where there aren't a lot of labels on the data, this tip could be the little "miracle" you've been looking for. Okay, maybe the word miracle is a bit strong, daily cialis results but then again, it all depends on how lost you've become in your data. It's all in the perspective!

I know sometimes I just have to see it in print to find the mistakes. If only that would ensure I could catch them all. I don't know about you, but some days, my mistake list seems endless!

At any rate, once you've made the decision that you need your gridlines and/or headings, your solution is just a few clicks away.

For people using older versions of Excel, your solution is found in the Page Setup information. So, we'll begin by going to the File menu, Page Setup choice.

Once the Page Setup window opens, you're looking for the Sheet tab.

In the middle section, called Print, you're looking for the Gridlines and Row and Column Headings checkboxes.

Make sure you select the items you need.

Click OK.

For Excel 2007 users, you need the Page Layout ribbon.

Check the Print box for Headings and/or Gridlines as necessary.

There you have it. All the labels and gridlines you could ever want!

Now, you know where to find everything!

Permalink • Print • Comment

Leave a comment

You must be logged in to post a comment.

Made with WordPress and the Semiologic theme and CMS • Sky Gold skin by Denis de Bernardy