![]() Now you're able to compare data for similar months from several different years. Move your windows so they are side by side.Open a new window for your workbook, and select the 2012-2013 Sales tab.I know I can use a split, but I prefer freeze panes instead. When I select one, it deselects the other. 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. I have Excel 2010 and only get the option to freeze either the top pane or the left pane.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.To enable the Freeze Panes option again, you need to unprotect your Excel workbook: Tap to the Review tab from the Excel. Well, this Windows option seems permanently disabled in Excel 20. Freeze First Column and use the horizontal scroll bar to look at sales from 2015. If the Windows option for the Workbook Protection is enabled then it will make your Excel Freeze Panes not working.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. After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |