Excel Question

whyulittle · 26-11-2005 08:54PM #1

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 · 26-11-2005 09:00PM

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 · 26-11-2005 09:04PM

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 · 26-11-2005 09:34PM

Great, thanks a lot.

RevBlueJeans · 29-11-2005 05:54PM

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 · 29-11-2005 05:58PM

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 · 29-11-2005 06:54PM

Why not just use paintbrush???

RevBlueJeans · 30-11-2005 08:19PM

Thanks for the tip Heinrich!

Excel Question

Comments