Tech Tip of the Week!
Over the past few weeks, several staff members have
requested directions on freezing single and multiple Rows and Columns of data
while working in Agora’s provided Spreadsheet Tools.
1. When working in Microsoft Excel,
do the following:
o
On the View tab, click the
arrow below Freeze Panes and then
one of the following:
- To lock row one only, click Freeze Top Row.
- To lock column one only, click Freeze First Column.
- To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll, click Freeze Panes. Please note, you can lock more than one row and column at the same time by selecting the block below and to the right of the area that you wish to freeze.
- You will notice gray lines appear to show what area will be frozen.
- When working in Google Sheets: do the following:
- In the menu bar, click view, then Freeze and do one of the following:
- To lock column one only, click 1 Column.
- To lock column one and two, click 2 Columns.
- To lock row one only, click 1 row.
- To lock row one and two, click 2 rows.
- To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll, click Freeze Up to Current Row AND then Freeze Up to Current Column.
- As mentioned with the Excel directions above, you can lock more than one row and column at the same time by selecting the block below and to the right of the area you wish to freeze.
- You will notice gray lines appear to show what area will be frozen.
Should you have any questions or need any help doing this, feel free to reach out to Rick Tkach or the Staff Helpdesk.
Incredible post.
ReplyDeleteThanks for sharing.I found a lot of interesting information here. A really good post, very thankful and hopeful that you will write many more posts like this one.
ReplyDeletehttps://vidmate.onl/
messenger
https://showbox.run/
Ahh that is great thank you ! Good for special needs too ! wuxiaworld
ReplyDeleteThis is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work quero ser cambista de apostas esportivas
ReplyDeleteWow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks huawei mate x2
ReplyDeleteHello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. streaming sans inscription
ReplyDeleteThank you a bunch for sharing this with all of us you actually realize what you are talking about! Bookmarked. Please also seek advice from my site =). We could have a hyperlink change contract between us! Run Your Ecommerce Business with Cheap Shared Hosting
ReplyDeleteI really thank you for the valuable info on this great subject and look forward to more great posts. Thanks a lot for enjoying this beauty article with me. I am appreciating it very much! Looking forward to another great article. Good luck to the author! All the best! streamcomplet
ReplyDeleteThanks for every other informative site. The place else may just I get that kind of information written in such an ideal means? I have a venture that I’m just now operating on, and I have been on the look out for such information. online flower delivery in jaipur
ReplyDeleteDo what makes YOU happy. It's game the impossible quiz
ReplyDeleteThank you for some other informative website. The place else may just I get that kind of information written in such a perfect method? I have a venture that I am simply now running on, and I’ve been at the glance out for such info. باك لينك
ReplyDeleteThank you so much for the post you do. I like your post and all you share with us is up to date and quite informative, i would like to bookmark the page so i can come here again to read you, as you have done a wonderful job. sri chakra yantra online
ReplyDeleteI am constantly surprised by the amount of information accessible on this subject. What you presented was well researched and well written to get your stand on this over to all your readers. Thanks a lot my dear. 먹튀검증커뮤니티
ReplyDeleteThanks so much for sharing this awesome info! I am looking forward to see more postsby you! 토토
ReplyDeleteThanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks, I’ll probably keep it short and sweet and link to this instead if thats cool. Thanks. 먹튀검증커뮤니티
ReplyDeleteThere are a lot of blogs over the Internet. But I can surely say that your blog is amazing in all. It has all the qualities that a perfect blog should have. website
ReplyDeleteI really thank you for the valuable info on this great subject and look forward to more great posts. Thanks a lot for enjoying this beauty article with me. I am appreciating it very much! Looking forward to another great article. Good luck to the author! All the best! bring back ex lover
ReplyDeleteThe article looks magnificent, but it would be beneficial if you can share more about the suchlike subjects in the future. Keep posting. https://www.knowpia.com/s/blog_40389d928b370850
ReplyDeleteAwesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome! CAANZ
ReplyDeleteI wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. Cheapest Online Shopping Sites in the USA
ReplyDeleteThe Ramadan Series is based on historical events that took place in the seventh century, when a peace settlement was agreed upon between the Muslims and the Christians in Mecca. During this period the two religions lived together in harmony سيما لايت
ReplyDeleteWow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks Voici le lien
ReplyDeleteI love the way you write and share your niche! Very interesting and different! Keep it coming! thermal oxidizers
ReplyDeleteWonderful blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Appreciate it. situs judi slot online
ReplyDeletePretty good post. I have just stumbled upon your blog and enjoyed reading your blog posts very much. I am looking for new posts to get more precious info. Big thanks for the useful info. https://www.abercrombieand-fitch.com.co/2021/03/seo-tips-to-safely-make-your-old-content-fresh-again.html
ReplyDeleteGreat article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks CPA
ReplyDeleteNice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. Coworking space KL Sentral
ReplyDeleteCool stuff you have got and you keep update all of us. Virtual office Singapore
ReplyDeleteIf more people that write articles really concerned themselves with writing great content like you, more readers would be interested in their writings. Thank you for caring about your content. Serviced office in Hong Kong
ReplyDeleteYour Online Documentary Cima – Fresh Festival Films Every Week
ReplyDeleteNice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. become a merchant service provider
ReplyDeleteThis is my first time visit here. From the tons of comments on your articles,I guess I am not only one having all the enjoyment right here! https://id.pinterest.com/liliesaras/daftar-situs-judi-slot-online-terpercaya/
ReplyDeleteGreat knowledge, do anyone mind merely reference back to it Lifeguard requirements
ReplyDeleteThis is just the information I am finding everywhere. Thanks for your blog, I just subscribe your blog. This is a nice blog.. Juventus New Jersey
ReplyDeleteGreat article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information.. ทดลองเล่นสล็อต
ReplyDeleteI admit, I have not been on this web page in a long time... however it was another joy to see It is such an important topic and ignored by so many, even professionals. I thank you to help making people more aware of possible issues. เล่นUFASLOTเว็บไหนดี
ReplyDeletePositive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. http://cirandas.net/latest-blogs/blog/myths-of-lasik-eye-surgery
ReplyDeleteThanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. link
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteYou know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant! voyance gratuite
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteI got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work. PSG Jersey 2020
ReplyDeleteI appreciated your work very thanks LEATHER SUITCASE
ReplyDeleteOnline casinos are all the rage on the web, more and more lovers of gambling and games of chance are followers and are ... https://megawinscasino.com/
ReplyDeleteI cannot wait to dig deep and kickoff utilizing resources that I received from you. Your exuberance is refreshing. http://www.kittykornercatfurniture.com/how-to-get-subscribers-to-youtube-channels/
ReplyDeleteI’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... Online Series
ReplyDeleteI'm glad I found this web site, I couldn't find any knowledge on this matter prior to.Also operate a site and if you are ever interested in doing some visitor writing for me if possible feel free to let me know, im always look for people to check out my web site. https://telegra.ph/Why-Should-You-Choose-a-Nursing-Career-in-the-UK-04-03
ReplyDeleteThanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. CAANZ
ReplyDeleteI can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. IncredibleMagazine
ReplyDeleteI'm glad I found this web site, I couldn't find any knowledge on this matter prior to.Also operate a site and if you are ever interested in doing some visitor writing for me if possible feel free to let me know, im always look for people to check out my web site. 먹튀검증
ReplyDeleteI would like to say that this blog really convinced me to do it! Thanks, very good post. buy instagram followers and followers
ReplyDeleteHey what a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this. Thank you very much and will look for more postings from you. youtube views purchase india
ReplyDeleteInteresting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks best solid wood flooring
ReplyDeleteI am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post. skeleton body
ReplyDelete