Using Excel, how can I shift all values in a column down 1 row?

I have a spreadsheet filled with timestamped data. However, I've found that the timestamps are paired with the wrong data (for example, the timestamp on row 8 belongs to the data on row 9). Does Excel 2016 (the version I'm using) have some way to shift all the timestamps down one row?

1 Answer

If your time stamps are in A1:A500

1. Select A1:A500

2. Cut

3. Select A2

4. Paste

or

1. Start this formula in B2 =A1

2. Autofill down the column

3. Select and copy the entire column B

4. Pastespecial(Values) in Column A to overwrite.

or

1. Insert a new row (every column shifts down)

2. Select the first cell in the columns you did not want to lower

3. Right click and select "delete"

4. Select "shift rows up" from the window that pops up