Excel 2007- Adding data in multiple cells at the same time

G

G

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?
 
H

Harald Staff

Select a ton of cells.
Write something.
Hold Ctrl and hit Enter.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
how do i average the totals of multiple cells, that have the same label 5
Jump when copying a list of cells 3
Multiple data entries in one cell for filtering purposes 2
Multiple Cells - Data Validation/Conditional Formatting 1
Replacement for multiple spreadsheets 3
2 DATA VALIDATION AT SAME CELL 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0

Top