In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

Step by step guide to group Worksheets in Excel to apply common changes. It is useful when you need to apply the same formula, data or column.

Learn how to easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Column graphs offer a visual representation of data that allows easy comparison between multiple values. Typically, these columns are uniformly spaced, but there are times you will need to group ...

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

How to compare columns in Microsoft Excel As stated, we can use the Excel VLOOKUP function to find and match different data or find differences in two columns.

Excel's Merge option is useful for merging any group of cells, columns or rows that are adjacent to each other. When using Merge, however, all data except that in the upper-left cell will be deleted.

Hiding and then unhiding columns in Excel only takes a few clicks. In this guide, we'll show you how to hide columns and bring them back in no time at all.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

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.