Excel: The Table is Set  Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Insert->Table Create a Table The Table Wizard will display the Range. In the beginning of this sample, you selected Cell A1 through J18.   Note: the Range includes all of the labels and all of the rows of data. My table has a header row. A header row displays the field names at the top of the spreadsheet: for example last name, city, state, zip.   Memo to Self: $A$1 means Absolute. There is a detailed example of what this means later in this Guide.         You can use the sample spreadsheet  or enter your own names if you wish.