How to Randomize the Contents of a Column in Excel. Suppose you have an Excel spreadsheet with a single column A and 52 rows. The value in each row's cell represents a playing card, for example K ...

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

How to Make a Yes or No Column in Excel. You can use drop-down lists to create "Yes or No" boxes in Excel. Excel drop-down lists present the user with a list of finite choices that they can enter ...

A simple trick lets you copy source column's width to a target column in Excel. Refer to the steps in the post to copy column widths in Excel.

When you open an Excel spreadsheet, by default the columns are indexed by letters. However if you'd like to change the format and have the index in numbers, follow the step-by-step guide below.

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.

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.

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.

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.