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:
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:
To hide formulas from view, follow these steps:
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:
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.