Which of the following steps is the quickest way to copy formatting - ProProfs
Topics-
Products +
     

Which of the following steps is the quickest way to copy formatting from a selected cell to other cells(on the same worksheet)?

Which of the following steps is the quickest way to copy formatting from a selected cell to other cells(on the same worksheet)?

Change Image    Delete



A. Use Ctrl to select all three cells, then click the paste button on the standard toolbar
B. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
C. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
D. All of above

This question is part of Excel Advanced Questions by Akshay Magre
Asked by Pavan on Feb 08, 2017

+ AnswerRequest Answer
...

3 Answers

l.Steven

L.Steven

Answered on Jan 07, 2018

The quickest way to copy formatting from a selected cell to two other cells on the same worksheet is to click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to. This is a procedure that is done on the Microsoft Excel.

It is a software component that is used to keep a track of data in a majorly rows and columns interface. It is a spreadsheet application that is built by Microsoft, and is commonly used on windows, android, ios, and macos. It is a widely used spreadsheet application, which is extremely common.

 Reply

John Adney

John Adney

Answered on Dec 01, 2017

B. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

 Reply

John Smith

John Smith

Answered on Feb 08, 2017

Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.