To copy formatting from one area in a worksheet and apply it to another area you
Home | Discussion ForumTo copy formatting from one area in a worksheet and apply it to another area you would use:
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
Answer : D
Free Online Test
View More Related Question
1) Which of the following options is not located in the Page Setup dialog box?
2) Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
View Answer
3) When you insert an excel file into a word document. The data are
4) The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
View Answer
5) Which function will you use to enter current time in a woksheet cell ?