Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel storing previous cell values in memory
When a value is entered into a cell, you can move to the cell beneath it and
start to type the same value. Excel will recognize the value being similar and populate the new cell with the old value. However, I find there is no consistancy with it. Some values it works with and some it does not. For example, one column has a possibility of two values (ABC and DEF). Previously, Excel was able to remember both so that if you typed either 'A' or 'D' it would grab the repective value and insert it. Recently, however, something happened and it lost the ability to recognize 'DEF', so now inserting it is done manually. How does this memory feature work and how can I manipulate it so that I can always have it remember what I choose |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel storing previous cell values in memory
I would guess there is ambiguity involved. If somewhere above the cell you
are typing in, you typed, for instance DEF and somewhere else DEFGHI, then it won't know which one you want until you type DEFG -- Kevin Vaughn "Brent Bortnick" wrote: When a value is entered into a cell, you can move to the cell beneath it and start to type the same value. Excel will recognize the value being similar and populate the new cell with the old value. However, I find there is no consistancy with it. Some values it works with and some it does not. For example, one column has a possibility of two values (ABC and DEF). Previously, Excel was able to remember both so that if you typed either 'A' or 'D' it would grab the repective value and insert it. Recently, however, something happened and it lost the ability to recognize 'DEF', so now inserting it is done manually. How does this memory feature work and how can I manipulate it so that I can always have it remember what I choose |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel storing previous cell values in memory
It could also be a space after one of your entries DEF<space.
-- Carlos "Kevin Vaughn" wrote in message ... I would guess there is ambiguity involved. If somewhere above the cell you are typing in, you typed, for instance DEF and somewhere else DEFGHI, then it won't know which one you want until you type DEFG -- Kevin Vaughn "Brent Bortnick" wrote: When a value is entered into a cell, you can move to the cell beneath it and start to type the same value. Excel will recognize the value being similar and populate the new cell with the old value. However, I find there is no consistancy with it. Some values it works with and some it does not. For example, one column has a possibility of two values (ABC and DEF). Previously, Excel was able to remember both so that if you typed either 'A' or 'D' it would grab the repective value and insert it. Recently, however, something happened and it lost the ability to recognize 'DEF', so now inserting it is done manually. How does this memory feature work and how can I manipulate it so that I can always have it remember what I choose |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
how do i get excel to automatically compute cell values | Excel Discussion (Misc queries) | |||
How di get excel to automatically change cell values | Excel Discussion (Misc queries) | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) |