software

I am entering a quot;1quot; into various cells (collating answers from
questionnaires). Is it possible to fill the cell with just a mouse click
rather than having to type in number 1 each time? Many thanks for your help.
Mel

Here's a neat trick:Hi-light all the cells you want to enter.
type 1 and then CNTRL-SHIFT-ENTER

You will fill all the cells at once
--
Gary's Studentquot;Cheers100quot; wrote:

gt; I am entering a quot;1quot; into various cells (collating answers from
gt; questionnaires). Is it possible to fill the cell with just a mouse click
gt; rather than having to type in number 1 each time? Many thanks for your help.
gt; Mel

CTRL ENTER will do it

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
quot;Gary''s Studentquot; gt; wrote in message
...
gt; Here's a neat trick:
gt;
gt;
gt; Hi-light all the cells you want to enter.
gt; type 1 and then CNTRL-SHIFT-ENTER
gt;
gt; You will fill all the cells at once
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Cheers100quot; wrote:
gt;
gt;gt; I am entering a quot;1quot; into various cells (collating answers from
gt;gt; questionnaires). Is it possible to fill the cell with just a mouse click
gt;gt; rather than having to type in number 1 each time? Many thanks for your
gt;gt; help.
gt;gt; Mel