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.

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.

If you want to freeze a column and a row in Excel, you can do that in a matter of moments by following the steps from this guide.

Apply text and cell styles to your column and row heads to help you quickly recognize your data in its new, transposed layout. Excel will retain all cell formatting changes even after you make the ...

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 ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

You can alphabetize data in an Excel spreadsheet in a few different ways. Shutterstock It’s easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the “Sort” feature.

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.

The normal way of formatting cells in Excel (highlight the area, then Format - Cells at the top of the screen) doesn't work for pivot tables. Or rather, it will work once, but as soon as you Refresh ...

6. Once you have inserted the row or column, you can begin entering data into the new cells. If you want to format the new row or column, select the cells and use the formatting options on the Home ...