General
 

Please help me with a few questions.

How can I enter text in two cells at the same time?

How can I duplicate a spread sheet multiple times below the original while
keeping the formatting and functions in tact?

How do I protect my work sheet format and functions so they cannot be
accidentally changed?

How do I clear contents only without affecting functions or formatting?

Thanks,
Adrian QES

General
 

To answer each of your questions:

1) You can't.

2) Save the spreadsheet with a new name.

3) You can use Excel's built-in security features (Tools--Protection)
however be aware that these security tools are rather easily circumvented.

4) To clear non-formula data ("constants") go to
Edit--Goto--Special--Constants and click OK, then hit delete. Of course try
this on a backup copy of your workbook before you do it for real.

Dave
--
Brevity is the soul of wit.


"Adrian QES" wrote:

Please help me with a few questions.

How can I enter text in two cells at the same time?

How can I duplicate a spread sheet multiple times below the original while
keeping the formatting and functions in tact?

How do I protect my work sheet format and functions so they cannot be
accidentally changed?

How do I clear contents only without affecting functions or formatting?

Thanks,
Adrian QES

General
 

as for entering text in two cells at the same time, enter the address of one
cell in the other, for example if you put =a1 in cell a2, then whatever you
enter in a1 will show up in a2, so you won't have to enter it twice.

"Adrian QES" wrote:

Please help me with a few questions.

How can I enter text in two cells at the same time?

How can I duplicate a spread sheet multiple times below the original while
keeping the formatting and functions in tact?

How do I protect my work sheet format and functions so they cannot be
accidentally changed?

How do I clear contents only without affecting functions or formatting?

Thanks,
Adrian QES

General
 

"Adrian QES" <Adrian wrote in message
...
Please help me with a few questions.

How can I enter text in two cells at the same time?


Select the two cells, type the text, and hit Ctrl-Enter.

General
 

On Fri, 5 Jan 2007 13:07:00 -0800, Adrian QES <Adrian
wrote:

Please help me with a few questions.

Will I get credit with your class instructor?

How can I enter text in two cells at the same time?

You can't without using VBA. Why do you want to do this?

How can I duplicate a spread sheet multiple times below the original while
keeping the formatting and functions in tact?

Is a spreadsheet a "worksheet" in a workbook?

If so, you can't duplicate it "below" the original, but beside the original is
possible by copying the sheet through right-click on sheet tab and "move or
copy". Checkmark "create a copy" and OK. Then select both those sheets and do
it again to get two more copies. Select those four and do it again to get 4
more copies.

How do I protect my work sheet format and functions so they cannot be
accidentally changed?

Visit the help wizard and type in "protect worksheet elements"


How do I clear contents only without affecting functions or formatting?

F5SpecialConstants. Checkmark what you want to select then EditClearClear
Contents.


Thanks,
Adrian QES

Gord Dibben MS Excel MVP

General
 

Too easy<g

I was thinking two different words going into two cells.


Gord


On Fri, 5 Jan 2007 22:06:30 -0000, "Bob Phillips" wrote:



"Adrian QES" <Adrian wrote in message
...
Please help me with a few questions.

How can I enter text in two cells at the same time?


Select the two cells, type the text, and hit Ctrl-Enter.

General
 

I am trying to think like you and Dave do <G


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Too easy<g

I was thinking two different words going into two cells.


Gord


On Fri, 5 Jan 2007 22:06:30 -0000, "Bob Phillips"
wrote:



"Adrian QES" <Adrian wrote in message
...
Please help me with a few questions.

How can I enter text in two cells at the same time?


Select the two cells, type the text, and hit Ctrl-Enter.