BTerrell Group Blog

More Helpful Excel Tips

Posted by Meredith Gooch on Tue, Aug 23, 2011

Apply the same header and footer to some worksheets in an Excel workbook.

1) Select the worksheets that will have the same header and footer. (If the worksheets are adjacent, select the sheet tab of the first sheet in the range, hold the Shift key, then select the last sheet in the range. If the sheets are not adjacent, select the first sheet, hold the Ctrl key, then select all other sheet tabs you want to include.)
2) Select File, Page Setup, Header and Footer.
3) Apply the header and footer. (To ungroup the sheet, hold the shift key then click on the first sheet tab within the group.)

Display two worksheets in a workbook on the screen at the same time.

1) Open the workbook and activate one of the worksheets you need to display.
2) Select Window then New Window.
3) The workbook will open a second time. In this workbook, activate the second sheet you need to display.
4) Select Window then Arrange Windows.
5) Select the Windows of Active Workbook checkbox then choose the display you want (tiled, vertical).
6) Select ok.

Tags: Excel Tips, display two worksheets in a workbook in Excel, same header and footer in Excel workbook, header and footer in Excel

Helpful Excel Tips

Posted by Meredith Gooch on Tue, Aug 09, 2011

Use the same print settings for a number of worksheets in Excel without having to manually set up each worksheet.

1) Select the worksheet whose print settings you want to copy.
2) Group this worksheet together with the worksheets that need to have time same settings.
3) From the File menu, select Page Setup then select ok.

Create a watermark on an Excel file to mark a document as "confidential" or "draft."

1) Right click on a toolbar and select the WordArt toolbar from the shortcut.
2) On the WordArt toolbar, select the Insert WordArt icon.
3) On the WordArt Gallery, select your format choice, then select ok.
4) In the WordArt Edit Text dialog box, type "confidential" or "draft" depending on your need.
5) Select the font and size, then select ok.
6) Right click the WordArt, select Format WordArt from the shortcut menu, then select the Colors and Lines tab.
7) In Fill, select No fill from the Color dropdown list.
8) In the line section, adjust the color and line format to black, then select ok.
9) Right click the WordArt, select Order from the shortcut menu, then select Send to Back.
10) Adjust the WordArt as necessary to fit your document.

Tags: Excel Tips, watermark Excel, mark file as draft, mark file as confidential, same print settings on worksheets