Use the horizontal scroll bar in the bottom right of the window to move the worksheet so that Column N, which contains data for January 2015, is next to Column F.Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, including the ability to freeze panes and split your worksheet.By freezing rows or columns in place, youll be able to scroll through your content while continuing to view the frozen cells.In our example, we want to freeze rows 1 and 2, so well select row 3.
On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. The rows will be frozen in place, as indicated by the gray line. You can scroll down the worksheet while continuing to view the frozen rows at the top. In our example, we want to freeze column A, so well select column B. ![]() You can scroll across the worksheet while continuing to view the frozen column on the left. To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu. Excel includes additional options to make your workbooks easier to view and compare. For example, you can choose to open a new window for your workbook or split a worksheet into separate panes. ![]() You can now compare different worksheets from the same workbook across windows. In our example, well select the 2013 Sales Detailed View worksheet to compare 2012 and 2013 sales. The Split command allows you to divide the worksheet into multiple panes that scroll separately. Click the View tab on the Ribbon, then select the Split command. ![]() After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section. For this challenge, we want to be able to compare data for different years side by side. Freeze First Column and use the horizontal scroll bar to look at sales from 2015. Select cell G17 and click Split to split the worksheet into multiple panes. Hint: This should split the worksheet between rows 16 and 17 and columns F and G.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |