If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#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? |
Thread Tools | |
Display Modes | |
|
|