question archive Select the table , clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending ) and then remove the Total Row
Select the table , clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending ) and then remove the Total Row
Subject:BiologyPrice: Bought3
Select the table , clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending ) and then remove the Total Row . On the Page Layout tab , set Print Titles so that row 14 repeats at the top of each page In the Trees sheet, form at the range A 14 :G 42 as a table with headers and apply Light Green, Table Style Light 19 . If the style isn't available, choose another style . Insert a Total Row , filter by Category for Evergreens and then Sum the Quantity in Stock column Record the result in cell B11 Select the table , clear the filter, Sort the table on the Item # column from Smallest to Largest (Ascending ), and then remove the Total Row . On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page , and then Save your workbook
