Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up too much room on your worksheet.
When you input data into Excel it is initially a 'data array' and although it is perfectly fine to leave data in this format it is sometimes easier or better to convert it to Table for the following reasons;
Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data.
In the view tab of the ribbon you will find the "freeze panes" drop down menu:
Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in a specific way.
There are several ways to re-size a column or row, each has a specific use and will benefit you in different ways depending on what you wish to accomplish.
In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more efficiently. Especially when you have large amounts of data.
I shall outline the selection methods you can use here:
The FILTER function allows you to filter a range of data based on criteria you define.
=FILTER(array,include,[if_empty])
The SORT function sorts the contents of a range or array.
Below are a list of Excel guides currently available, these are a work in progress and will be added to as time goes on. If however you have a need for a tutorial that doesn't exist yet then please email ITSkills@chi.ac.uk to request it.
The SORT function sorts the contents of a range or array.
