How do I copy and paste exact formatting in excel?



How do I copy and paste exact formatting in excel?..

Answer / Amit Kumar

"To copy and paste exact formatting in Excel, follow these steps:
1. Select the cells that contain the desired formatting.
2. Right-click on the selected cells and choose "Copy" from the context menu.
3. Navigate to the destination cells.
4. Right-click on the destination cells and choose "Paste Options".
5. In the "Paste Options" dialog box, select "Formatting Only" and then click OK."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

I am new at this excel game. How do you figure elapsed time? I have formatted the cells in military time, create a start time column and an end time column andwould like to know the difference?

1 Answers  


How do you combine two formulas in excel?

1 Answers  


What is the #value error in excel?

1 Answers  


How do you autosum horizontally in excel?

1 Answers  


What is the shortcut to fill down in excel?

1 Answers  


How do I match two lists in excel?

1 Answers  


How do I convert numbers to text in excel automatically?

1 Answers  


Can you combine two columns in excel?

1 Answers  


What is the len function in excel?

1 Answers  


How do you combine 2 excel files and remove duplicates?

1 Answers  


What is the shortcut to fill color in excel?

1 Answers  


Why vlookup is not working?

1 Answers  


Categories