Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.

It is particularly beneficial to use data-entry forms when your data range or table has many columns. A standard data-entry form in Excel looks similar to the screenshot below. (To follow along, ...

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.

Set data validation If you want to insert different task priorities (High, Medium, or Low) and Status (Pending, Ongoing, Skipped, Completed) in your Excel sheet, you need to use Data validation.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

How to add a third column to sort in Excel There are very few repeated dates, but there are a few repeated months. Let’s create a new custom sort on three columns: Date, Personnel and Region.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.