| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#3
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match a group of cells with another group of cells | Excel Worksheet Functions | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| Group Cell??? so could enter just once... | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
![Raymond[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
