News

There are numerous ways to change column widths in Excel, but did you know you can force Excel to do this automatically when you add or remove data? In this example, Excel's default column width ...
Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.
The Switch Row or Column feature allows you to swap data over the axis. Learn how to switch Rows and Columns in Microsoft Excel.
How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide. Then, right-click on ...
You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.
If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.
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.
Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.
You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.
Excel Online supports sorting by multiple columns. How to sort by two columns Grouping is a common database task, and sorting by multiple columns is essentially the same thing.