S
S
Soul12021-09-28 18:50:51
excel
Soul1, 2021-09-28 18:50:51

How to insert data from the proposed list?

The first time I noticed such a chip in Excel and now I want to use it, but I don’t know how.

There is a column, in each cell there is text and at the end after the text there is a number. Like this:
Text - 5
More text - 9
Other text - 3
If you start quickly entering numerical values ​​from the neighboring column in the next empty column, then for 1-2 seconds a list of numbers from this neighboring column appears next to the cursor. Those. Excel recognizes that I am reprinting only the numeric values ​​from the adjacent column. But I can't figure out how to confirm the insertion of the proposed list of numbers. Usually in all applications and search engines this is done through Tab, but here it does not work. Enter doesn't help either. It also disappears instantly, literally after 1 second.

How to confirm the insertion of the suggested list?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Smith, 2021-09-28
@ClearAirTurbulence

Here is the manual page with the video.
https://support.microsoft.com/en-us/office/using-f...
If you stop printing when the list preview appears and press Enter, it should materialize. If it doesn't, there's another button on the ribbon.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question