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

C

Cheers100

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
 
G

Gary''s Student

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
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Page numbering with Merged Document and IF statements 1
How do I add a formula to a range of cells 0
ASK Field Formatting 1
New computer, how do i move outlook 365 ENTIRELY? 0
Need formula to automatically populate Sheet 2 cells with same content as Sheet 1 1
How do I combine records from different sources 0
How do I make the smallest number in a column red ( No VBA Please ) 13

Top