If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
automatically put date and time on the cells when saving ?
Hi i'm having to update the date and time on the changes on all the cells
when i change them and i do a lot of them all the time, change tracking gives me this info on the left side pointers and wants me to take the new value or some thing but i need the old value too, i just need it to keep adding info with the date and time |
#2
|
|||
|
|||
automatically put date and time on the cells when saving ?
Hi Vivek,
Excel 2007, from the help menu: You can View the history worksheet by going to the Review tab, in the Changes group, click Track Changes, and then click Highlight Changes. Under Highlight which changes, select the When check box and then, in the When list, click All. Clear the Who and Where check boxes. Select the List changes on a new sheet check box. Click OK. Hope this helps. PShepard "Vivek" wrote: Hi i'm having to update the date and time on the changes on all the cells when i change them and i do a lot of them all the time, change tracking gives me this info on the left side pointers and wants me to take the new value or some thing but i need the old value too, i just need it to keep adding info with the date and time |
Thread Tools | |
Display Modes | |
|
|