Microsoft Office Tutorials and References
In Depth Information
• Spreadsheets are made up of cells, arranged in rows and columns
to make a grid.
• The cursor is a black box around the cell and can be moved with
the mouse or keyboard.
• You can ﬁ ll in the cells in any order.
• Everything on the same row should be about the same person or
thing (eg information about Karen).
• Everything in the same column should be of the same type (eg
• Information should be broken down into the smallest useful pieces,
with each one going into its own cell.
• The formatting tools are similar to Word and can be used to make
your headers stand out.
• When you’re typing in data, press Tab to move to the next cell
• If you’re entering a number that isn’t a real maths or counting
number, such as a booking reference or phone number, put an
apostrophe before it.
• You can adjust the width of the columns using the mouse, by
entering width values or by using the Autoﬁ t function.
• You can use word wrap to show a cell’s contents on multiple lines
within that cell.
• To edit a cell, double-click it or move the cursor to it and press F2.
• You can copy and paste individual cells or groups of cells to avoid
typing the same things repeatedly.
• Take care when deleting and sorting: if you delete or sort only part
of someone’s details, you could mix up your information.