To add the Forms command to your QAT, go to the QAT and click the drop-down arrow to open the customize menu. Select More Commands to open the Excel Options dialog box. In the Choose commands from ...

To filter the data by city, click anywhere inside the table, then click the city field—notice the small arrow on the right. 1. Click the arrow and the Sort-Filter Options dialog box pops up with ...

Click the arrow beside the Search box under Date Filters (on the Sort/Filters submenu) and select YEAR from the small dropdown menu. 2. Uncheck Select All , then recheck 2016 and 2015 and click OK .

Click the Developer menu at the top, select Insert, then choose the Text Box component. Go back to the space and draw the box using your mouse. You will have an empty text box. Right-click the text ...

To import the second text file, you just open the same Excel worksheet and click in the second row below the last row of data; in this case, A4. (The wizard forces you to skip a row each time you ...