Output: Format as table Freeze header row We have successfully formatted our data as a table with a header row, and Excel automatically adds filter arrows that can be used to sort or filter the values per column.įigure 6. Verify the range B2:F7 for our data set and ensure that the checkbox is ticked for My table has headers. The Format As Table dialog box will appear.
0 Comments
Leave a Reply. |