[weld]

This question is probably dead easy. See if you can make me feel inferior by answering it within minutes of my posting it.

I want to create an Excel workbook containing twelve worksheets: one for each month of the year. I want to make some formatting changes to the default worksheet, including adjusting the width of some columns, changing the orientation of the worksheet from portrait to landscape, setting the top two lines to be "freeze panes," and formatting certain cells to contain currency values. I don't want to have to make all these changes individually to each worksheet.

What's the fastest, easiest way to do this? How can I copy formatting from one worksheet to another? Or can I make global formatting changes to an entire workbook rather than to an individual worksheet within that workbook? I've had limited success doing a regular cut-and-paste, but that doesn't copy all the formatting. (For example, I haven't been able to paste the column width changes.)

In case it makes a difference, I'm using Microsoft Office 2004 for Mac on a 12-inch Powerbook running OS X 10.3.9.

Thanks in advance.

[mdawson]

Yes, this is easy, but there is no need to feel inferior for not knowing how to accomplish this task; Excel is professional software with far more features than the average user user will ever fully realize.

First remove all but one worksheet. Format the remaining worksheet as you please. Now copy the formatted worksheet by grabbing the worksheet tab while holding the command key?you will see a little black inverted triangle appear over the tab? and dragging the tab to the left or right. A new worksheet will be created with the same name followed by "(2)". Repeat this process.

[weld]

Many thanks, mdawson. I assume you meant the "Option" key, not the "Command" key--at least, I could only get it to work with "Option," not "Command." In any case, it worked, and that's all that matters to me. Thanks again.

[mdawson]

Yeah, I did. I was at work and could not remember the correct modifier key. Copying worksheets is one of those things that I do running on automatic.