google sheets floating row This is a topic that many people are looking for. thetruthaboutdow.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, thetruthaboutdow.org would like to introduce to you Freezing Rows and Columns in a Google Spreadsheet . Following along are instructions in the video below:
“Now i have a new spreadsheet open. I want to show you one other way way of viewing your spreadsheet. If you look at my spreadsheet here. You can see i have a column here with a name and then all of the names of the salespeople our banana lover members in this spreadsheet and across the top row here.
I have the months of the year now you can see on my screen at this resolution. I can only see up to the month of july. So if i want to see august september october and the rest of the months of the year. I have to actually use my scroll bar and scroll over to the right well in doing that i can no longer see my name column.
So i have no idea who has made these sales in these later months. Now of course..
I can scroll all the way back over and then try to remember what row. I m on to see who the cell was but there s actually a better way to view this information by keeping that column available and being able to scroll over at the same time and that s by freezing rows or columns. So let s go back to the start of the spreadsheet here and first i want to freeze this column. I want this column to be always showing when i scroll through my spreadsheet so just click in the column somewhere.
I m already clicked in this first cell here and then you want to go to the tools menu. And you have two options here you have freeze rows and freeze columns. I m going to go ahead and freeze. My first column here so go over to the right click freeze.
One column because it s the very first column and you can see there s now a little bar in between this column in the next column. So what does that do for me..
If i scroll over in my spreadsheet now. We will see that no matter how far i go the name column is now always showing. I can easily see even in a late month. Like november.
Who has made the sales so this is very convenient. When you have a lot of data in your spreadsheet. And your column span further than your monitor can display at one time now not only do i have a lot of columns here. I also have some more rows than what we can see right now so we scroll down a little bit you can see you have a few more rows down here well scrolling down to see those last few rows.
I can no longer see the top headers the months of the year and i can t determine which month these cells were made in again you can use the freeze rows or freeze. Columns option here..
So. Let s go back up to the top of the spreadsheet and go to tools and this time go to freeze rolls now i want to freeze the row that has the actual months in the roll. And if you look here you can see that that is actually the second row. So not only do i have to freeze one row.
But i have to freeze two rows. So let s go ahead and select that now i have a bar up under those months and now if i scroll down. I can still see the months of the year. So this freezing rows and freezing columns option really allows you to keep your headers visible.
So that you can work more effectively in your spreadsheet. Now you may have noticed that when i did the freeze roll..
I lost the formatting in my month row. This is a known issue in google docs it s not yet been addressed. But it is a known issue. All you have to do then is reformat your roll paste new formats across the row.
We have already talked about how to do this kind of formatting in a previous video. So if you need a reminder you can go back to that video to learn how to format this ” ..
Thank you for watching all the articles on the topic Freezing Rows and Columns in a Google Spreadsheet . All shares of thetruthaboutdow.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 video explains how to freeze rows and columns while using a Google Doc spreadsheet. Get our entire Google Docs 6 hour course at www.SimonSezIT.com. Learn Google Documents, Spreadsheets and Presentations at http://www.simonsezit.com/courses/google_docs.html”,
Google Docs, Google Spreadsheets, Spreadsheets, Google Apps, Google Tips, Excel, Google Software, Business Apps