This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How do I prevent the date from changing when I am dragging the cell down. I want to keep the same date as I enter it in. Ex. I want to keep the dates the same when I am entering multiple entries in a column.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 92%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Alternatively, select all of the cells that you want that date to be in. Type the date and use Ctrl+Enter to enter it. Excel will place the same entry in all of the selected cells, and you don't have to worry about dragging it down.
Rich~M
Does it have
| 3/16/2023 | 180053 |
|---|---|
| 3/16/2023 | 180053 |
| 3/16/2023 | 180053 |
| 3/16/2023 | 180053 |
| 3/17/2023 | 184952 |
| 3/18/2023 | |
| 3/19/2023 | |
| 3/20/2023 | |
| 3/21/2023 | |
Do I have to start at the top of the row, because every time I do it, it changes the day of the date.=?
Copy one row with the same and then you can drag it down, it will keep the data.
Does it have to be in the format that you shared for the date? I tried the process that you shared with me, but it would not do it. I enter in data every day sometimes 3 or 4 times a day, so that is why I thought I shouldn't use the formula. I don't want the entire row to stay the same, just the days that I enter data.
Here is my example:
| 3/13/2023 | 184257 | Wal-Mart #7032 Supercenter |
|---|---|---|
| 3/14/2023 | 185322 | Sheetz #699 |
| 3/14/2023 | 181315 | Walmart #2761 Super Fuel Ctr. |
| 3/15/2023 | 184220 | Wal-Mart #2807 Supercenter |
| 3/15/2023 | 175146 | Kroger 520 (Front Office) |
| 3/16/2023 | 184680 | Chester EZ Mart |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 3/16/2023 | 180053 | 7-Eleven 2581-36771 F |
| 180053 | 7-Eleven 2581-36771 F | |
Put two same date then you can dragging the cell down with same date.
If you want to keep the some reference. You can use $E$1 to keep the same reference.