Excel

[Steve of phpBB]

Is there a way to insert a hard-return within a cell so that the text after that goes onto the next line of the cell (while using Wrap Text)?

Just doing the regular return takes me to a different cell. But I would like multiple entries to be within the same cell, but on different lines.

For now I'm using a workaround where I just insert a bunch of spaces until the text moves where I want it to.

[Ryan]

Alt-Return

[phxgators]

Option +return on a Mac

[Steve of phpBB]

Awesome. Thanks.

[Giff]

So I have a file where duplicate numerical values in a column is causing an issue with a file being accepted into our software. Is there an easy way to renumber sequentially instead of having to manually type them in order?

Right now it is

1
2
3
4
5
1
2
3
4
5

And I need it to be
1
2
3
4
5
6
7
8
9
10

[A_B]

you can create a dummy column and have it number (A1=1), A2=(A1+1) and copy it down. You'd need to paste as values after, or it will screw that formula up, though.

I don't know how much excel you know so I just thought of that as an easy fix. But if I get to help you and belittle you I'll take it.

There's probably a much cooler way to do this, anyway

[mister d]

I'm confused what the point of those numbers would be if you can just change them.

[Giff]

I'm confused what the point of those numbers would be if you can just change them.

They are line item numbers on a law firm invoice for a client. They can be anything numerical, they just can't be the same.

[Giff]

you can create a dummy column and have it number (A1=1), A2=(A1+1) and copy it down. You'd need to paste as values after, or it will screw that formula up, though.

I don't know how much excel you know so I just thought of that as an easy fix. But if I get to help you and belittle you I'll take it.

There's probably a much cooler way to do this, anyway

Thanks. I figured out if I just typed 1, 2, 3 in the first three cells, highlighted them, and then dragged the bottom right of the last cell down, it fixed it.

[Gunpowder]

When I need to do this I usually use the ROW function. ie if it starts in column A row 5 I'd use =ROW(A5)-4 and copy that the whole way down. You could just use =A5+1 in A6 and copy that down but if you delete a row anywhere in there it would screw everything up. I'd have to see the file to see exactly what you were trying to do though.

[Shirley]

you can create a dummy column and have it number (A1=1), A2=(A1+1) and copy it down. You'd need to paste as values after, or it will screw that formula up, though.

I don't know how much excel you know so I just thought of that as an easy fix. But if I get to help you and belittle you I'll take it.

There's probably a much cooler way to do this, anyway

Thanks. I figured out if I just typed 1, 2, 3 in the first three cells, highlighted them, and then dragged the bottom right of the last cell down, it fixed it.

This is what I was going to suggest. Keep it simple. You could also type 1 and then 2, select them and then double-click the little square on the bottom right of your selection. It'll usually fill in the rest automatically.