At 11:03 05/04/2020 -0400, Kellie English wrote:
I cannot for the life of me figure out how to delete unwanted auto
fill suggestions. If I want to type '60 minute massage', it comes up
even after I type "60", which is great, but now i have all of these
other tabbed
suggestions that I have to tab through before I can get to "60
minute massage" based on other entries I have to make for other 60
minute services. Is there any way I can sort through or even
rearrange the order
of such automated fill ins? Right now, when I type "60" here is the
order of auto fill suggestions:
60 HS
60/EVT
60 minute PKG
60min/AO
(I now have to tab through all of these to finally get to ;)
60 minute massage
Which is the main default of what I usually need. Please help! I
would like to rearrange the 60 minute massage to pop up first every
time, or to just delete ALL auto fills and then start fresh?
I'm having to guess that you are talking about entering data into a
spreadsheet document, not a word processor one. Is that so?
This facility offers possible entries as you type, taken from
existing entries in other rows in the same column. No, I don't see
any way to adjust the order of the suggestions. But yes, there is
certainly a way to suppress this facility: just go to Tools | Cell
Content > | AutoInput and toggle it off there.
If you find yourself - as it seems - often entering similar entries
in a spreadsheet column, you may wish to consider using Data Validity.
o Select a cell range - perhaps all or most of a column - and go to
Data | Validity... .
o On the Criteria tab, for Allow, select List.
o Enter your repertoire of allowable values in the Entries box.
o Select other options as desired.
Now when you move to a cell in the range to enter a value, you will
see a down-arrow to its right. Click that with the mouse and select
the particular entry you need. Note that this technique can avoid
entering slight misspellings or variations that may create errors in
your spreadsheet but can be quite difficult to spot.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
