Tech

Guides

Business Applications ▪ Database Management ▪ Disaster Recovery ▪ Enterprise Servers & Storage ▪ IT Security ▪ Java ▪ Microsoft Office Suite ▪ Network Admin ▪ Open Source ▪ SMB ▪ SOA ▪ Tech Management ▪ Software/Web Development ▪ Windows Server ▪ Wireless Tech

Microsoft Office Suite TechGuides

Have Word automatically align tables to changes in page layout

By Mary Ann Richardson, Special to ZDNet Asia
Thursday, January 31, 2008 03:18 PM

When you change margins or page orientation, by default, a table will not change its width to match.

Microsoft Word

Have Word automatically align tables to changes in page layout

When you change margins or page orientation, by default, a table will not change its width to match. For example, you create a table whose width extends from the one-inch page margin on the left to the one-inch page margin on the right. If you change the margins to 1/2 inch, the table moves to the left. You may try to reposition it by clicking and dragging the table borders so they extend back to the right margin; you also may need to reformat each of the columns and their contents. Instead, have Word automatically reposition it for you.

Before making any changes to the page margins or orientation, follow these steps:

Select the table and right-click it.
Scroll to Autofit and then select AutoFit to Window.

Word will automatically adjust the table width to any margin or page orientation changes. With Autofit to Window enabled, you can use tables to keep header or footer text properly aligned. Thus, instead of using tab formatting, use a table set to Autofit to Window to automatically center or right-align the contents of a header or footer. For example, you could create a one-row, three-column table in a header. In the second column, you would type the chapter title and then center it in the cell. In the first cell in the third column, you would enter a right-aligned page number field. Unlike tab formatting, the header content in the table would automatically adjust to changes in the page margin or orientation.

Microsoft Excel

Create axis titles for your Excel 2007 charts

Excel 2007 doesn't have a dialog box that allows you to edit chart and axis titles -- you need to insert them. If the text you want for your axis title is already in your worksheet, you can link to the text rather than retype it.

For example, say you have a chart that compares list prices for a number of office properties. Follow these steps to add horizontal and vertical axis titles to the chart by linking to text in the worksheet:

Click on your chart.
Click the Layout tab under Chart Tools.
Click Axis Titles in the Labels group.
Point to Primary Horizontal Axis Title and select Title Below Axis.
Click in the formula bar and enter = (the equals sign).
Click the cell in your worksheet that contains the label Property and then press [Enter].
Click Axis Titles in the Labels group.
Point to Primary Vertical Axis Title and select Vertical Title.
Click in the formula bar and enter = (the equals sign).
Click the cell in your worksheet that contains the label List Price and then press [Enter].

You can now select the axis titles and format them any way you wish.

Microsoft Access

Convert an Access form to a report before printing

You create the necessary tables and forms for your database, but when you print all your form's records, Access prints one page for each record. You can create a report; this will save you paper, but it will also take some time to create. A quicker alternative is to simply convert your form to a report and then print the report. Follow these steps to convert an Access 2003/2002 form to a report for printing:

Open the database containing the form.
Click Forms Under Objects in the Database window.
Right-click the form you want to convert to a report.
Click Save As.
Click in the Save "Form_Name" To text box and enter a name for your report.
Click the drop-down arrow in the As text box and select Report from the list, then click OK.

To print the report, click Reports Under Objects in the Database window and then select the report.

To convert an Access 2007 form to a report, follow these steps:

Open the database containing the form.
Click the name of the form in the Navigation pane.
Click the Microsoft Office button.
Point to Save As and then click Save Object As.
Click in the Save "Form_Name" To text box and enter a name for your report.
Click the drop-down arrow in the As text box and select Report from the list, then click OK.

To print the report, click Reports in the Navigation pane and then select the report.