Keep Word headers and footers from overlapping
Thursday, November 15, 2007 02:08 PM
Mary Ann Richardson shows how you can prevent the header from overlapping the first line of text in your Word document.
Microsoft Word
Keep Word headers and footers from overlapping your document’s text
When you find that your header is almost overlapping the first line of text in your Word document, you do not need to make your header smaller; you need to increase the distance of the header text from the rest of the content on the page. To do so, follow these steps:
- Go to View | Print Layout.
- If the page ruler is not visible, go to View | Ruler.
- Go to View | Header And Footer.
- Move your mouse along the white area of the vertical ruler until it becomes a double-headed arrow and a ToolTip appears that reads Bottom Margin.
- Click and drag the bottom margin until your header text is the desired distance from your document text.
Sometimes a header or footer overlaps the margin so that it prints too close to the top or bottom edge of the paper. When this happens, you need to increase the distance of the header or footer text from the edge of the page. You could use your mouse to adjust the top margin as you did to adjust the bottom margin in steps 4 and 5 above, or you could use the Page Setup dialog box, which lets you adjust the header and footer at the same time. For example, to adjust the header and footer so that both are one inch from the edge of the paper, follow these steps:
- Go to File | Page Setup.
- Click the Layout tab.
- Click the up arrow of the From Edge: Header box until you reach 1″.
- Click the up arrow of the From Edge: Footer box until you reach 1″ and then click OK.
Microsoft Excel
Add autonumbering to your Excel spreadsheet
Unlike Access, Excel does not have an autonumbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own autonumbering to a data list.
For example, say you are creating a list of all of your company's products and their prices. Follow these steps to add your own autonumbering for the list:
- In A1, enter this formula:
=TEXT(Row(A1),"000-000") - Enter the name of the first product in B1.
- Enter the price of the first product in C1.
- Copy cell A1 to A2.
- Enter the name of the second product in B2.
- Enter the price of the second product in C2.
- Select A1:C2.
- Go to Data | List and select Create List. (In Excel 2007, press [Ctrl]T, then click OK.)
Now when you type the name of the next product in B3 and press [Tab], Excel will automatically fill in the next number for you.
Microsoft Access
Have Access automatically print your reports
If you need to print out an Access report by 10:00 every Friday morning, you don’t have to do it manually. Follow these steps to create a macro to print the report and schedule it to automatically run at that time:
- Open the database that contains the report.
- In the Database window, click Macro Under Objects.
- Click the Design button.
- Click in the first cell under Commands and select OpenReport.
- In the Action Arguments, click the Name Of Report box and select the name of the report you want to schedule.
- Save your macro.
- Go to Windows Explorer and open the folder where you want to save the macro shortcut.
- Right-click the Windows taskbar and click Tile Windows Vertically.
- Drag the icon of the macro you created from the Database window to the opened folder on your desktop.
- Close both windows.
- Click the Start button, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks.
- Double-click Add Scheduled Tasks and then click Next.
- Click the Browse button.
- Navigate to the folder containing the shortcut to the macro command and select it.
- Click Open and then click Next.
- Click Daily.
- Click the arrows of the Start Time box until you reach 10:00 AM. Click Next.
- Enter your password in the Password text box.
- Enter your password in the Confirm Password text box and click Next.
- Click Finish.
There are currently no comments for this post.