Traditional Ways to Adjust Column Widths (Manually) In this example, Excel's default column width isn't wide enough to show all the text in column A.

When you release your mouse button, Excel automatically fills the other cells with a sequential series of numbers. Drag your mouse across the data and number cells to select them.

You can reverse the row or column order of a list in Excel by creating reference list, a Macro, and using INDEX function. We have explained all these methods.

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

Learn how to how to increment numbers when value changes in another column. You can automatically fill increment cells in Excel such that the increment value across each cell remains constant.

How to return a set number of consecutive numbers in Excel By combining ROW () and ROUND () with a couple of input values, you can create a very flexible consecutive numbering function.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

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