ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enter the same value for a group cells. (https://www.excelbanter.com/excel-programming/304584-enter-same-value-group-cells.html)

Raymond[_8_]

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

Thank You.



kkknie[_173_]

Enter the same value for a group cells.
 
Holding down the control key when you press enter should update all o
the selected cells.



--
Message posted from http://www.ExcelForum.com


Frank Kabel

Enter the same value for a group cells.
 
Hi
see your other post
use
CTRL+ENTER

-----Original Message-----
How do I enter the same value for a group of selected

cells at once?

Thank You.


.


Tom Ogilvy

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.





No Name

Enter the same value for a group cells.
 
Range("C4").Select
Selection.Copy
Range("E4:F10").Select
ActiveSheet.Paste
-----Original Message-----
How do I enter the same value for a group of selected

cells at once?

Thank You.


.


No Name

Enter the same value for a group cells.
 
Range("C4").Select
Selection.Copy
Range("E4:F10").Select
ActiveSheet.Paste
-----Original Message-----
How do I enter the same value for a group of selected

cells at once?

Thank You.


.


No Name

Enter the same value for a group cells.
 
Range("C4").Select
Selection.Copy
Range("E4:F10").Select
ActiveSheet.Paste
-----Original Message-----
How do I enter the same value for a group of selected

cells at once?

Thank You.


.



All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com