Now as you scroll down the data set, the headings in row 1 and the first six rows are always in view. So, we want to freeze the first seven rows in other words.ġ) To do this we select the row immediately below row 7, which is row 8.Ģ) With row 8 selected, go to the View Tab and in the Window Group, click Freeze Panes.ģ) Select Freeze Panes from the options, as shown.Ĥ) The grey line should appear on the bottom border of row 7. To learn more about how to analyse your data in Excel read here.Īs we scroll down the rows we would like to keep headings which are in row 1 and the first six employees with the highest salaries in view, for comparative purposes. There are ninety employees at the company. The Annual Salary column has been sorted from largest to smallest. The data has been sorted by annual salary as shown. So, let’s say we have the following data set – a list of employees of a hypothetical medium-sized game development studio. Looking for something more complex? Read here for a guide to Logical Functions in Excel. Tip: If you want to keep the headings permanently in view as you scroll down, you can also convert your range to a Table. This means that row 1 is frozen in place.Ĥ) So as you scroll down, row 1 which is the top row with the headings, will always be visible. Go to the View Tab (Step 1 in the image) and in the Window Group, click on Freeze Panes (Step 2 in the image).ģ) You will see a thin grey line along the bottom border of the entire row 1.
Since our headings are in the top row, we can do the following.ġ) Scroll back to the top of the data set. The entire data set encompasses range A1:E40.Īs we scroll down, and we don’t see the headings anymore, it’s difficult to see what is being compared. We have the headings in the first row as shown below.
The participants were asked to give each flavour a rating out of ten. Thirty-nine participants were asked to test and evaluate the four new yoghurt flavours. So, let’s say we have the data set shown below.Ī hypothetical yoghurt company wants to introduce four new flavours to the market.
0 kommentar(er)
