View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Enter the same value for a group cells.

Select the cells

go to the formula bar and enter the value

do Ctrl+Enter rather than just enter to finish.

--
Regards,
Tom Ogilvy

"Raymond" wrote in message
...
How do I enter the same value for a group of selected cells at once?

Thank You.