Table names must start with a letter, underscore, or backslash, with the remaining characters being letters, numbers, periods ...

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find ...

How to Sum a Column of Zeros in Excel. You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of ...

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.

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis ...

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.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

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.

How to Add Space Between Columns in Excel. Adding space between Excel columns is usually a simple matter of increasing your column widths. But when the columns contain different types of data ...

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.