![]() The Table button previews how the selected data would appear formatted as a table. Click the Tables tab at the top of the Quick Analysis options palette.Įxcel selects the Tables tab and displays its Table and PivotTable option buttons. Click the Quick Analysis tool that appears right below the lower-right corner of the current cell selection.ĭoing this opens the palette of Quick Analysis options with the initial Formatting tab selected and its various conditional formatting options displayed. If you’ve assigned a range name to the data list, you can select the column headings and all the data records in one operation simply by choosing the data list’s name from the Name box drop-down menu. Select all the data (including the column headings) in your data list as a cell range in the worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |