DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The Edit>Copy Format and Edit>Paste Format commands form the menu.
|
|
|
The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
|
|
|
There is no way to copy and apply formatting in Excel You have to do it manually
|
|
|
The Format Painter button on the standard toolbar
|
Detailed explanation-1: -Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. 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.
Detailed explanation-2: -Select the control that has the conditional formatting you want to copy. On the Home tab, in the Clipboard group, double-clickFormat Painter. Click the all the controls to which you want to copy the formatting. Click Format Painter again to end the format-painting process.
Detailed explanation-3: -Click in text that has the formatting to replicate, and press CTRL-SHIFT-C. It’ll copy the formatting, but not the text itself. Highlight the target text and press CTRL-SHIFT-V to paste the formatting.