Excel tip: Enter same info for multiple cells
Are you a slave to spreadsheets? Make your work easier with this easy way to enter the same data into multiple cells, using Microsoft Excel.
Are you a slave to spreadsheets? Make your work easier with this easy way to enter the same data into multiple cells, using Microsoft Excel.
Many people who use spreadsheet software for work (or, er, fun) might need to enter the same information on multiple cells.
But most Excel users will type the data into one cell and then copy and paste it elsewhere in the worksheet. Sound familiar?
There’s a simpler way to do this, actually.
To enter the same data into multiple cells in Excel — even non-adjacent cells — simply hold down the Ctrl key and use the mouse to click on the desired cells on the row or column.
Now type in the data you want in every selected cell, such as "500," but don’t hit the Enter key.
Instead, all you need to do now is click Ctrl + Enter and voila, you’ll see that data appear in every selected cell.
Great useful time saving tip.
Thanx buddy .. made my work sooo much easier ..
Superb tip! Many thanks for that.I’m sure this is buried somewhere in the manual, but I was damned if I could find it. Thank goodness for sites like yours, I say. Share the knowledge : )
Excellent tip! thanks a lot!
Nice and helpful tip that saves a lot of time. Thanks!
Thanks for a useful tip!
Is it possible to…
i) Edit ‘part’ of data in multiple cells too? e.g.
oIMB_DATA_17_p
oIMB_DATA_17_n
oIMB_DATA_16_p
oIMB_DATA_16_n
..
..
..
oIMB_DATA_1_p
oIMB_DATA_1_n
oIMB_DATA_0_p
oIMB_DATA_0_n
Is there a way to edit a pair in above example in one go? Thanks
Perhaps I should have waited a bit.. I found ‘partial’ answer to it..
I can apply the same method to any of the pair and alter the part (e.g. numerals in the example) in the excel section which shows contents of a cell (the part next to the ‘fx’)
However then both pairs become either type _p or _n.
I could not resolve this issue… i.e. leave the unedited part as it is.
If you’re looking to COPY the number value from a cell then paste (instead of typing it all in) you can do the following:
- Ctrl + V the cell you’re looking to copy to put it on the clipboard.
- Highlight the range of cells to which you’re trying to paste.
- Just hit enter.
This will allow you to copy and paste the same number value to every cell without having it iterate in ascending order.