Merge and center the contents of the range A2:J2.
Format the merged range A2:J2 as described below: a. Apply the 40% - Accent 5 cell style. b. Apply bold formatting. c. Change the font size to 14.
Reading books is a great way to learn. Here are some of the books we recommend.
Select A2:J2, go to the Home tab. Click Merge & Center under Alignment group.
Select the merged range, click on Cell Styles under Styles group of the Home tag. Scroll down to Themed Cell Styles and select 40% - Accent 5.
To change it into bold format, click the range and click on the B icon under Font group of the Home tab. Alternatively, you can also click on the merged range and hit "ctrl+b" to change into bold format.
Finallly, to change the font size, click on the input box under the Font group of same Home tab. Type 14 and hit enter.
Video explanation: