In order for you to freeze the first column of a worksheet into a frozen pane:
|
Usually it's easy to unhide rows or columns in an Excel worksheet, but occasionally you can run into problems. In these cases, try one of the following techniques: Show
-- Unfreeze Panes -- Extend Selection Unfreeze PanesIn some cases, the rows or columns aren't really hidden. There are frozen rows or columns, and the "hidden" sections are out of view. This short video shows the problem, and how to fix it. There are written steps below the video. Show Rows Hidden by FreezingTo see if freezing is the problem of hidden rows, follow these steps:
The "hidden" rows or columns might reappear after that, when you scroll to the top or left of the worksheet. Extend SelectionIf unfreezing didn't fix the problem of hidden rows, this extend selection trick might help. This short video shows the "Extend Selection" technique, and the written steps are below the video. Extend Selection StepsWhen the hidden rows are at the very top of the sheet, it's hard to select the hidden rows, in order to unhide them. The Excel Freeze Panes option allows you to lock your columns and/or rows so that when you scroll down or over to view the rest of your sheet, the column and/or row will remain on the screen. Go to the View tab of a worksheet to select Freeze Panes, which locks specific rows and columns in place when you scroll to another area, or Split Panes, which creates separate windows of the same spreadsheet. How to Freeze Top Row?To freeze only the top row, execute the steps mentioned below:
Your top row is now frozen. You can scroll down to the rest of the worksheet. Business Analyst Master's ProgramGain expertise in Business analytics toolsExplore Program How to Unfreeze Panes?To unlock all the rows and columns, follow the steps mentioned below:
How to Freeze First Column?You can freeze only the first column for your worksheet by following these steps:
FREE Course: Introduction to Data AnalyticsMastery to Data Analytics Basics is a Click Away!Start LearningHow to Freeze Rows?Excel provides you with the option to freeze multiple rows at once. To freeze the multiple rows, follow these steps:
As you can see below, it freezes all the rows above row 5. In a similar way, you can freeze multiple columns as well. Magic Freeze ButtonThe magic freeze button is a shortcut to freeze the rows and columns with a single click. To add the magic freeze shortcut to the quick access toolbar, follow these steps:
As you can see, it adds the shortcut to your toolbar. ConclusionIn this article, we have discussed a useful function of freezing the rows and columns in Excel. Boost your analytics career with powerful new Microsoft Excel skills by taking the Business Analytics with Excel course, which includes Power BI training This Business Analytics certification course course will give you the basic concepts of data analysis and statistics to help you make better and more informed business decisions. This training introduces you to the Power BI tool and deep-dive into the statistical concepts that will help you visualize your data into a compelling chart to present your findings using executive-level dashboards. Do you have any questions? Feel free to ask them in this article’s comments section, and our experts will promptly answer them for you! Find our Business Analyst Online Bootcamp in top cities:NameDatePlaceBusiness AnalystClass starts on 7th Jan 2023,Weekend batchYour CityView DetailsBusiness Analyst Course in SingaporeClass starts on 9th Jan 2023, Weekdays batchSingaporeView DetailsBusiness AnalystClass starts on 16th Jan 2023, Weekdays batchYour CityView Details About the AuthorShruti is an engineer and a technophile. She works on several trending technologies. Her hobbies include reading, dancing and learning new languages. Currently, she is learning the Japanese language. What will be frozen if you select Freeze first column in the freeze panes options?To freeze the first column in a sheet, click View tab > Freeze Panes > Freeze First Column. This will make the leftmost column visible at all times while you scroll to the right.
What is the shortcut key for freezing the first column in Excel?The steps to freeze the first column (column A) are listed as follows: In the View tab, click the “freeze panes” drop-down under the “window” section. Select “freeze first column.” Alternatively, press the shortcut keys “Alt+W+F+C” one by one. The first column (column A) is frozen.
When you freeze panes in your worksheet What is frozen?The Excel Freeze Panes option allows you to lock your columns and/or rows so that when you scroll down or over to view the rest of your sheet, the column and/or row will remain on the screen.
|
