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.

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.

A drop-down should appear in the first cell of your range. On the Home tab, in the Editing group, select Sort & Filter and then choose Filter (or click Ctrl+Shift+L ): 3. Select the cells, including the blank and non-blank cells that you wish to paste. Freeze First Column and use the horizontal scroll bar to look at sales from 2015. One of the solutions is to use Filter: 1.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. Watch our video tip on this shortcut for a demonstrartion. This means hidden cells in the current selection will not be selected. The keyboard shortcut is the quickest way to select visible cells only, but if you don't use this feature often, you can instead use the Go To Special menu.

To remove the split, click the Split command again. Z This shortcut will select only visible cells in the current selection. Shift+Page down On a MacBook, Shift+Fn+Down arrow key. Shift+Delete (not the forward delete key found on full keyboards) Extend the selection down one screen.

After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section. Shift+ +Asterisk () Select only the active cell when multiple cells are selected.

Excel 2016 select visible cells only