Freezing rows in excel 2010
Asked By
20 points
N/A
Posted on - 03/08/2012
I'm working with the new excel.
Excel 2010.
I want to freeze some columns and rows.
Any idea?
Freezing rows in excel 2010
Hey Monica!
If you want to freeze your Row and Columns in MS Excel please follow these steps:
1. Open MS Excel.
2. Open your worksheet where you want to Freeze Rows/Columns.
3. Select the Row or Column you want to freeze.
4. Now click on the VIEW tab on the toolbar.
5. Click on the Freeze pane button in Window section.
6. You will have three options there, choose one of them:
Click on Freeze Top Row to freeze one row only.
Click on freeze First column to freeze one column only.
Click on Freeze pane to lock more than one column or row, or two lock them both at the same time.
7. If you want to unfreeze the row or column or both, click on unfreeze.
Thanks
Best Answer
Best Answer
Freezing rows in excel 2010
If we know how to perform an action in working with excel, we used to continue to use that same method again and again. But, there are always some easier way to do a task. But it needs an initial investment of effort and time.
I focuses on simple excel tips and trick way to freeze panes.
Open excel file and go to the sheet you want to make freeze.
Select the cell of which you want to freeze.
Â
In Excel 2003: Select Window > Freeze Panes
In Excel 2007: Select View > Freeze Panes > Freeze Panes
In Excel 2010: Select View > Freeze Panes > Freeze Panes
Hope this helps.
Latest Articles
Top Construction Management Apps
Construction management is essential to ensure project completion in a timely and cost-effective manner. Construction management software support businesses to operate efficiently. The software is available for all types of construction projects, including residential...
Best Mirrorless Cameras
Mirrorless camera is the latest obsession among the photographers. The cameras have altogether replaced the traditional DSLR models with their unique and special features.
A mirrorless camera is a light-weighted electronic device device that utilizes...
Improve Your Manuscript Before Publishing: Eight Ways To Help
Every author expects to experience a sense of achievement unlike any other when they complete their manuscript. However, some authors agree that they do not feel fully satisfied looking back at the achievement that...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
