Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Microsoft Excel Chapter 2
Chapter 2 – Format Setting Character formatting: By choosing commands from the Home tab, you can specify a font for selected text within a cell or the entire cell, as well as change the paragraph alignment.
Font Format Setting To set font formatting follows the steps below: Step 1 - Do one of the following: • To format all the text within a cell, select the cell. • To format only certain text within a cell, select the text you want to format. Step 2 – On the Home tab, press the of the font box from the Font group, select a font. E.g. Arial Step 3 -Press the of the font size box and choose a size, e.g. 18. Step 4 - Press the of the font colour button and select a colour. E.g. Red. Step 5 -Change the font type of the cells. E.g. bold, italic and underline. See the example (Figure 2.1) in the next page.
Font Format Setting (Cont’d) Step 2 Step 3 Step 5 Step 4 Step 1
To merge cells To merge cells follows the step below: Step 1 – Left click the cells andSelected the cells. Step 2 – Click the Merge Cells icon in the Merge group. (Figure 2.2) See the example (Figure 2.3) in the next page. Figure 2.2 Merge group
To merge cells (Cont’d) Ex: Merge the cells A1, B1, C1 ,D1 and E1. Step 2 Step 1
Fitting Text within a Cell To fully display the text follows the steps below: Step 1 -Move the mouse to the right margin of the column you want to adjust the width. Step 2 - When the cursor changes to , double click the mouse and the width will be automatically changed. Step 1 and Step 2
In-class Exercise 1: Instructions: • Merge and center cells A1 to E1, then input the title ‘Height and Weight of Class HH5’. Set the font style as ‘Arial’, the size is ’16,‘Bold’ the title and change the colour in ‘Purple’ • Input the header Name, Weight and Height in cells A3, B3 and C3 respectively. Set the font style as ‘Arial’, the size is 14, ‘Bold’ the header and change the colour in ‘Blue’. • Input the students’ data as shown in Figure 2.3. Set the font style as ‘Arial’ and the size is 12 • Save the filename as ‘studentname’Ex1.
In-class Exercise 1 Example: Figure 2.3
Adding Cell Borders To add cell borders: Step 1 –Select the cells to which you want to add one or more border lines. Step 2 – On the Home tab, click the Format Cells dialog box launcher in the Font, Alignment, or Number group.. Step 1 Step 2
Entering multiple lines into a Cell To enter multiple lines of text, number, dates or times into a cell follows the steps below: Step 1 –Press to insert a line break between each pair of lines. Alt Enter Step 1
In-class Exercise 2 Example: Instructions: • Merge and center cells A1 to E1, then input the title ‘HKTAWTS Assessment 1 Timetable’. Set the font style as ‘Century’, the size is ’12,‘Bold’ the title and change the colour in ‘Blue’ • Input the header ‘Date /Time’, ‘Tue’, Wed’, ‘Thur’ and ‘Fri’ in cells A3, B3, C3, D3 and E3 respectively. Set the font style as ‘Arial’, the size is 11, ‘Bold’ the header. • Input the data as shown in Figure 2.4. Set the font style as ‘Arial’ and the size is 11 • Save the filename as ‘studentname’Ex2.
In-class Exercise 2 Example: Figure 2.3