how to lock a row in google sheets so it doesn t scroll This is a topic that many people are looking for. keralaplanningboard.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, keralaplanningboard.org would like to introduce to you How to freeze panes in Excel lynda.com tutorial – YouTube. Following along are instructions in the video below:
“You have a large worksheet. You ll want to be able to scroll all over over and still see your column and row headers. That s what freezing panes is about let s take a look at this large worksheet scroll down. I ll just roll my mouse wheel down and i can see my data.
But i can t really see any of the headers and what if we scroll to the right maybe let s scroll up first and now we can t see what s happening in the first column and if we scroll to the right and scroll down now we re looking at data and we can t really tell what we re looking at and if you re in a view. Like this you can just press control home and now you can always get back up to cell a1. So we re back in the starting position. Well.
When you have this large worksheet here s where freezing panes comes into play now take a look over here on the right side. Now..
Here s your vertical scroll bar on top of the vertical scroll bar. You see this little bar here put your mouse pointer over it and your mouse pointer becomes a two headed up and down arrow click and drag down so this grey line is resting just underneath row. 4. And let go now what you could do is you could click on the top part and scroll this independently from the bottom pane that s ok.
But that could get a little confusing. When your screen starts. Looking like this so. Here s what we do click the view tab and over here.
Choose freeze panes and from the flyout choose freeze panes. So..
What that does is a kind of locks. That top pane in place. So that you can scroll the bottom and not lose sight of what your column headers are well that s great. But it still doesn t fix the problem of what happens when we scroll to the right let s scroll.
All the way back here we can split the screen not just top and bottom. We can also split it left and right. But before we do that we have to unfreeze the panes so back in the view tab. Let s go to freeze.
Panes and choose unfreeze. Panes and down here..
In the lower right corner. Also kind of below the vertical scroll bar. And on the right side of the horizontal scroll bar is another one of those little bars there put your mouse pointer on it and you get a two headed left and right arrow and click and drag this gray bar. So that it s resting between column.
A and column b. And again back. In the view tab go to freeze. Panes.
And again choose freeze. Panes..
Now you can scroll up and down. And not lose. Sight of your column headers and you also scroll to the right and not lose track of your first column now keep in mind when you freeze the panes. What you print will not be what you see on the screen.
You will print. The regular worksheet like you would see it normally you would not see the panes split like this this is only for your convenience to navigate through the worksheet. So let s say we want to get back to normal. We don t want the panes split anymore back here on the view tab click split and that unsplit because it s highlighted it s no longer highlighted again and now we have the worksheet like it was originally you can see scrolling up down left and right so that s a convenience that you might want to use whenever you have a very large worksheet.
Thank you for watching all the articles on the topic How to freeze panes in Excel lynda.com tutorial – YouTube. All shares of keralaplanningboard.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
This Microsoft Excel tutorial shows how to freeze panes to keep column and row headings visible regardless of scrolling. Watch more at http://www.lynda.com/Excel-2010-tutorials/essential-training/61219-2.html?utm_medium=viralu0026utm_source=youtubeu0026utm_campaign=videoupload-61219-0702
This specific tutorial is just a single movie from chapter seven of the Excel 2010 Essential Training course presented by lynda.com author Bob Flissner. The complete Excel 2010 Essential Training course has a total duration of 6 hours and 21 minutes and covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel
Excel 2010 Essential Training table of contents:
1. Getting Started
2. Worksheet Basics
3. Excel Formula Basics
4. Essential Formatting
5. Advanced Formatting
6. Printing Preparation
7. Large Excel Projects
8. Collaborating with Others
9. Exploring Excel s Database Features
10. Analyzing Data
11. Advanced Analysis with PivotTables
12. Creating and Using Charts
13. Creating and Using Macros
14. Customizing Excel