Enter the same value for a group cells.

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

How do I enter the same value for a group of selected cells at once?

Thank You.
 
Select the cells

go to the formula bar and enter the value

do Ctrl+Enter rather than just enter to finish.
 
You must log in or register to reply here.

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

Trying to run excel vba code when cell value changes from empty to entered value. 1
Cell =Now() << Can I get this to auto-update? 2
Re : How to lock a cell once the value is entered 2
resettable, over-ridable, default cell values 0
Use & with two formulas 2
copy value calendar control 1
use month in cell date to sum all relevant cells 2
value not recognized as a formula 1

Back
Top