Very similar to our previous article on how to make a header row in Google Sheets, in this article we'll show how you can lock a column in Google Sheets.\n\n\n\nTo lock a column in Google Sheets easily just navigate and click on the View menu, then on the sub-menu Freeze, then click on either of the options presented: "No column" (to remove any locked columns), "1 column" (to lock the first column), "2 columns" (to lock the first two columns), or "Up to current column" (depends on where the current active cell is located).\n\n\n\nTo lock a column from the View menu select one of the options here\n\n\n\nAlternatively you can hover your mouse over to the top-left corner of the spreadsheet, the cell containing no label and is found to the left of the column A label and above the row labelled 1, where you can see on the right side of the box a thicker line than what otherwise separates each column, as shown here:\n\n\n\nUsing your mouse hover over to the corner cell\n\n\n\nWhen your mouse pointer changes to a hand it means you can grab the object underneath. When you click and hold your mouse cursor and then move your mouse right you should see a vertical line which denotes what columns to the left you would like to keep frozen.\n\n\n\nWhen you are done with moving the vertical line across, release your mouse button and this will now set the columns to the left of that bar as being locked.\n\n\n\nHere I've locked both the first row (1) and the first two columns (A & B)\n\n\n\nBy locking columns you can better navigate through your sheets where you have a lot of columnar data.\n\n\n\nLocking Columns In Google Sheets For Printing\n\n\n\nJust as we can lock columns in Google Sheets on the screen we can also use our locked columns when it comes to printing our data.\n\n\n\nWhen printing our Google Sheet there is an option in the print screen under the Headers & Footers section where you have the option to print each sheet with the locked columns, just check to make sure Repeat Frozen Columns is ticked. This will allow you to see the locked columns on the left-side of each page printed.\n\n\n\nBy default if you have a locked column this option will automatically be ticked, but if this option is greyed out it's because you haven't set any locked columns. Do lock a column first before deciding to print your document.\n\n\n\nMake sure this option is checked when printing data with locked columns\n\n\n\nLocking Too Many Columns\n\n\n\nIf you find you can't move your spreadsheet to the right using the mouse cursor, or find your active cell disappearing off the screen, then you may have locked too many columns. If you have your active cell beyond the width of your screen (say at column R) and navigate to View > Freeze and click the option Up to current column (R) then you will notice the following prompt:\n\n\n\nThe current window is too small to properly display this sheet. Consider resizing your browser window or adjusting frozen rows and columns.HELPFUL GOOGLE SHEETS PROMPT\n\n\n\nBy ignoring this prompt you have now effectively frozen your workspace and possibly even lost your active cell.\n\n\n\nSo how do you fix a frozen screen in Google Sheets?\n\n\n\nHow To Remove Locked Columns In Google Sheets\n\n\n\nTo remove locked columns in Google Sheets easily just navigate to the View menu, and then hover over the Freeze sub-menu and then select the option No columns. \n\n\n\nOnce you've selected this your frozen columns would have been removed and you can navigate back through your sheet normally again.\n\n\n\nSummary\n\n\n\nLocking a column helps to easily navigate through spreadsheet data in Google Sheets when the data has many columns and the first row (or two) help to provide context on the data in each column.\n\n\n\nIn this article we explored the two most popular ways to lock a column in Google Sheets, how this can cause a problem if you lock too many columns, and how to remove the column lock.\n\n\n\nNext you might want to read our article on how to lock a row in Google Sheets.