News

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.
How to Make Columns Wider in Excel. When you add text to a cell in your business spreadsheet, that cell will not widen automatically to accommodate your text unless you change a few settings. This ...
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]).
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.
To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
How to Use Column Headings in Excel. For many small business owners, Microsoft Excel 2010 is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare ...
Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...
The Switch Row or Column feature allows you to swap data over the axis. Learn how to switch Rows and Columns in Microsoft Excel.
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.
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 easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide.