Working with spreadsheets/Spreadsheet design/Working with columns and rows

Working with Spreadsheets

Basic skills applicable to planning, creating and formatting an Excel spreadsheet.
An OP Online course from the National Certificate in Computing (Level 2) programme.

About this course  |  Getting started  |  Course schedule  |  Assessment overview  |  Help

Changing the size of columns and rows

You may need to change the height of a row or the width of column to make room for the information you enter in the spreadsheet.

Activity

Please note: the following link will open in a new window/tab. When you have finished, simply close the window/tab and you'll return to this page. Work through page 2 of the tutorial on Modifying Columns, Rows and Cells You might also like to check out the relevant parts of the video on this page.

Activity

We are going to adjust the layout of our sheet slightly. Open the bookshop workbook Hover your mouse in the heading row between columns A and B. Your mouse should change to a 2-headed arrow. Left click and without letting go, slide your mouse to the right to widen column A. Make it roughly half as wide again.

Inserting rows and columns

You often need to add an extra row or column as you are building your spreadsheet.

Activity

Please note: the following link will open in a new window/tab. When you have finished, simply close the window/tab and you'll return to this page. Work through page 3 of the tutorial on Modofying Columns, Rows and Cells You might also like to check out the relevant parts of the video on page 2.

Activity

We are going to insert some rows after the the row labeled Income. Please follow the steps as outlined above and insert 3 extra rows. Take your list of income and expendures. Enter them into your spreadsheet. Save your work.

|