Spreadsheets

SAN FRANCISCO (01/31/2000) - Excel users frequently ask me "How can I insert my company's logo into the page header?" The simple answer: You can't. Despite thousands of user requests, Microsoft Corp. hasn't made this feature available.

But there are a few ways to fake it.

Perhaps the simplest solution is to print your reports on company letterhead--paper that's preprinted with your logo. Another option is to use a custom font with a character that displays your logo. You can create this custom font using shareware or commercial font creation programs, or hire a professional to do the job. But even professionals will be limited to the use of simple line graphics.

Another way to display a graphic within a page header involves a bit of trickery. Excel lets you specify that one or more rows print at the top of every page (these are known as print titles). You can take advantage of this option and use a print title row to store your logo. Here are the basic steps.

First, specify the rows for the print titles. Choose File*Page Setup and click on the Sheet tab in the Page Setup dialog box.

You can also combine standard header options (found in the Header/Footer tab of the Page Setup dialog) with this title rows trick--but make sure the graphic doesn't obscure the text. For example, if the graphic sits on the left side of the page (as in the example), you'll need to put the page numbers in the right or center sections of the sheet's header.

Now here's where it gets tricky. Click the Print Preview button to preview your worksheet. In the preview window, click the Margins button to display the margin handles, which let you adjust the margins and column widths.

Specifically, you'll need to adjust the top margin and the header margin, represented by horizontal lines in the preview window. Normally, the upper horizontal line represents the header margin, and the second horizontal line the top margin. Drag these lines up or down until the page header looks correct. The result is that the graphic will align vertically with the normal header text.

If your worksheet happens to be wider than a page, you'll need to copy the graphic and paste it to the cell that occupies the same location on the subsequent pages.

Referencing a Sheet Indirectly

My Excel workbook has a sheet for each month, named January, February, and so on. I also have a summary sheet that displays key calculations for a particular month. For example, one of my formulas is: =SUM(February!F1:F10). Is there any way that I can enter the month name into a cell on my summary sheet, and then have my formulas use the data for the specified sheet?

Roger Blattner

San Clemente, California

Yes. Excel's indirect function was designed specifically for this sort of thing. This function accepts a text string as an argument, and then evaluates the text string to arrive at a cell or range reference. In your case, assume that cell B1 on your summary worksheet holds the month name. The following formula utilizes the INDIRECT function to create the range reference used by the SUM function: =SUM(INDIRECT(B1&"!F1:F10"))Note that I use the ampersand operator to join the month name with the cell reference (expressed as text).

Spreadsheets welcomes questions and tips and pays $50 for published items.

Contributing Editor John Walkenbach is the author of Excel 2000 Bible (IDG Books, 1999) and maintains The Spreadsheet Page (www.j-walk.com).

Prevent Row or Column Insertion

One way to prevent unauthorized users from inserting a new row or column into a spreadsheet is to protect the worksheet. If you prefer to keep the sheet unprotected, input something into the last cell on the worksheet (cell IV65536). A single space is a good choice, since it's invisible. When the last cell is filled, Excel and 1-2-3 will not allow insertion of a new row or column. Instead, the programs will display a rather cryptic message that the casual user won't understand (but that savvy users will Figure out).

Join the newsletter!

Error: Please check your email address.

More about Microsoft

Show Comments

Market Place