Prevent hidden text from printing in Word

While you're in the midst of working on a draft, you may need to print the Word document. However, what if your document contains portions of sensitive data or various notes that haven't been polished into their final version yet?

Microsoft Word
Prevent hidden text from printing in Word

While you're in the midst of working on a draft, you may need to print the Word document. However, what if your document contains portions of sensitive data or various notes that haven't been polished into their final version yet?

Rather than deleting the text you don't want printed, you can simply hide the text. To do so, select the text and press [Ctrl][Shift][H]. This will prevent the selected text from being printed or displayed on the screen.

When the time comes when you need to print the hidden text, follow these steps:

  1. Go to Tools | Options.
  2. Click the Print tab, select the Hidden Text checkbox and click OK.
  3. Print your document in the usual manner.

To unhide the text, make it visible on the screen by clicking the Show/Hide button, selecting the hidden text, and simply pressing [Ctrl][Shift][H] once again.

Microsoft Excel


Use one-way Excel tables to analyze data

Excel's one-way tables feature can help you make everyday decisions. For example, suppose you are given a budget of $100,000 to upgrade the PCs in your department. You know that that will entail a fixed cost of $20,000 over a three-month time period. Each PC will require an additional upgrade cost of $200. You have 50 PCs in the department.

At a unit price of $2,000 each (including hardware and software), how many PCs can you upgrade and still come in under budget? Follow these steps to let Excel figure out the answer to this question:

  1. Enter "Fixed Upgrade Cost" in A1.
  2. Enter 20000 in B1.
  3. Enter "Variable upgrade cost per unit" in A2.
  4. Enter 200 in B2.
  5. Enter "Unit Price" in A3.
  6. Enter 2000 in B3.
  7. Enter "Number of Units" in A4.
  8. Enter 50 in B4.
  9. Enter "Total Upgrade Cost" in A5.
  10. Enter =B1+(B4*B2)+(B4*B3) in B5.
  11. Enter "Total Upgrade Cost" in A9.
  12. Enter =B5 in B9.
  13. Enter 30 in C8, 35 in D8, and 40 in E8.
  14. Select B8:E9.
  15. Go to Data | Table.
  16. Enter B4 in Row Input Cell text box and click OK.

As shown in this example, you cannot upgrade all the PCs and still be under budget. However, you can upgrade at least 35 of them.

Microsoft Access


Add page numbers to an Access report

The report wizard in Microsoft Access automatically adds a page number control to a report. However, if you're creating a report from scratch, you will need to add the necessary control yourself.

Here's how to add the page number control:

  1. In the Design view, select Text Box on the Toolbox.
  2. Click and drag it in the Page Footer section where you want the page number to appear.
  3. Select the Label Control Text and replace it with Page.
  4. Click twice on the Text Control Box and enter the following formula:
=Page
  1. Press Enter.

The Access Page function automatically numbers the pages in your report.