LAST TIME MODIFIED TO SHOW ON WORKSHEET

H

Hilary_Arnold

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I want to show automatically the date last modified on a worksheet. I know I can see it as a header on page layout view BUT is it possible to either show header in normal view of insert a function to show date last modified?

Many thanks.
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I want to show automatically the date last modified on a worksheet. I know I
can see it as a header on page layout view BUT is it possible to either show
header in normal view of insert a function to show date last modified?
Click to expand...

One way is to use circular references:

http://mcgimpsey.com/excel/timestamp.html
 
Top