In Excel, how do i write continously without clicking on next row

Question

In Excel, how do i write continously without clicking on next row

Anonymous

how do i write continously without clicking on next row. i mean the matter which i write has to go to next row after filling the current cell and so on upto several rows down the line... also how to auto write or write continously from one work sheet to the other work sheet. for example

if my work sheet 1. (C1,D1,E1 & F1) merged together, similarly (C2,D2,E2 & F2 merged) similarly upto 15 rows i.e. C15,D15,E15 & F15 merged) therefore it appears as notes.

Now if i start writing from first merged cell i need my extra text after 1 row to auto align to next row.

similarly for all the 15 rows.

Also into worksheet 2. which has the same format of merging columns. how do i write from one worksheet to other worksheet without clicking on worksheet 2.

can any one help me since it takes lot of time in data entry.

rav

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Re: "how do i write continously without clicking on next row"

I'm not sure what you mean, but there is no need to click. Once you complete your entry in a cell just press the return key to move selection to the cell below it.

If you're trying to put more than one line of content in a single cell see this:

How to fit already constructed text into a smaller box/cell (and how to create a merged, smaller cell to start with)

In addition to Bob G's reply, content in an Excel workbook doesn't flow from one sheet to another... Each sheet is independent of the others unless you create formula links that refer to locations on other sheets.

I can't help but wonder if a different program might be better suited for what you seem to be trying to do.

Answer 2

The simple answer is that you can't! Excel can't possibly predict what you want where, you have to format it yourself. Secondly, it is really bad practice to use merged cells. Their use will almost always cause you lots of trouble oin the future when changing the worksheet. Your time will be much better spent designing a new layout for your work that does not use merged cells.

Share via

In Excel, how do i write continously without clicking on next row

0 additional answers