How to Freeze and Unfreeze Rows and Columns in Excel for iPad
In this tutorial you will learn to select, freeze and unfreeze a single or multiple rows using a specific function in the ribbon.
Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
/ ithowtovids - our feed
/ howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+
Also check an iPhone version:
• How to Freeze and Unfreeze Rows and C...
Step # 1 – Selecting the row / column you would like to freeze.
In this case, we will freeze the first row. To achieve this, the first step is selecting the row below the last row you would like to freeze:
Step # 2 – Go to the “View” menu
You can access directly to the “View” option at the main top toolbar:
Step # 3 – Freeze function
Once inside the “View” menu, click the option “Freeze panes”. You will realize that a thicker line will appear automatically signaling the frozen row:
You will also realize that a “tick” will appear on the right side of the option “Freeze Panes”. To unfreeze the row, all you have to do is press again said option, making disappear the “tick” in the process.
You can also freeze multiple columns and rows. Simply change the selection in the first step to cover a wider number of rows and/or columns, and then just repeat the rest of the steps in the same way. The screen should look like this at the end.
Watch video How to Freeze and Unfreeze Rows and Columns in Excel for iPad online without registration, duration hours minute second in high quality. This video was added by user iPhone, iPad and Android Tutorials from HowTech 20 October 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,501 once and liked it 23 people.