To select and delete text, click any of the cells in the chosen column, for instance, column A1. If you select the cell in A1, Press the Ctrl +Shift + Page up key.

How to Delete Highlighted Text in Excel. ... Whether you have a single cell's text highlighted or entire rows and columns, ... which appears in a column down the left side of the spreadsheet, ...

How to edit a drop-down list in Excel based on a cell range 1. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.