LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Cheers100
 
Posts: n/a
Default How do I quickly enter the same number into different cells?

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
set tab or enter keys to automatically move to different cells J9Y Excel Discussion (Misc queries) 8 November 8th 06 02:29 AM
Number of cells that have same values Lingyan Hu Excel Discussion (Misc queries) 6 December 8th 05 05:37 PM
Number format exactly the same, displays differently in some cells eider Excel Discussion (Misc queries) 1 July 29th 05 12:26 AM
can I get cells with a minus number to show zero marcus1066 Excel Discussion (Misc queries) 3 May 7th 05 06:09 PM
How to link cells and keep number format altogether Yi Excel Discussion (Misc queries) 0 May 6th 05 02:12 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"