Microsoft Office Tutorials and References
In Depth Information
Using the format painter
8
On the drop-down menu, select the i rst gray font under Theme Colors.
Select the i rst gray font in the
top row under Theme Colors.
Using the format painter
Now, let’s copy the formatting of the Breakfast cell to the Lunch, Dinner, and Snack cells
using the format painter.
1
Click inside the Breakfast cell.
2
In the Clipboard group, double-click Format Painter (
). Excel selects the Breakfast cell
and adds a paintbrush to the cursor.
If you click the Format Painter icon only once, it only applies the formatting change once.
3
Click inside the Lunch, Dinner, and Snack cells. These cells now have the same format as
the Breakfast cell. Click the Format Painter icon to deactivate the tool.
4
Choose File > Save to save your work.
Adding borders and shading
A range in Excel is a block of cells. In the following steps, you will select and merge cells to
make them one unit. Then you will add borders and shading.
1
Click cell H2 and drag to select cells I2 and J2.
2
On the Ribbon, click Home. In the Alignment group, click Merge & Center ( ). The
cells merge into one unit and the text is centered.
3
Repeat the procedure for cells H3, I3, and J3.
Now, you’ll add the borders and shading.
4
Click inside cell H2 and drag to cell H3 to select both cell ranges.
5
Click Home. In the Font group, click the down-arrow to the right of Border ( ).
Search JabSto ::




Custom Search