It’s the magnifying glass icon at the end of the ribbon bar, near the top-right corner of Excel. Press Ctrl + O, select the file, then click Open. menu in Windows, and the Applications folder in macOS. Now you're able to compare data for similar months from several different years. It’s in the All Apps section of the Start. Move your windows so they are side by side. with an easy, reliable cloud platform for video and audio conferencing, chat, and webinars across mobile, desktop, and room systems.Open a new window for your workbook, and select the 2012-2013 Sales tab.Java Utilities : Microsoft Windows 7/8/10, Linux and Mac OS 10.x with JRE (Java. 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. Select the Assessment Year Download either excel or Java utility.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. Extend selection down one screen, shift+pgdn, fn+shift+down. After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section. The 100+ Excel Shortcuts You Need to Know (Windows and Mac).
