Prev: Remove columns containing all zeros
Next: why is the feature "share workbook" unavailable to use
From: Gord Dibben on 1 Jun 2010 19:06
That's fine for creating names

But I can't find a "paste List" anywhere.

Like in 2003 Insert>Name>Paste


Gord

On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
<roger(a)technology4nospamu.co.uk> wrote:

>Hi Max
>
>Formulas tab>Define Name or Formulas tab>Name Manager>New
>or as a shortcut
>Alt+M+M+D

From: Mike Middleton on 1 Jun 2010 20:12
Gord -

In Excel 2007 and 2010, select the top left cell of an empty area, and
choose Formulas > Use in Formula > Paste Names > Paste List.

- Mike
http://www.MikeMiddleton.com


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:df4b065815mrq774nfoolc68squj53kpso(a)4ax.com...
> That's fine for creating names
>
> But I can't find a "paste List" anywhere.
>
> Like in 2003 Insert>Name>Paste
>
>
> Gord
>
> On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
> <roger(a)technology4nospamu.co.uk> wrote:
>
>>Hi Max
>>
>>Formulas tab>Define Name or Formulas tab>Name Manager>New
>>or as a shortcut
>>Alt+M+M+D
>
From: Gord Dibben on 1 Jun 2010 20:25
Thank you Mike.

"Use in Formula" is grayed out on Bar if no names have been defined.

Too faint for these old eyes.

Max...............you see this?


Gord


On Tue, 1 Jun 2010 17:12:24 -0700, "Mike Middleton"
<Mike(a)DecisionToolworks.com> wrote:

>Gord -
>
>In Excel 2007 and 2010, select the top left cell of an empty area, and
>choose Formulas > Use in Formula > Paste Names > Paste List.
>
>- Mike
>http://www.MikeMiddleton.com
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:df4b065815mrq774nfoolc68squj53kpso(a)4ax.com...
>> That's fine for creating names
>>
>> But I can't find a "paste List" anywhere.
>>
>> Like in 2003 Insert>Name>Paste
>>
>>
>> Gord
>>
>> On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
>> <roger(a)technology4nospamu.co.uk> wrote:
>>
>>>Hi Max
>>>
>>>Formulas tab>Define Name or Formulas tab>Name Manager>New
>>>or as a shortcut
>>>Alt+M+M+D
>>

From: Roger Govier on 2 Jun 2010 04:14
Sorry, Gord and Max
Didn't read the bit about Paste List.
Fortunately Mike read the question correctly and gave you the answer.

--
-------
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:df4b065815mrq774nfoolc68squj53kpso(a)4ax.com...
> That's fine for creating names
>
> But I can't find a "paste List" anywhere.
>
> Like in 2003 Insert>Name>Paste
>
>
> Gord
>
> On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
> <roger(a)technology4nospamu.co.uk> wrote:
>
>>Hi Max
>>
>>Formulas tab>Define Name or Formulas tab>Name Manager>New
>>or as a shortcut
>>Alt+M+M+D
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5164 (20100601) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com



From: Max on 2 Jun 2010 08:15
Aha! so that's where its hidden, Gord.
My thanks to Mike as well
--
Max
Singapore
---
"Gord Dibben" wrote:
> Thank you Mike.
>
> "Use in Formula" is grayed out on Bar if no names have been defined.
>
> Too faint for these old eyes.
>
> Max...............you see this?

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Remove columns containing all zeros
Next: why is the feature "share workbook" unavailable to use