Info

in 1 ► »1 V I'epcrt /

Fixing the outline view requires just a few obscure steps. Here are the steps in the user interface:

1. Select all the cells in Column A that make up the report.

2. Select Edit, GoT to bring up the GoT dialog. Select the Special button to bring up the GoT Special dialog. Select Blanks to select only the blank cells. See Figure 12.18 for this obscure dialog box that is accessed from the Edit, GoTo dialog.

3. Enter an R1C1 style formula to fill the blank with the cell above it. This formula is =R[-1]C. In the user interface you would type the equals sign, the up arrow, and then press Ctrl+Enter.

4. Re-select all the cells in Column A that make up the report. This is necessary because the PasteSpecial step cannot work with non-contiguous selections.

5. Copy the formulas in Column A and convert to values by using the Values option in the PasteSpecial dialog.

0 0

Post a comment