General discussion

Locked

Formatting in Excel

By lgsellers ·
I have several existing worksheets. My supervisor now wants my spreadsheets in a new format using the same data, column/row headings, etc., just different spacing, font size, bold text, etc. Is there an easy way to copy my existing sheets into his format without copying his format, using it as a template, and manually typing in my data?
I tried using Format Painter, but it didn't seem to work. I think maybe because his page settings were different. I'm not sure. Any help would be appreciated.

This conversation is currently closed to new comments.

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

All Comments

Collapse -

Formatting in Excel

by calves In reply to Formatting in Excel

Once you create the template, you can copy the whole document then paste special and select data and formulas only.

Good Luck!

Collapse -

Formatting in Excel

by lgsellers In reply to Formatting in Excel
Collapse -

Formatting in Excel

by Larry H. In reply to Formatting in Excel

Open one of his spreadsheets and select all the cells containing the desired format and COPY them.

Go to your spreadsheet, go to the upper left corner of the spreadsheet and choose EDIT, PASTE SPECIAL. Choose FORMATS on the dialog box, then OK.

Collapse -

Formatting in Excel

by lgsellers In reply to Formatting in Excel
Collapse -

Formatting in Excel

by MikeDale In reply to Formatting in Excel

A couple of suggestions that might help.

(1) You could create a sheet group. To create a sheet group, hold down the CTRL key on the keyboard and then click on the sheet tab with the mouse to add that sheet to the group.

Once you have created the sheet group make your formatting changes on the active sheet. The changes are made to active sheet will be done to all sheets in the sheet group.

(2) If your formatting changes are consistant to all the spreadsheets, you could use the macro recorder to record the formatting changes. Then run the marco on all the spreadsheets and sheets needing to be updated.

Hope this helps

Mike Dale

Collapse -

Formatting in Excel

by lgsellers In reply to Formatting in Excel
Collapse -

Formatting in Excel

by moorec In reply to Formatting in Excel

1. CLEAR YOUR CONTENTS:
Highlight your existing spreadsheet, and clear all the the text that you will not need. Then click EDIT/CLEAR/CONTENTS.

That will leave you with just the formats. Then you can save it as a template later.

2. PASTE SPECIAL:
Go to his spreadsheet, copy the relevant part(s). Then click EDIT/PASTE SPECIAL. Then choose VALUES.

As a result, you will not be copying his formats.

Collapse -

Formatting in Excel

by lgsellers In reply to Formatting in Excel
Collapse -

Formatting in Excel

by guy.vertommen In reply to Formatting in Excel

I think that the easiest way is to create a new xlt template that answers all your layout issues, and then import all of your data into a new xls based on this new template.
Its only a one-time investment now, and later on, you'll be able to make additional xls's based on this template easily.

Collapse -

Formatting in Excel

by lgsellers In reply to Formatting in Excel
Back to Windows Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums