Tech Tip: Word Click And Type/Hide Excel formula cells/Resize Access form controls

Word: Type anywhere on a page with Click And Type

Word's Click And Type feature allows you to begin typing anywhere on a blank page. You must first enable this feature before you can use it.

Follow these steps:

  1. Go to Tools | Options.
  2. On the Edit tab, select the Enable Click And Type check box in the Click And Type section, and click OK.

To use this feature, switch to Print Layout view, and double-click anywhere on the blank page. For example, suppose you want to type a title in the middle of the first page. In Print Layout view, double-click the middle of the page where you want the title to appear, and type the title. Word automatically center-aligns the title.

You can also use the Click And Type feature to insert nontext items. For example, to place a clip art picture in the bottom right corner of your page, go to the Print Layout view, double-click where you want the picture to appear, and insert the picture. Word automatically right-aligns the picture at the bottom of the page.

Excel: Hide formula cells from users

Excel's Protect Sheet capability can prevent users from changing cells, and it can hide formulas from view. For example, say you want to give users the ability to enter data in a worksheet for analysis, but you want to keep the proprietary formulas used in the analysis from being visible.

By default, the Protect Sheet feature locks all cells from data entry. To unlock cells for data input, follow these steps:

  1. Select the cells for data input, and click Format | Cells.
  2. On the Protection tab, deselect the Locked check box, and click OK.

To hide formulas from view, follow these steps:

  1. Select the formula cells you want to hide, and go to Format | Cells.
  2. On the Protection tab, select the Hidden check box, and click OK.
  3. Go to Tools | Protection | Protect Sheet, and click OK. You can also set a password to prevent others from unprotecting the sheet.

Access: Quickly resize form controls

The Size command in Access lets you quickly resize your form controls to a uniform height and width. For example, say you have four form controls that are about one inch wide and .5 inch high, and you want to enlarge them to 1.5 inch wide and .75 inch high.

You can manually resize one control, and let the Size command do the rest. Follow these steps:

  1. Manually resize one of the controls to the desired width and height.
  2. While pressing [Shift], select all controls.
  3. Right-click the selection, and choose Size | To Tallest.
  4. With the controls still selected, right-click them, and select Size | To Widest.

All the controls now assume the size of the larger resized control. Likewise, if you wanted all controls to measure .5 inch wide and .25 inch high, first resize one control to the smaller size, and choose To Shortest in Step 3 and To Narrowest in Step 4.

Editor's Picks

Free Newsletters, In your Inbox