How Do I Get Out Of "DATA" ~ "CREATE LIST"?
 

I was looking at a demo in excel and tried it out for myself. Problem is the
demo didn't tell us what to do when we're finished and want to go back to the
worksheet as was. (Demo: Instant Payroll Totals For Quarterly Reporting).

I clicked on DATA then, CREATE LIST and now have all these drop downs on a
range of columns. I just want to get back to my worksheet. I'm afraid to do
anything drastic.
Gatsby (Not The Great)

How Do I Get Out Of "DATA" ~ "CREATE LIST"?
 

You can probably just hit the [Cancel] button and get out of there.

Or you can probably just close the darned thing and say "NO" when asked if
you wish to save changes. Then reopen it in its initial state.

"Gatsby" wrote:

I was looking at a demo in excel and tried it out for myself. Problem is the
demo didn't tell us what to do when we're finished and want to go back to the
worksheet as was. (Demo: Instant Payroll Totals For Quarterly Reporting).

I clicked on DATA then, CREATE LIST and now have all these drop downs on a
range of columns. I just want to get back to my worksheet. I'm afraid to do
anything drastic.
Gatsby (Not The Great)

How Do I Get Out Of "DATA" ~ "CREATE LIST"?
 

You could try:

Select a cell in that List
Data|List|Convert to Range

You may have to remove the header if excel added one for you.

Gatsby wrote:

I was looking at a demo in excel and tried it out for myself. Problem is the
demo didn't tell us what to do when we're finished and want to go back to the
worksheet as was. (Demo: Instant Payroll Totals For Quarterly Reporting).

I clicked on DATA then, CREATE LIST and now have all these drop downs on a
range of columns. I just want to get back to my worksheet. I'm afraid to do
anything drastic.
Gatsby (Not The Great)

--

Dave Peterson

How Do I Get Out Of "DATA" ~ "CREATE LIST"?
 

ViewToolbarsList

Select "List" dropdown and "Convert to Range"


Gord Dibben MS Excel MVP

On Sun, 28 Jan 2007 07:37:01 -0800, Gatsby
wrote:

I was looking at a demo in excel and tried it out for myself. Problem is the
demo didn't tell us what to do when we're finished and want to go back to the
worksheet as was. (Demo: Instant Payroll Totals For Quarterly Reporting).

I clicked on DATA then, CREATE LIST and now have all these drop downs on a
range of columns. I just want to get back to my worksheet. I'm afraid to do
anything drastic.
Gatsby (Not The Great)

How Do I Get Out Of "DATA" ~ "CREATE LIST"?
 

Thank's Gord. I tried that and it worked. I'll be careful in future to use a
'dummy' sheet when practising what Im trying to learn from Microsoft. Can't
understand why on that demo they didn't finiit off by saying, "to return to
original worksheet, do this." Anyway, thank's again.

Gatsby (Not The Great)



"Gord Dibben" wrote:

ViewToolbarsList

Select "List" dropdown and "Convert to Range"


Gord Dibben MS Excel MVP

On Sun, 28 Jan 2007 07:37:01 -0800, Gatsby
wrote:

I was looking at a demo in excel and tried it out for myself. Problem is the
demo didn't tell us what to do when we're finished and want to go back to the
worksheet as was. (Demo: Instant Payroll Totals For Quarterly Reporting).

I clicked on DATA then, CREATE LIST and now have all these drop downs on a
range of columns. I just want to get back to my worksheet. I'm afraid to do
anything drastic.
Gatsby (Not The Great)

How Do I Get Out Of "DATA" ~ "CREATE LIST"?
 

Thank's for replying.
Gatsby (Not The Great)

"JLatham" wrote:

You can probably just hit the [Cancel] button and get out of there.

Or you can probably just close the darned thing and say "NO" when asked if
you wish to save changes. Then reopen it in its initial state.

"Gatsby" wrote:

I was looking at a demo in excel and tried it out for myself. Problem is the
demo didn't tell us what to do when we're finished and want to go back to the
worksheet as was. (Demo: Instant Payroll Totals For Quarterly Reporting).

I clicked on DATA then, CREATE LIST and now have all these drop downs on a
range of columns. I just want to get back to my worksheet. I'm afraid to do
anything drastic.
Gatsby (Not The Great)

How Do I Get Out Of "DATA" ~ "CREATE LIST"?
 

Thank's for replying, Dave.I'm sorted now.
Gatsby (Not The Great)

"Dave Peterson" wrote:

You could try:

Select a cell in that List
Data|List|Convert to Range

You may have to remove the header if excel added one for you.

Gatsby wrote:

I was looking at a demo in excel and tried it out for myself. Problem is the
demo didn't tell us what to do when we're finished and want to go back to the
worksheet as was. (Demo: Instant Payroll Totals For Quarterly Reporting).

I clicked on DATA then, CREATE LIST and now have all these drop downs on a
range of columns. I just want to get back to my worksheet. I'm afraid to do
anything drastic.
Gatsby (Not The Great)

--

Dave Peterson