Action in spreadsheet I can’t remember how to do
Several years ago I created a workbook under an older version of Excel and can’t remember how to do it. If I click on a specific cell, a down arrow shows just to the right of the highlighted cell. Clicking on the arrow gives me a list of data (a single column) from elsewhere in my workbook. Selecting from that list places the data into the highlighted cell and then that info is used elsewhere within the sheet. Don’t recall what that function is called or how use/create/edit it
Several years ago I created a workbook under an older version of Excel and can’t remember how to do it. If I click on a specific cell, a down arrow shows just to the right of the highlighted cell. Clicking on the arrow gives me a list of data (a single column) from elsewhere in my workbook. Selecting from that list places the data into the highlighted cell and then that info is used elsewhere within the sheet. Don’t recall what that function is called or how use/create/edit it Read More