Microsoft Excel 
ITTraining@sgul.ac.uk Page 37 St. George’s Information Services 
QUICK TABLES 
 
 
 
 
 
 
 
 
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
In computer terminology a table is created when 
data is organised into rows and columns. You’d 
think then that a worksheet would be a table – 
but it is not in the Excel definition. In Excel a table 
does have columns and rows of continuous data. 
But it must also have headings which provide filter 
buttons. Creating a table is not hard, but it is much 
easier using Quick Tables. 
Try This Yourself: 
Open File Before starting this 
exercise you MUST 
open the file E1355 
Quick 
Analysis_5.xlsx… 
 
Click in any cell 
containing data  
 
Hold down  + , 
then press  to select 
all of the non-empty 
cells around the current 
cell 
 
Using the scroll bars, 
scroll to the bottom 
right corner of the 
selection, click on the 
Quick Analysis button, 
then click on the 
TABLES tab 
 
Click on Table to turn 
the selected range into 
a table 
 
Scroll across and on 
the drop arrow for 
Position to see sorting 
and filtering options 
 
Click on Select All to 
remove the tick, then 
click on Effective 
People Leader so it 
appears ticked 
 
Click on [OK] to see 
only those people with 
this position title 
 
3 
For Your Reference… 
To use Quick Tables to create a table: 
1. Select the entire data to be used as a table 
2. Click on the Quick Analysis button 
3. Click on the TABLES table, then click on 
Table 
6 
7 
Handy to Know… 
 A drawback of using Quick Tables is that all 
of the data must be selected first. Using the 
normal operation to create a table (the Table 
command on the INSERT tab of the ribbon) 
only one cell in the table needs to be 
selected.