Freezing 2 Ranges on Worksheet

**billgyrotech** · 12-15-2016, 03:51 PM

Hello all! Not sure if this is possible but I will ask anyway. Can 2 ranges on a worksheet be frozen ?

I would like A1:L6 and K7:L14 to always be in view while scrolling through from A7 to J7 and down.

Thank you for any help or suggestions.

**azumi** · 12-15-2016, 08:06 PM

Not excel maybe, try check your "Scroll Lock" on your keyboard, if it turn on just try to off it, and try see your workbook and test it

**Logit** · 12-15-2016, 08:31 PM

.
.

You can use a dynamic image. Select the cells, copy them as picture (the copy drop-down on the home ribbon) and paste the picture into your sheet. This produces a static screenshot of the selected cells.

The steps are for 2007 and later. For Excel 2003 and earlier use the camera tool instead of "Copy as Picture". The other steps are the same.

(I can't vouch for this next part - haven't done it) As for anchoring the image at the top, select the cell below the picture, move the selection to column A in the same row and then use View > Freeze Panes.