Keep Formats/Formulas on excel sheet

[victoriar]

Hello,
I would like to know how I can keep formats and formulas the same when I copy and paste the excel sheet to another sheet?

Also how can I make settings where others can not edit the first two rows on an excel sheet?


Would really appreciate the help.

 

[6StringJazzer]

When you copy and paste, formats and formulas are kept by default. What are you doing that causes them to be lost?

Select all of the cells where the user is allowed to edit and Home > Format > toggle off Lock Cell. Then Review > Protect sheet.

 

[victoriar]

Like lets say cell A1 says name and A2 I have the format: B, font Cardo, size 11
but when I paste the Bold is gone or sometimes I need to adjust the font

Thank your that info

 

[6StringJazzer]

So you mean keep the same format in the destination. When you paste, select Paste Special, Values

Let me know if you got the second part working.