Now click on the cell again, and it will highlight the option to select more cells in the same column. Pull the list down corresponding to the entries for which you need the suffix.

Google Sheets users can protect certain cells of a spreadsheet in a very similar way. To do this, here are the steps to follow: Select the cells you want to lock, ensuring each one is highlighted.

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way ...

1. Select the cells you want to add a dropdown menu to. 2. Click Data. 3. Choose Data Validation. 4. When the Data Validation pop up appears, select Allow. 5. Choose List from the menu.