Discussion Locked

Preserve EXCEL worksheet format

0 helpful

7 replies

by csuu Apr 8, 2003 last reply Jun 10, 2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

7 replies

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

Poster rated this answer

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

Poster rated this answer

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

Poster rated this answer

This question was closed by the author

This discussion is closed to new replies.