Tech

Microsoft Office Suite TechGuides

Use Word 2007's Alignment Tab to align text with margins

With Word 2007's new Alignment Tab feature, you no longer need to adjust tabs when a document's margin changes.

Microsoft Word

---

Use Word 2007's new Alignment Tab feature to align text with margins

With Word 2007's new Alignment Tab feature you no longer need to adjust tabs when a document's margin changes. Alignment Tabs align data relative to the margin, so if you change the margin, Word realigns the text automatically.

For example, to use Alignment Tabs to create a header with a right-aligned page number, follow these steps:

1. Click the Insert tab.
2. Under Header & Footer, click Header.
3. Click Blank.
4. Type Chapter One.
5. In the Position group, click Insert Alignment Tab.
6. Click the Right button and then click OK.
7. Click Page Number in the Header And Footer group.
8. Point to Current Position.
9. Click Plain Number.
10. Double-click outside the header to return to your document.

Now, if you change the margin size, the page number readjusts automatically to right-align with the margin.

By default, you can only access the Alignment Tab dialog box when editing a header or footer. To use this feature in the rest of your document, add the Insert Alignment Tab command to your Quick Access toolbar. Follow these steps:

1. In the Header/Footer Design tab, right-click the Insert Alignment Tab command in the Position Group of the Insert tab..
2. Select Add To Quick Access Toolbar.

Microsoft Excel

---

Evaluate part of an Excel formula

Errors in Excel formulas with multiple functions and operations can be difficult to diagnose. To check these formulas, it's best to check each component separately to find out what is causing the error.

For example, say you've entered the following formula in H10 of your 2007 Summary worksheet: =SUM('1st Qtr Sales'!B15:'1st Qtr Sales'!P15)+SUM('2nd Qtr Sales'!B15:'2nd Qtr Sales'!N15)

You find that the formula is producing invalid results. To find out why, check the first SUM function for errors by following these steps:

1. Click in the cell to display the formula in the Formula Bar.
2. In the formula bar, select SUM('1st Qtr Sales'!B15:'1st Qtr Sales'!P15).
3. Press [F9].
4. After examining the result, press [Esc].

If this function is working correctly, check the second function by again selecting the formula cell and following these steps:

1. In the formula bar, select SUM('2nd Qtr Sales'!B15:'2nd Qtr Sales'!N15).
2. Press [F9].
3. After examining the result, press [Esc].

Microsoft Access

---

Use a query to count specific Access records

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. For example, to create a query to find out how many female technicians your company employs, follow these steps:

1. Open the Employees database.
2. Click Queries Under Objects in the Database window.
3. Click the New button and then click OK.
4. Select the Employees table and the click Add.
5. Click Close.
6. Click in the first empty field cell of the Query Design grid.
7. Type Count(*).
8. Press [Tab].
9. Double-click Expr1 and type Total Number Of Female Technicians.
10. Double-click the Gender field in the Field list.
11. Click to deselect the Gender Field Show check box.
12. Type Female in the Gender Criteria cell.
13. Save and close the query.

Talkback 1 comments

• Library Transforms Visitor Experience, Extends Content Reach With Dynamic Technology
• LOB Application Compatibility: Using Microsoft IT's LOB Application Compatibility Testing Processes
• The Evolutionary Path: Things You Can Do Today to Prepare for Oracle Fusion Applications
• Global Mold Production Yields Competitive Advantage
• Link or Embed a PowerPoint Slide

More »

• Service Delivery Project Manager
• IT and Telecommunications Jobs Australia Service Delivery Manager SDM Itil Project Consultant
• Service Delivery Manager, IT, Financial Reporting (sd4)
• Service Delivery Manager SO Gsdc
• Technical / Service Delivery Analyst Circa $60,000 Package

Search for your ideal tech job:

What's important from our sponsors

Webcast: Maximizing Data Protection with Disk-Based Backup

Please register now to attend the webcast as guest speaker Noemi Greyzdorf of IDC explains why protecting data is critical to your business

Receive a complimentary copy of the IDC Analyst Connection when you sign up

Cutting-edge technology from premium sponsors

HP Simply StorageWorks D2D Backup System

Explore this disk-to-disk backup system that is fully automated and provides reliable data protection for your business.