MS Excel ?

[Stainless]

Not sure I understand what you're asking. But if you have data in A1, you should be able to click the bottom right lower in cell A1, hold it, and drag it across to the right.

How about when entering a date? It wants to progress to next day. Can I change something to copy same date?

[HB Vic]

How about when entering a date? It wants to progress to next day. Can I change something to copy same date?

You should be able to insert the absolute reference sign ($). You may have to enter it more than once depending on what you're doing.

[Stainless]

How about when entering a date? It wants to progress to next day. Can I change something to copy same date?

Ok, for dates if you enter twice and then grab the cross it copies same date.

[HB Vic]

How about when entering a date? It wants to progress to next day. Can I change something to copy same date?

You can also enter the same data in two cells, say A1 & B1, highlight both cells, then drag the lower right across to the left.

[Stainless]

You can also enter the same data in two cells, say A1 & B1, highlight both cells, then drag the lower right across to the left.

Yea, I figured that out in post 7. What is the absolute reference? Sorry I'm self teaching here.

[HB Vic]

Yea, I figured that out in post 7. What is the absolute reference? Sorry I'm self teaching here.

The dollar sign: $. So if you want to fix A1 so it doesn't update, enter: $A$1. If you want to fix only A, enter: $A1 and vice versa

[Stainless]

The dollar sign: $. So if you want to fix A1 so it doesn't update, enter: $A$1. If you want to fix only A, enter: $A1 and vice versa

I'm lost here, but date isn't a big deal. I can do what I what I described in post 1. Maybe I will re-read this tomorrow and get it.