General discussion

Locked

Preserve EXCEL worksheet format

By csuu ·
How do I copy a formatted worksheet (including row and column format) to another worksheet?

Using Copy and Paste does not preserve the row and column formatting of height and width.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Preserve EXCEL worksheet format

by Cliffway In reply to Preserve EXCEL worksheet ...

Format the sheet the way you want it and save it as a template. Move it to the directory with all your other templates.

When you go to start a new file, the formatted sheet wil be one of the available options

Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

Poster rated this answer

Collapse -

Preserve EXCEL worksheet format

by DKlippert In reply to Preserve EXCEL worksheet ...

Right click the worksheet tab. Choose Move or Copy.
Put a check mark in the "Create a copy box" and select your location.

Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

Poster rated this answer

Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

Use of Edit/move or copy worksheet will preserve row and column formatting. I found this after posting the question.

Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

Poster rated this answer

Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums