Arrange Header Title For Free

Sort without first row by unselecting the first row The easiest way to sort excluding first row must be unselecting the first row. keys simultaneously to quickly select the data range from the second row to the end. Then you can sort the data excluding first row.

1 Manual Selection.2 Highlight the entire range. Highlight the entire range of cells you want to sort, including the last header row.3 Click Sort Filter.4 Check the box.5 Use Filter to Define Sort Area.6 Highlight the bottom header row.7 Click Sort Filter on the Home tab.8 Click an arrow.More items...

Select the column range you will sort without the first row, and then click the Enterprise > Advanced Sort. In the Advance Sort dialog, check the option of My data has headers, then specify the column you will sort, sort criteria, and sort order, at last click the OK button.

If you are referring to just placing cell borders when you mentioned grid of rows and columns, the header row will not be automatically enabled and Excel will treat your first row as part of the data. Thus, your first row will be included in the sorting and filtering.

Place the cursor at the beginning of the first heading and press Ctrl+Shift+End to select everything through the end of the document. Choose Sort from the Table menu. Word displays the Sort Text dialog box.

1 Manual Selection.2 Highlight the entire range. Highlight the entire range of cells you want to sort, including the last header row.3 Click Sort Filter.4 Check the box.5 Use Filter to Define Sort Area.6 Highlight the bottom header row.7 Click Sort Filter on the Home tab.8 Click an arrow.More items...

To freeze horizontal and vertical headings simultaneously:Select the cell in the upper-left corner of the range you want to remain scrollable.Select View tab, Windows Group, click Freeze Panes from the menu bar.Excel inserts two lines to indicate where the frozen panes begin.