Copy the formatting of the merged cell in the range A7:A9, then paste the formatting in the range A10:A18 to create three more merged cells.
New Perspectives Excel 2019 | Module 2 - End of Module Project 1
- Copy the formatting of the merged cell in the range A7:A9, then paste the formatting in the range A10:A18 to create three more merged cells.
- In the range B7:B18, apply the Percentage number format with two decimal places, then copy this format to the range D7:D18.
- In the range C7:C18, apply the Number number format, then increase the decimals to show three decimal places.
- Change the background color of the range A7:D9 to Green, Accent 6, Lighter 80% (10th column, 2nd row of the Theme Colors palette).
- Copy the formatting of the range A7:D9, then paste the formatting in the range A13:D15.
- In the range A6:D18, add a border around all cells using the All Borders option.
rames asked 2 years ago
Esc
key to get rid of dotted border around A7:A9 which came when you copied it.Here is the video explanation: