trace order of data entry
Hi,
Press the Crtl key and select each cell in the order you want to enter the
cell value. You will notice that each time you select a cell a blue hight is
visible.
To verify that the selection is per your order, just press the enter key,
you will notice the cell selection in moving the order of your selection.
Important: Enter all values one time, by pressing the Enter key each time.
Otherwise you will have to select all the cells aging by pressing the Ctrl
key.
Challa Prabhu
"Radha" wrote:
I have 2 columns. in column A I will enter a name. in column b I will enter a
number from 1 to 10. The names are not entered in the order 1 to 10 but
randomly. Example I can enter number 5 then 2 then 9 then 1 and so on. How
can I track the order in whick I names are entered. Can I do this on a
different column rather than tracking changes.
--
Radha
|