Learn how to how to increment numbers when value changes in another column. You can automatically fill increment cells in Excel such that the increment value across each cell remains constant.

How to Automatically Put in the Months of the Year in Columns in Excel. Microsoft Excel's automatic data fill-in feature is a time-saver, filling in cells for you so you don't need to manually ...

Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.

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.

Select a range of cells in the column rather than the column header if you only want to fill a portion of the column with zeros. If your data already contains a column of zeros, skip this step.

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 easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.

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