I want to copy and paste between sheets and keep the cell format exactly as it is.

Occasional Visitor

I am trying to make an audit tool that has questions for various departments. I need the questions to be on multiple sheets and exactly the same formatting. How do I copy the questions and paste it onto the other sheets but maintain the exact format?

2 Replies


Wouldn't it be easier to copy a "template" sheet instead of copying individual ranges? When you copy a sheet, all formatting remains the same.



Move or copy cells and cell contents

se Cut, Copy, and Paste to move or copy cell contents. Or copy specific contents or attributes from the cells. For example, copy the resulting value of a formula without copying the formula, or copy only the formula.

When you move or copy a cell, Excel moves or copies the cell, including formulas and their resulting values, cell formats, and comments.

You can move cells in Excel by drag and dropping or using the Cut and Paste commands.


I would be happy to know if I could help with this information.



I know I don't know anything (Socrates)