How to Ungroup Rows and Columns in Excel To ungroup rows and columns in Excel. Highlight the row or column you have grouped. On the Data tab, click Outline on the right corner of the Excel interface.

With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

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 ...

Data Columns Select one of the two adjacent columns that you want to separate with extra spaces. Right-click the column and select "Format Cells." Select the "Alignment" tab.

Now, it’s time to apply the conditional format rule that will highlight all weekend and holiday dates in your date list in column B: Select B4:B49 (you want to select the list of dates you want ...

How to freeze multiple rows and columns in Excel You can freeze multiple rows by selecting a cell below the row you want to be fixed in place. The same applies to multiple columns – select the ...