Spreadsheets that are dozens of columns wide and hundreds of rows long can be difficult to read. You have to scroll all the way back up to the top to remember what the header said, and then hopefully keep it in mind by the time you get back to the item in question. Thankfully, there’s a way to let the important rows and columns (such as headers) stay in view while you browse your data. I’ll show you how to freeze certain cells in a spreadsheet in this quick tip, so no matter how much data you have, you always know what you’re looking at. See more quick tips here:.

The tutorial demonstrates quick ways to freeze panes in Excel. Digital photo enhancement software. You will learn how to quickly lock header row or/and the first column. You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. Best radeon graphics card for mac 2017. To freeze the top row, open your Excel spreadsheet. Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu.