Tuesday, January 19, 2016

Tech Tip of the Week - January 19


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.
  1. 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

85 comments:

  1. Thanks 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.
    https://vidmate.onl/
    messenger
    https://showbox.run/

    ReplyDelete
  2. Ahh that is great thank you ! Good for special needs too ! wuxiaworld

    ReplyDelete
  3. This 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

    ReplyDelete
  4. Wow, 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

    ReplyDelete
  5. Hello 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

    ReplyDelete
  6. Thank 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

    ReplyDelete
  7. I 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

    ReplyDelete
  8. Thanks 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

    ReplyDelete
  9. Thank 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. باك لينك

    ReplyDelete
  10. Thank 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

    ReplyDelete
  11. I 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. 먹튀검증커뮤니티

    ReplyDelete
  12. Thanks so much for sharing this awesome info! I am looking forward to see more postsby you! 토토

    ReplyDelete
  13. Thanks 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. 먹튀검증커뮤니티

    ReplyDelete
  14. There 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

    ReplyDelete
  15. I 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

    ReplyDelete
  16. The 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

    ReplyDelete
  17. Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome! CAANZ

    ReplyDelete
  18. I 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

    ReplyDelete
  19. The 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 سيما لايت

    ReplyDelete
  20. Wow, 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

    ReplyDelete
  21. I love the way you write and share your niche! Very interesting and different! Keep it coming! thermal oxidizers

    ReplyDelete
  22. Wonderful 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

    ReplyDelete
  23. Pretty 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

    ReplyDelete
  24. Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks CPA

    ReplyDelete
  25. Nice 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

    ReplyDelete
  26. Cool stuff you have got and you keep update all of us. Virtual office Singapore

    ReplyDelete
  27. If 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

    ReplyDelete
  28. Your Online Documentary Cima – Fresh Festival Films Every Week

    ReplyDelete
  29. Nice 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

    ReplyDelete
  30. This 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/

    ReplyDelete
  31. Great knowledge, do anyone mind merely reference back to it Lifeguard requirements

    ReplyDelete
  32. This 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

    ReplyDelete
  33. Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information.. ทดลองเล่นสล็อต

    ReplyDelete
  34. I 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เว็บไหนดี

    ReplyDelete
  35. Positive 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

    ReplyDelete
  36. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. link

    ReplyDelete
  37. This comment has been removed by the author.

    ReplyDelete
  38. You 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

    ReplyDelete
  39. This comment has been removed by the author.

    ReplyDelete
  40. I 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

    ReplyDelete
  41. Online 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/


    ReplyDelete
  42. I 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/

    ReplyDelete
  43. I’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

    ReplyDelete
  44. I'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

    ReplyDelete
  45. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. CAANZ

    ReplyDelete
  46. I 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

    ReplyDelete
  47. I'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. 먹튀검증

    ReplyDelete
  48. I would like to say that this blog really convinced me to do it! Thanks, very good post. buy instagram followers and followers

    ReplyDelete
  49. Hey 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

    ReplyDelete
  50. Interesting 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

    ReplyDelete
  51. I 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
  52. I am unable to read articles online very often, but I’m glad I did today. This is very well written and your points are well-expressed. Please, don’t ever stop writing. https://nitehawkvision.com/c/spotting-scopes

    ReplyDelete
  53. Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information. Micro USB

    ReplyDelete
  54. Admiring the time and effort you put into your blog and detailed information you offer!.. http://corintuckerband.com/

    ReplyDelete
  55. All your hard work is much appreciated. Nobody can stop to admire you. Lots of appreciation. soaptoday

    ReplyDelete
  56. It’s appropriate time to make some plans for the future and it is time to be happy. I have read this post and if I could I wish to suggest you few interesting things or advice. Perhaps you could write next articles referring to this article. I desire to read even more things about it! website

    ReplyDelete
  57. I admire this article for the well-researched content and excellent wording. I got so involved in this material that I couldn’t stop reading. I am impressed with your work and skill. Thank you so much. spin the wheel

    ReplyDelete
  58. howdy, your websites are really good. I appreciate your work. anime age ratings

    ReplyDelete
  59. If you set out to make me think today; mission accomplished! I really like your writing style and how you express your ideas. Thank you. voyance telephone gratuite

    ReplyDelete
  60. What a thrilling post, you have pointed out some excellent points, I as well believe this is a superb website. I have planned to visit it again and again. https://www.ecogreenworld.com/arts-entertainment-media/invisible-ink-marked-cards

    ReplyDelete
  61. Your content is nothing short of brilliant in many ways. I think this is engaging and eye-opening material. Thank you so much for caring about your content and your readers. voyance telephone

    ReplyDelete
  62. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. open source dating script

    ReplyDelete
  63. You have a real ability for writing unique content. I like how you think and the way you represent your views in this article. I agree with your way of thinking. Thank you for sharing. Thai Lotto

    ReplyDelete
  64. If more people that write articles involved themselves with writing great content like you, more readers would be interested in their writings. I have learned too many things from your article. Football T Shirt

    ReplyDelete
  65. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!THANKS!!!!!! Grilep

    ReplyDelete
  66. Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks Wonior

    ReplyDelete
  67. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. seattle sewer inspection

    ReplyDelete
  68. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. OC Mortgage Lender

    ReplyDelete
  69. I 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. credit card processing partner program

    ReplyDelete
  70. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. Beauty Tips

    ReplyDelete
  71. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. glass clear tarpaulin uk

    ReplyDelete
  72. New web site is looking good. Thanks for the great effort. white label payment gateway

    ReplyDelete
  73. Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!! North American Bancard ISO Program

    ReplyDelete
  74. I would like to say that this blog really convinced me to do it! Thanks, very good post. payment processing partners

    ReplyDelete
  75. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. 123 movies

    ReplyDelete
  76. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!THANKS!!!!!! North American Bancard Agent Program

    ReplyDelete
  77. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. watch cartoon online

    ReplyDelete
  78. Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. bolly4u.org

    ReplyDelete
  79. The post is written in very a good manner and it contains many useful information for me. f95zone

    ReplyDelete
  80. You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant! merchant referral program

    ReplyDelete