13: Basic ICT skills: Use a spreadsheet for marks

Video Transcript

• Often the default size of the column is too small for the label or value that needs to be placed in it, as in the example shown in the video. 
  
• To resize the columns, place the mouse directly on the gray division between the column descriptors e.g. between the A and the B column headings.
  
• The mouse cursor changes from a white plus sign to a double-sided black arrow. 
  
• Click the right mouse button and hold it in. 
  
• Then drag the mouse in the direction you wish to move the column border.
  
•  A dashed line appears which helps you gauge how far you want to go. Alternatively and the quicker option would be to double click on the column border and the column will resize to the largest cell item.
• Resize all the columns that are either too big or too small.
• You can also format labels and values the same way you would in MS Word. 
• You can make the contents of the cell bold, italic or underlined by using the B, I and U buttons on the Home ribbon. 
• It is also possible to override the default alignment by using the left, centre and right buttons. 
• To have more formatting control ensure that you have selected the correct cell and right click the mouse. 
• Select ‘Format Cells’ Here you can adjust the Alignment, Font, Border and Fill.