To prevent cells from being edited, you can lock them in Google Sheets. This is especially convenient if you’re working on a spreadsheet with others. You may have formulas or functions that you want to make sure no one can change.
What’s nice about the ability to lock cells in Google Sheets is that you have flexibility. You can lock a single cell, a range, column, row, or the entire sheet. In addition, you can choose the permissions for the locked cells. This lets you allow certain people the ability to change them.
Here’s how to lock cells in Google Sheets, adjust the permissions, and unlock the cells for editing later.
PC, laptop, tablet, or smartphone with Google Sheets access.
Log in to Google Sheets and open the spreadsheet you want to lock cells in. Note: You can also open the spreadsheet from your Google Drive.
Step 1: Select the cells you want to lock. Again, this can be an individual cell, cell range, row, or column.
Step 2: Click Data > Protect sheets and ranges from the menu or right-click the selection, move to View more cell actions, and pick Protect range in the pop-out menu.
Step 3: You’ll then see the Protected Sheets and Ranges sidebar open. Confirm that the Range tab is selected. Your chosen cells appear in the range box that you can edit if needed.
Step 4: Optionally, add a description in the Enter a description box.
Step 6: When the Range Editing Permissions box appears, you’ll decide who can edit the locked cells or provide a warning if someone tries to edit them.
Option 1: To only display a warning, mark the first option for Show a warning when editing this range.
Option 2: To restrict the editing to certain users, mark the second option for Restrict who can edit this range. Click the drop-down box and pick Only you, Custom, or Copy permissions from another range.
If you select the Custom option, you’ll see a list of those you’re sharing the sheet with at the bottom. Check the boxes to the right of those you want to allow editing permissions. Optionally, you can add more editors at the bottom.
Step 7: Click Done when you finish.
Note that even sorting data in Sheets isn't possible when the cells are locked.
If you want to lock the cells in an entire sheet or want to lock all but certain cells in a sheet, this is also an option.
Step 1: Select any cell and go to Data > Protect sheets and ranges in the menu or right-click the sheet, move to View more cell actions, and pick Protect range.
Step 2: When the Protected Sheets and Ranges sidebar opens, click the Sheet tab.
Step 3: Pick the name of the sheet you want to lock from the drop-down list.
Step 4: If you want to lock all but specific cells, check the box for Except certain cells. Add the cell, range, column, or row in the corresponding box. To include more, click Add another range and do the same.
Step 5: Optionally add a description in the Enter a description box.
Step 7: When the Range Editing Permissions box appears, choose Option 1 or Option 2 as described above and complete the details.
There may come a time when you want to adjust the permissions you set for locked cells. You may want to add another editor or remove one.
Step 1: Go to Data > Protect sheets and ranges in the menu or right-click, move to View more cell actions, and pick Protect range.
Step 2: In the Protected Sheets and Ranges sidebar, you’ll see a list of cells or the sheet you’ve locked. Select the one you want to edit.
Step 3: Click Change permissions.
Step 4: Make your changes in the pop-up window and click Done when you finish.
If you want to remove the lock you’ve placed on cells or on a sheet, you can do this easily.
Step 1: Go to Data > Protect sheets and ranges in the menu or right-click, move to View more cell actions, and pick Protect range.
Step 2: In the Protected Sheets and Ranges sidebar, you’ll see a list of cells or the sheet you’ve locked. Select the one you want to unlock.
Step 3: Click the trash can icon to the right of the description.
Step 4: Confirm that you want to remove the protection by clicking Remove in the pop-up window.
Protecting data and formulas by locking cells in Google Sheets only takes a few minutes and is worth the time to keep your data safe.
For more, take a look at how to make a graph in Google Sheets for a visual display of your data.
The absolutely absurd idea of putting a touchscreen display on a mouse isn't exactly new. Turtle Beach already did it with its Command Series MC7, which features a 2.25-inch control screen. But apparently, even that wasn't ridiculous enough for Arctic Fox Technologies. Its new Super Mouse looks like someone took the chunky old Atari ST mouse, slapped a touchscreen and scroll wheel on it, and called it an upgrade.
The result is a rather unusual-looking mouse that is now on Kickstarter, starting at $199. And as ridiculous as it looks, some of its features are genuinely intriguing.
Apple is less than a day away from launching its highly anticipated OLED MacBook Pro with a touch-sensitive screen. But it appears that the upgrade is going to cost a pretty penny. According to a report by Bloomberg, Apple is reportedly eyeing a starting price of $2,899 for the 14-inch MacBook Pro, while the 16-inch version could start at $3,399 in the US.
"At $2,899, the 14-inch model would mark the highest starting price for a new MacBook Pro model, surpassing the $2,799 Apple charged for a 17-inch version introduced in 2006," says the report. The report claims that Apple is targeting a minimum price hike of $400 for its upcoming redesigned 14-inch and 16-inch MacBook Pro models.
I've spent a good amount of time digging into the spec sheet of the new M6 MacBook Pro (14-inch), and for all intents and purposes, this is a classic Apple "chip and connectivity" refresh. It's not a full redesign. The chassis, Liquid Retina XDR panel, speakers, ports, and battery, all of them carry over unchanged.
However, the M6 brings more cores, stronger on-device AI, higher memory bandwidth on the larger configs, and modern wireless. Here’s the practical rundown of what actually improved, and whether those gains are worth your money.