| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Entering same data into multiple cells
Hello! I am using Excel 2003, and I have a bunch of cells where I would like
the same data entered into them. Instead of going through and pressing 0 then return two hundred times, is there a way I can just highlight all of the cells where I want them to contain a 0, and then do it in one or very few keystrokes? All of the cells are not in the same row or column. Thanks. Gary |
|
#2
|
|||
|
|||
|
Gary
provided the cells are in a contiguous block, select all the cells, type 0 and then press Ctrl-Shift-Enter Regards Trevor "Gary H" wrote in message . .. Hello! I am using Excel 2003, and I have a bunch of cells where I would like the same data entered into them. Instead of going through and pressing 0 then return two hundred times, is there a way I can just highlight all of the cells where I want them to contain a 0, and then do it in one or very few keystrokes? All of the cells are not in the same row or column. Thanks. Gary |
|
#3
|
|||
|
|||
|
Select all the cells where you want to enter the same data, type the data
into one of the cells, AND THEN press Ctrl-Enter to fill them all with the same thing "Gary H" wrote: Hello! I am using Excel 2003, and I have a bunch of cells where I would like the same data entered into them. Instead of going through and pressing 0 then return two hundred times, is there a way I can just highlight all of the cells where I want them to contain a 0, and then do it in one or very few keystrokes? All of the cells are not in the same row or column. Thanks. Gary |
|
#4
|
|||
|
|||
|
Worked perfect. Thank you!
Gary "Duke Carey" wrote in message ... Select all the cells where you want to enter the same data, type the data into one of the cells, AND THEN press Ctrl-Enter to fill them all with the same thing "Gary H" wrote: Hello! I am using Excel 2003, and I have a bunch of cells where I would like the same data entered into them. Instead of going through and pressing 0 then return two hundred times, is there a way I can just highlight all of the cells where I want them to contain a 0, and then do it in one or very few keystrokes? All of the cells are not in the same row or column. Thanks. Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
| How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| How do I pull in multiple data sets at once? | Excel Discussion (Misc queries) | |||
| How do I email selected excel cells to multiple recipients? | Excel Worksheet Functions | |||
Hybrid Mode
