USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Font color
|
|
|
Bold
|
|
|
Font size
|
|
|
Cell content
|
Detailed explanation-1: -Format Painter only copies the formatting and not the value in the cell. You can use format painter in Excel to: Copy formatting from the same worksheet.
Detailed explanation-2: -With format painter, you can copy all of the formatting from one object and apply it to another one-think of it as copying and pasting for formatting. Select the text or graphic that has the formatting that you want to copy. Note: If you want to copy text formatting, select a portion of a paragraph.
Detailed explanation-3: -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.
Detailed explanation-4: -Select the cell with the formatting you want to copy. Select Home > Format Painter.