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

Formatting a cell with absolute or relative references only has an effect when you copy the cell's formula. Excel automatically adjusts relative cell references to reflect the copied formula's new ...

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

If you need to format the columns in addition to merging them, then right-click the highlighted cells, select "Format Cells." Under the Alignment tab, you will see a checkbox to Merge cells.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

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.

Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.