This Business Analytics certification course will give you the basic concepts of data analysis and statistics to help you make better and more informed business decisions. In this article, we have discussed a useful function of freezing the rows and columns in Excel.īoost your analytics career with powerful new Microsoft Excel skills by taking the Business Analytics with Excel course, which includes Power BI training Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program.
This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.
Click the Home tab and then click the Freeze Panes button.3. Select the cell below the rows and to the right of the columns that we want to freeze when scrolling.2. Any time you freeze rows and columns, the border below the last frozen row and to the right of the last frozen column. You'd select cell D5, and then on the View tab, click Freeze Panes. Say you want to freeze the top four rows and leftmost three columns. To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes. The magic freeze button is a shortcut to freeze the rows and columns with a single click. We can freeze the panes in three different ways. To freeze multiple rows (starting with row 1), select the row below the last row you want frozen and click Freeze Panes. In a similar way, you can freeze multiple columns as well.