Just click the File > Info, you will get the Last Modified by information at right side under Related People section.

How do I create a custom date and time format in Excel?

Create a custom date format

  1. Select the cells you want to format.
  2. Press CTRL+1.
  3. In the Format Cells box, click the Number tab.
  4. In the Category list, click Date, and then choose a date format you want in Type.
  5. Go back to the Category list, and choose Custom.

How do you see who modified a cell in Excel?

View the history worksheet

  1. Click Review > Track Changes > Highlight Changes.
  2. Under Highlight which changes, select the When check box and then, in the When list, click All.
  3. Clear the Who and Where check boxes.
  4. Select the List changes on a new sheet check box.
  5. Click OK.

How do you change the modified date in Excel?

Once you change the clock, open the file and select the “File” menu. Press the “Option” key and select “Save As…” from the drop-down menu. Use a new file name and save the file. If you only want to change the modified date, set the system time to the appropriate time and use the “Save” option from the File menu.

How do you find the earliest date in Excel?

Supposing you want to find out the earliest date and latest date in the range of A1:D7 see the following screenshot: 1. Min function to find earliest date. In a blank cell, enter the formula =MIN(A1:D7), and press the Enter key. It will return the earliest dates in active cell as soon as possible.

How do I move to the last cell in Excel?

Move the cell in a column. To move to last (or First) cell in a range through shortcut method, we can follow below given steps:-. Place your mouse within the range. Press Ctrl+Down Arrow key to go down to the last cell of selected range. To go up to first cell of selected column, press Ctrl+Up arrow key on your keyboard.

How to insert date in Excel?

1) On a worksheet, select the cell into which you want to insert the current date or time. 2) Do one of the following: – To insert the current date, press Ctrl+; (semi-colon).- To insert the current time, press Ctrl+Shift+; (semi-colon).- To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon). See More…