Microsoft Excel 
ITTraining@sgul.ac.uk Page 19 St. George’s Information Services 
CHANGING FONT SIZE 
 
 
 
 
  
 
 
 
 
 
 
 
  
 
 
 
 
 
 
 
   
 
 
 
 
One way that text can be emphasised is by 
changing the size of the font. For example, if 
your normal text is 11 pt, you may like to make 
the headings 13 pt or larger. Font size may also  
be changed for small detailed items, such as 
comments or a caption. Main headings in a 
worksheet usually appear in a slightly larger font 
size compared to the rest of the data. 
 
Try This Yourself: 
Same 
File Continue using the previous 
file with this exercise, or open 
the file E722 Font 
Formatting_2.xlsx... 
 
Click in cell A1 to make the 
cell with the main heading the 
active cell 
 
Click on the drop arrow next to 
the Font Size command 
 in the Font group on 
the Home tab to display a 
gallery of available sizes 
 
Point to various sizes and 
notice how Live Preview 
shows you how the heading 
will look 
 
Click on 16 to change the 
heading to 16 pt 
You can also change the font 
size of parts of a document, 
and you can use the Mini 
toolbar... 
 
Click in cell A2 
 
Click with the right-mouse 
button to display the mini-
toolbar and the shortcut menu 
 
Click on the drop arrow next to 
Font Size
  and 
click on 14 
 
Click in cell A3 to hide the 
toolbar 
 
For Your Reference… 
To change font size: 
1. Select the cell or range that you want to 
change 
2. Click on the drop arrow of Font Size
   
3. Click on the required font size 
Handy to Know… 
 You may have noticed that the text didn’t 
change size when you used the mini toolbar 
until you actually clicked on a different font 
size. This is because Live Preview doesn’t 
work with the mini toolbar. 
1 
2 
8