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 typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.

Move your cursor to the blank column (L) at the far-right side of your table. Type the name of the new column in row 3 and notice that Excel adds the filtering and style format automatically. 11.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

The example tells Excel to look in column "B" for each row and determine if the values are less than zero. If a value is less than zero, the conditional formatting is applied to that row.

Understanding Excel Column Headers Excel refers to rows by number and columns by letter, starting the first row at one and the first column with "A".

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.

The header for both the row and column on the spreadsheet will hide, showing cells instead. The other option to hide the row and column headers in Excel is to click the File tab. On the backstage ...

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.