Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
If you enjoy the massive time savings from these methods, don't stop there—there are many other ways to speed up your Excel workflow, like learning the keyboard shortcuts for executing complex tasks ...
Open an Excel spreadsheet Select the cell or cells Click on the Borders button Select an option from the Border menu Change the color. To begin, open the Excel spreadsheet. The next step is to select ...