Mar 30 2021 05:57 PM
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?
Mar 30 2021 11:53 PM
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.
Mar 31 2021 12:02 AM
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.
Nikolino
I know I don't know anything (Socrates)