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.