Answer:
1. Select cell H5.
2. Press Ctrl+C to copy the cell.
3. Select the range H6:H14.
4. Right-click on the selected range and choose "Paste Special" from the context menu.
5. In the "Paste Special" dialog box, select the "Formulas" and "Number Formats" options.
6. Click on the "OK" button to paste the formula and number formatting.
Step-by-step explanation:
To copy the formula in cell H5 to the range H6:H14, paste only the formula and the number formatting to display the remaining amount as a percentage of the actual amount for the other services and the total, you can follow these steps:
1. Select cell H5.
2. Press Ctrl+C to copy the cell.
3. Select the range H6:H14.
4. Right-click on the selected range and choose "Paste Special" from the context menu.
5. In the "Paste Special" dialog box, select the "Formulas" and "Number Formats" options.
6. Click on the "OK" button to paste the formula and number formatting.
This will copy the formula from cell H5 to the range H6:H14, pasting only the formula and the number formatting, allowing the remaining amount to be displayed as a percentage of the actual amount for the other services and the total.