In Calc, how can I duplicate the formatting of one sheet into a new sheet? I have searched but I can not find this-- if it is already explained somewhere, I would very much appreciate being told how to find it.
Thank you!
- The template sheet: Select All (Ctrl+A by default)
- Copy (Ctrl+C by default)
- Go to the new sheet and select cell A1.
- Paste Special… (ShiftCtrl+V by default) and choose ONLY Formats there.
Alternative:
Ordinary Paste, then DEL. The DEL only removes contents, not formats.
This way you also can handle sheets created with Ctrl+DragMouse at the Tab.
Glad to find that you not had any problems for 3 years. 
1 Like