Software

General discussion

Gravatar
0 Votes
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.

Thread display: Collapse - | Expand +

All Comments

gravatar
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

gravatar
Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

Poster rated this answer

gravatar
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.

gravatar
Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

Poster rated this answer

gravatar
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.

gravatar
Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

Poster rated this answer

gravatar
Collapse -

Preserve EXCEL worksheet format

by csuu In reply to Preserve EXCEL worksheet ...

This question was closed by the author

Back to Software Forum

Start or search

Related Discussions

Related Forums