Excel Question

whyulittle

If you make changes to the column widths in an Excel sheet, is there way of adding a new page with those changed column widths? So you don't have to go and re-do each it every time you add a new sheet.

angelofdeath

if you right click on a tab and hit select all tabs, and then change the column widths then the change is applied to all sheets

or instead of selecting them all, just click on one, hold ctrl and click on another

whiskeyman

another way - if your sheet has cell sizes you want to keep, just copy the area (or whole sheet if required).
Open a new sheet and right mouse click and go to "Paste Special".
Here you will be given the chance to paste Formats only.
This also applies to coloured cells.

whyulittle

Great, thanks a lot.

RevBlueJeans

Try this:

In the sheet which is formatted to your satisfaction:

Choose Edit,
Move or Copy Sheet,

On the dialog box tick Create a Copy,
OK

You can then delete any contents you dont require while retaining the formating.

If you want to copy more than one sheet then click on the first sheet and Shift Click on subsequent sheets.

You have the additional ability to copy the sheet to a different workbook.

RevBJ

Heinrich

RevBlueJeans wrote:

Try this:

In the sheet which is formatted to your satisfaction:

Choose Edit,
Move or Copy Sheet,

On the dialog box tick Create a Copy,
OK

You can then delete any contents you dont require while retaining the formating.

If you want to copy more than one sheet then click on the first sheet and Shift Click on subsequent sheets.

You have the additional ability to copy the sheet to a different workbook.

RevBJ

Hold down the ctrl key and drag the sheet to the right will do the same thing

Steffano2002

Why not just use paintbrush???

RevBlueJeans

Thanks for the tip Heinrich!