Improving use of Worksheets

[TKeune]

When developing complex plans, it would be nice to have a "clone" menu
selection for worksheets so that once a worksheet that will be use in the
same form several times does not have to be re-entered each time it is
needed. I use excel to put together quick, informal plans which pretty much
use the same headings and calculations throughout. I might have 5 workbooks
in this plan, each exactly the same except for the variations I make in the
way the tasks are defined. So far, the only way I know is to re-enter the
worksheet 5 times, which is pretty tedious. If there is a better way already
in place, I'm all ears.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

[Dave Peterson]

Create one worksheet that's laid out exactly the way you want.

Then hit and hold the ctrl-key when you click and drag the worksheet to the
right. This makes an exact copy of that first worksheet. Repeat as necessary.

Rightclick on any tab and choose rename to rename it.

If you find that you want to make exact changes to all of the sheets after
you've copied, you can group them first.

Click on the first worksheet tab and ctrl-click on subsequent.
Make your changes.
and rightclick on any of the grouped worksheets and select ungroup sheets.

Almost any change you make to a worksheet that's included in a group, you make
to the others in that group.

So be careful.

TKeune wrote:
>
> When developing complex plans, it would be nice to have a "clone" menu
> selection for worksheets so that once a worksheet that will be use in the
> same form several times does not have to be re-entered each time it is
> needed. I use excel to put together quick, informal plans which pretty much
> use the same headings and calculations throughout. I might have 5 workbooks
> in this plan, each exactly the same except for the variations I make in the
> way the tasks are defined. So far, the only way I know is to re-enter the
> worksheet 5 times, which is pretty tedious. If there is a better way already
> in place, I'm all ears.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

--

Dave Peterson

[Arvi Laanemets]

Hi

Another way: right-click on sheet's tab, and select 'Move or copy ...' from
drop-down. Now you can estimate, is the sheet moved or copied (check/uncheck
'Create a copy'), is the sheet moved/copied to new position in same
workbook, or to another currently opened workbook, and the position in
target workbook where the copy is created.


Arvi Laanemets


"TKeune" <TKeune@discussions.microsoft.com> wrote in message
news:9C219C34-ADDC-48B8-AFBC-700095B16F51@microsoft.com...
> When developing complex plans, it would be nice to have a "clone" menu
> selection for worksheets so that once a worksheet that will be use in the
> same form several times does not have to be re-entered each time it is
> needed. I use excel to put together quick, informal plans which pretty
much
> use the same headings and calculations throughout. I might have 5
workbooks
> in this plan, each exactly the same except for the variations I make in
the
> way the tasks are defined. So far, the only way I know is to re-enter the
> worksheet 5 times, which is pretty tedious. If there is a better way
already
> in place, I'm all ears.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
>
http://www.microsoft.com/office/comm...id=9c219c34-ad
dc-48b8-afbc-700095b16f51&dg=microsoft.public.excel.worksheet.functions