Class 6 Exam  >  Class 6 Notes  >  How to become an Expert of MS Excel  >  Two Ways to Use the Format Painter

Two Ways to Use the Format Painter | How to become an Expert of MS Excel - Class 6 PDF Download

The Format Painter offers a quick way to copy all of the formatting from one cell to another. This can help keep things consistent without spending a lot of time replicating the formatting in each cell.

Two Ways to Use the Format Painter | How to become an Expert of MS Excel - Class 6

There are two ways to use the Format Painter:

  • Single-click the Format Painter to copy the formatting from the selected cell, then click a different cell to paste the formatting. Alternatively, you can click and drag over a range of cells to paste the formatting to multiple cells.
  • Double-click the Format Painter if you want to copy the formatting to several non-adjacent cells. When you use this method, you can paste the formatting to as many cells as you want, and the Format Painter will stay on. When you're done, you'll need to click the Format Painter again to turn it off.
The document Two Ways to Use the Format Painter | How to become an Expert of MS Excel - Class 6 is a part of the Class 6 Course How to become an Expert of MS Excel.
All you need of Class 6 at this link: Class 6
94 videos|62 docs|15 tests

Top Courses for Class 6

94 videos|62 docs|15 tests
Download as PDF
Explore Courses for Class 6 exam

Top Courses for Class 6

Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Related Searches

study material

,

Viva Questions

,

Important questions

,

MCQs

,

mock tests for examination

,

pdf

,

Summary

,

Two Ways to Use the Format Painter | How to become an Expert of MS Excel - Class 6

,

Semester Notes

,

practice quizzes

,

Extra Questions

,

Free

,

Sample Paper

,

shortcuts and tricks

,

Objective type Questions

,

ppt

,

past year papers

,

Two Ways to Use the Format Painter | How to become an Expert of MS Excel - Class 6

,

Two Ways to Use the Format Painter | How to become an Expert of MS Excel - Class 6

,

Previous Year Questions with Solutions

,

Exam

,

video lectures

;