Now you're able to compare data for similar months from several different years. Move your windows so they are side by side.You scroll the spreadsheet down until you see the top of the rows you want to freeze and make sure you keep it on top in the spreadsheet and choose the row right below the last row you want to freeze and click on freeze panes. Open a new window for your workbook, and select the 2012-2013 Sales tab. I always wanted to freeze only the middle rows excluding the top rows in the spreadsheet.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.Hint: This should split the worksheet between rows 16 and 17 and columns F and G. Select cell G17 and click Split to split the worksheet into multiple panes.Freeze First Column and use the horizontal scroll bar to look at sales from 2015.For this challenge, we want to be able to compare data for different years side by side. Within our example file, there is A LOT of sales data. To remove the split, click the Split command again.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |