Tuesday, February 21, 2012

[discussion_vu] [Tips for Computer] How to use Format Painter in Microsoft Excel?

Tips for Computer - How to use Format Painter in Microsoft Excel?
The "Format Painter" is a tool that copies the format from one cell to one or more other
cells. It can also be used to copy the formats from a range of cells to one or more other
similarly sized ranges of cells. You turn on the format painter by clicking the paint brush
looking icon on the standard toolbar.


To use the format painter, first highlight the cell or range of cells containing the format(s)
you want to copy. Next, click on the Format Painter icon on the standard toolbar menu.
Finally, highlight the cell or range of cells where you want the format(s) copied.

There is more. The format painter can be used to copy the format to multiple cells or
multiple ranges of cells without having to click on the format painter over and over again
each time you want to copy a format to another location.

Here is an example of how to accomplish this. First, highlight the cell or range of cells
you want to copy the format(s) from, just as we did before. Now, double click on the
format painter. You can now apply the format to one cell or range and then another and
then another, all without ever having to click on the format painter again. To stop the
format painter when you have double clicked on it, either press Esc or click on the format
painter again.

--
Posted By Blogger to Tips for Computer at 2/21/2012 03:38:00 AM

--
You received this message because you are subscribed to the Google Groups "Virtual University of Pakistan" group.
To post to this group, send email to discussion_vu@googlegroups.com.
To unsubscribe from this group, send email to discussion_vu+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/discussion_vu?hl=en.

No comments:

Post a Comment

PAID CONTENT