Conteúdo do Curso
Excel Essentials
Excel Essentials
Using the Format Painter
The Format Painter is one of Excel's hidden gems.
It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.
We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.
Key Points
- Select the cell with the desired formatting and click the Format Painter button;
- Double-click the Format Painter button to lock it for multiple cells;
- Press
Esc
to deactivate the Format Painter.
Tarefa
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting.
Tarefa
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting.
Tudo estava claro?
Escolha seu plano
Using the Format Painter
The Format Painter is one of Excel's hidden gems.
It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.
We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.
Key Points
- Select the cell with the desired formatting and click the Format Painter button;
- Double-click the Format Painter button to lock it for multiple cells;
- Press
Esc
to deactivate the Format Painter.
Tarefa
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting.
Tarefa
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting.
Tudo estava claro?
Escolha seu plano
Using the Format Painter
The Format Painter is one of Excel's hidden gems.
It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.
We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.
Key Points
- Select the cell with the desired formatting and click the Format Painter button;
- Double-click the Format Painter button to lock it for multiple cells;
- Press
Esc
to deactivate the Format Painter.
Tarefa
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting.
Tarefa
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting.
Tudo estava claro?
The Format Painter is one of Excel's hidden gems.
It's perfect for maintaining a consistent look throughout your spreadsheet without manually formatting each cell.
We'll show you how to use the Format Painter effectively, making your workflow smoother and your spreadsheets more polished.
Key Points
- Select the cell with the desired formatting and click the Format Painter button;
- Double-click the Format Painter button to lock it for multiple cells;
- Press
Esc
to deactivate the Format Painter.
Tarefa
- Select cell
F11
. Click the Format Painter button and clickH6
to apply the formatting. - Double-click the Format Painter button to apply formatting to multiple cells or ranges.
- Press
Esc
to deactivate the Format Painter. - Click on Section 6 tab and select
D6
. Click the Format Painter button and click on Section 7 worksheet. Select cellsG6
through toG25
to apply formatting.