Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

If you have cells where only specific information should be inputted, drop-down lists are a valuable feature to add. You can access an Excel workbook here and an accompanying video at the end of this ...

How to Fill Colors in a List in Excel. With Microsoft Excel, you can simplify data entry by adding a drop-down list to a cell, allowing users to pick an option from the list instead of entering ...

To finish the list, create a rule for each item in Table A. Simply repeat the instructions above, but enter the appropriate cell reference in step 6, and then, choose that color in step 7.

There are many formulas to add a comma after the first word in a cell. In case you have a list arranged across a column, you can replicate the formula across the list using the Fill option. Add a ...

You can add a combo box form control that lets people start typing and have Excel fill in the cell with entries from the list that match what they’re typing, but that’s no longer a standard ...