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.

Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel. The Column function returns the column number of a reference, and its formula is Column([reference]).

Microsoft Excel 2013's Home tab includes options in the Cells group to insert a blank sheet column and to delete unwanted sheet columns. The row of alphabetical column headings stay in the same ...

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

Add a balance column so you can transfer financial states to Excel for easy access.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

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.

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.

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.

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