How do I quickly enter the same number into different cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am entering a "1" 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
 
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 :-)
------------------------------­------------------------------­----------------
 
Back
Top