Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding multiple pictures at once instead of one at a time | Excel Discussion (Misc queries) | |||
Adding Data to a Non-Contiguous Range in Excel 2007 | Charts and Charting in Excel | |||
Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
Adding up data in multiple cells for a single criteria. | Excel Worksheet Functions | |||
Adding time to multiple cells using TIMECODE | Excel Discussion (Misc queries) |