ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007- Adding data in multiple cells at the same time (https://www.excelbanter.com/excel-discussion-misc-queries/228402-excel-2007-adding-data-multiple-cells-same-time.html)

G

Excel 2007- Adding data in multiple cells at the same time
 
Basically I have a spreadsheet with a lot of data. What I want to do is copy
a single title into multiple sheets without having to hold down the mouse to
copy from cell to cell.

Example A1-A2000 I want to put a title in the column next to it...and in
A2001-2780 I want to put another title in the column next to it. I hope this
isn't confusing. Right now I just type the data in one cell and hold down the
mouse key and scroll all the way down until I'm at the end of the row I want
the data to be in. And then I do it for the next set of rows. Is there an
easier way?

Harald Staff[_2_]

Excel 2007- Adding data in multiple cells at the same time
 
Select a ton of cells.
Write something.
Hold Ctrl and hit Enter.

HTH. Best wishes Harald

"G" wrote in message
...
Basically I have a spreadsheet with a lot of data. What I want to do is
copy
a single title into multiple sheets without having to hold down the mouse
to
copy from cell to cell.

Example A1-A2000 I want to put a title in the column next to it...and in
A2001-2780 I want to put another title in the column next to it. I hope
this
isn't confusing. Right now I just type the data in one cell and hold down
the
mouse key and scroll all the way down until I'm at the end of the row I
want
the data to be in. And then I do it for the next set of rows. Is there an
easier way?




All times are GMT +1. The time now is 03:02 AM.

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