Facebook with Latestnigeriannews  Twieet with latestnigeriannews  RSS Page Feed
Home  |  All Headlines  |  Punch  |  Thisday  |  Daily Sun  |  Vanguard   |  Guardian  |  The Nation  |  Daily Times  |  Daily Trust  |  Daily Independent
World  |  Sports  |  Technology  |  Entertainment  |  Business  |  Politics  |  Tribune  |  Leadership  |  National Mirror  |  BusinessDay  |  More Channels...

Viewing Mode:

Archive:

  1.     Tool Tips    
  2.    Collapsible   
  3.    Collapsed     
Click to view all Entertainment headlines today

Click to view all Sports headlines today

How to lock cells in Microsoft Excel, so you need a password to change or erase data

Published by Business Insider on Sat, 28 Dec 2019


To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab.Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which is useful if you're sharing a spreadsheet with precise data.Once you lock a cell, you'll be asked to set a password. Excel will ask you for this password if you try to unlock the cell.Visit Business Insider's homepage for more stories.Locking particular cells in Microsoft Excel can be a slightly tricky process, but once you've figured it out, it can be extremely valuable.Not only does it allow you to share an Excel sheet and all its corresponding data without worry over whether someone will change it all, it can also help make sure you or somebody else doesn't accidentally erase values or headings you need to have.Check out the products mentioned in this article:Macbook Pro (From $1,299 at Best Buy)Microsoft Surface Pro 7 (From $999 at Best Buy)How to lock cells in Excel1. Select your whole sheet, done most easily by pressing Crtl + A on your PC keyboard, or Command + A on a Mac.2. In the "Home" tab, click on the arrow under "Alignment" to open the "Format Cells" pop-up window.3. Click on the "Protection" tab.4. Uncheck the box next to "Locked". Most Excel documents will come with this checked by default. You need to uncheck this, then click "OK" at the bottom of the pop-up.5. Now select the specific cells you want to lock.6. Click on the arrow under "Alignment" and again click on "Protection" in the "Format Cells" pop-up.7. Click the box next to "Locked." Then click "OK" at the bottom of the pop-up.8. From the top row of the toolbar click on the "Review" tab to change toolbar groupings available.9. Click on "Protect Sheet" in the "Protect" tab.10. Once you've clicked on "Protect Sheet," the "Protect Sheet" pop-up will appear and allow you to decide what will be restricted in the sheet.11. If you want to allow the person you send the sheet to have the ability to format, change, and move all the data, except the cells you want to lock, check every box except for the top one (which says "Select Locked Cells"). You can scroll down and see if there are any operations you don't want to allow them to make.12. You'll be asked to enter a password. Make sure you remember it, since you won't be able to unlock the cells without entering the password. Then click "OK" at the bottom.13. You'll be asked to enter the password again to confirm. Once you've done so, the cells you selected earlier will be locked, but the others will be editable.14. To make all cells editable again, click on "Unprotect Sheet" ' which is in the "Protect" tab under "Review" ' and re-enter your password. The cells will now be unlocked.Related coverage fromHow To Do Everything: Tech:How to copy a formula in Microsoft Excel using a Mac or PCHow to edit a drop-down list in Excel, depending on how you created itHow to alphabetize data in an Excel spreadsheet by column or row, and by using shortcutsHow to combine two columns in Microsoft Excel without losing dataHow to freeze a row in Excel so it remains visible when you scroll, to better compare data on different parts of a spreadsheetSEE ALSO:The best all-in-one PCs you can buyJoin the conversation about this storyNOW WATCH: Apple just released iOS 13.2 with 60 new emoji and emoji variations. Here's how everyday people submit their own emoji.
Click here to read full news..

All Channels Nigerian Dailies: Punch  |  Vanguard   |  The Nation  |  Thisday  |  Daily Sun  |  Guardian  |  Daily Times  |  Daily Trust  |  Daily Independent  |   The Herald  |  Tribune  |  Leadership  |  National Mirror  |  BusinessDay  |  New Telegraph  |  Peoples Daily  |  Blueprint  |  Nigerian Pilot  |  Sahara Reporters  |  Premium Times  |  The Cable  |  PM News  |  APO Africa Newsroom

Categories Today: World  |  Sports  |  Technology  |  Entertainment  |  Business  |  Politics  |  Columns  |  All Headlines Today

Entertainment (Local): Linda Ikeji  |  Bella Naija  |  Tori  |  Daily News 24  |  Pulse  |  The NET  |  DailyPost  |  Information Nigeria  |  Gistlover  |  Lailas Blog  |  Miss Petite  |  Olufamous  |  Stella Dimoko Korkus Blog  |  Ynaija  |  All Entertainment News Today

Entertainment (World): TMZ  |  Daily Mail  |  Huffington Post

Sports: Goal  |  African Football  |  Bleacher Report  |  FTBpro  |  Kickoff  |  All Sports Headlines Today

Business & Finance: Nairametrics  |  Nigerian Tenders  |  Business Insider  |  Forbes  |  Entrepreneur  |  The Economist  |  BusinessTech  |  Financial Watch  |  BusinessDay  |  All Business News Headlines Today

Technology (Local): Techpoint  |  TechMoran  |  TechCity  |  Innovation Village  |  IT News Africa  |  Technology Times  |  Technext  |  Techcabal  |  All Technology News Headlines Today

Technology (World): Techcrunch  |  Techmeme  |  Slashdot  |  Wired  |  Hackers News  |  Engadget  |  Pocket Lint  |  The Verge

International Networks:   |  CNN  |  BBC  |  Al Jazeera  |  Yahoo

Forum:   |  Nairaland  |  Naij

Other Links: Home   |  Nigerian Jobs