You've labored on your spreadsheet and you need to make sure anyone you share it with doesn't inadvertently change cells that really should not be changed. Thankfully, Microsoft Excel 2016 and earlier versions let you lock cells to safeguard them from being modified on Windows 10. You can lock all of the cells inside a worksheet or specific cells, allowing some parts from the spreadsheet to be changed. Here's how to lock cells in Excel.

Editor's Note: This tutorial was written for Excel 2016, but still applies to modern versions of Excel.

How you can Lock All of the Cells within an Excel Worksheet

By default, when you protect a sheet or workbook, all the cells is going to be locked. This means they cannot be reformatted or deleted, and also the content inside them can't be edited. Automatically, the locked cells can be selected, however, you can change that within the protection options.

1. Navigate to the Review tab.

2. Click Protect Sheet. In the Protect Sheet window, enter your password that is required to unprotect the sheet (optional) and then any from the actions you need to allow users.

3. Click OK to protect the sheet.

Whenever you or other people attempts to edit any of the locked cells, this message will come up.

Cells can only be unlocked once the sheet is unprotected (by going to the Review tab again, choosing "Unprotect Sheet," and entering the password, if required).

How to Lock Specific Cells within an Excel Worksheet

There can be times when you want to lock certain cells from being changed but nonetheless allow users to adjust other cells in a worksheet. In our example, within an inventory list you may allow unit prices and stock quantities to be updated, but not the product IDs, names, or descriptions. As stated before, all cells are locked by default when you protect the sheet. However, you are able to specify whether a cell should be locked or unlocked within the cell's format properties.

1. Select all of the cells you don't want to be locked. These would be the cells that may be edited despite the sheet remains safe and secure.

2. Right-click on your selection, select Format Cells, and then click the Protection tab. (Alternatively, underneath the Home tab, click the expansion icon next to Alignment, and in the Format Cells window visit the Protection tab.)

3. Uncheck "Locked" (which is checked by default) and click OK.

4. Go to Review > Protect Sheet and hit Alright to protect the sheet. Any cells you didn't unlock under the Format Cells option (step 3 above) will be locked, while the unlocked cells will be editable.

Note that cell locking (or unlocking) won't take effect until you do step 4, protecting the sheet.

Protip: If you want to quickly lock or unlock cells that aren't alongside each other, you can use a keyboard shortcut. After selecting a cell or number of cells, use the Format Cells dialog as above to lock or unlock it. Then select your next cell(s) striking F4 to repeat your last action.

Windows 8 users who had been awaiting a much better consumer experience do not have to wait any more. Microsoft's Windows 8.1 can be obtained as a free upgrade for just about any PC running Windows 8. With just a few simple steps, you will get important new features, including the ability to see multiple windows in Modern UI, a Start Button and a search function that returns results both on the internet as well as your hard disk. Here's how to change your Windows 8 PC to Windows 8.1.

1. Make certain your computer has all recent Windows updates. If you have been using Windows 8 steadily you are probably up to date, but if it's been a few days because you last logged directly into your computer, adopt these measures to check on.

1a. Click settings around the Charms menu.

1b. Click Change PC settings.

1c. Select Windows Update.

1d. Click on the Check for updates now button to ascertain if you will find any new files.

1e. Force any updates to set up immediately by hitting the "We'll install . . . automatically" link then Intall.

2. Open the Windows Store app.

3. Click the Update to Windows 8.1 button. If you don't check this out button on the screen, look for updates again, close and reopen the Windows Store or reboot your machine.

4. Click the Download button to verify.

You may have to wait 30 minutes or more for the install to download, however, you can keep making use of your computer during this period.

5. Click Restart Now when prompted.

Your computer will then take several minutes installing Windows 8.1, complete with at least one reboot. You can walk away from your computer and do something else for five minutes or more because your input won't be necessary for a while.

6.Click "I Accept" when given the License terms.

7. Click Use Express Settings at the bottom from the screen. You may also choose custom settings, but we find the Express settings work well for many users.

8. Register to Windows as you normally would.

9. Allow Windows to send a burglar code to your phone whether it prompts you. You are able to skip this step, but may not be able to sync your account across PCs without performing it later.

10. Go into the code you received in your phone at the prompt.

11. Click Next around the Skydrive screen.

You will then have to wait a couple of minutes while Windows finishes the install process. You'll see some messages on screen that say it is setting up and installing apps.

One of the most important areas of an extensive backup is creating a copy of the address book. If at some point you lose access for your Outlook account, you'll be glad that you simply exported its contents, retaining the means with which to make contact with your pals, family and business connections.

Downloading your contacts also enables you to switch to another email client inside a more seamless manner, therefore if Outlook is becoming too bulky for your taste, you will not have to rebuild your address book from scratch. Listed here are step-by-step instructions for downloading and importing your Outlook address book.

How to Download Your Address Book in Outlook 2016 and Prior

1. Click File.

2. Select Options in the side menu.

3. Click Advanced from the side menu.

4. Select Export under Export.

5. Select Export to some file and click on Next.

6. Click Next. Here i am importing a Comma Separated Values File so we could import the address book to some program of our choice. If you are sure you need to stick with Outlook, choose the Outlook Computer file option.

7. Select Contacts and click Next.

8. Name your address book backup and click Next.

9. Click Finish.

Your address book continues to be downloaded!

How to Import Your Address Book to Outlook 2016 and Prior

1. Click File.

2. Select Open & Export.

3. Select Import/Export.

4. Select "Import from another program or file" and click on Next.

5. Choose the type of Address Book file kind you're importing and click on Next. Here i am importing a Comma Separated Values File.

6. Click Browse.

7. Select the file you're importing and click OK.

8. Click Next.

9. Select Contacts and click on Next.

10. Click Finish.

Your Outlook contacts have been imported!

As laptops get smaller, storage space gets more valuable. While many of us supplement physical storage with cloud-based alternatives, there's no replacement for storage on-demand, even if you're not attached to the internet. And for most Windows users, the quantity of storage wasted on temp files and the Recycle Bin would free up a fair little bit of space on our hard disk if perhaps we're able to we're able to remember to eliminate it.

A new feature in Windows 10's Creators Update has your back.

1. Right click the Windows icon at the end right of the screen and open the System menu.

2. Select Storage in the sidebar at the left.

3. Toggle Storage Sense to the on position.

4. If you'd like to determine what Storage sense deletes (either files in the Trash can or temp files -- or both), click the Change how we free up space link below the toggle.

5. Toggle on, or from the desired settings.

Windows uses a system folder called WinSxS to store files that are needed for the Windows installation, in addition to backups or updates to people files. It's a space hog, however, taking up several gigabytes of space and growing with each Windows Update you perform. Use the steps below to wash up unnecessary files for the reason that WinSxS folder and reclaim valuable hard drive space.

You cannot just delete everything in the WinSxS folder, because some of the people files are essential for Windows to operate increase reliably. However, with Windows 7 and above you should use the built-in Disk Cleanup tool to delete older versions of Windows updates you no longer need. With Windows 8.1 and Windows 10, you should use the Command Prompt to wash up the WinSxS folder as well.

Use Disk Cleanup to Delete Old Updates In the SxS Folder

1. Open the Disk Cleanup tool. This can be done by typing "disk cleanup" within the taskbar and clicking "Disk Cleanup"

2. Click the "Cleanup system files" button.

3. Look into the box next to "Windows Update Cleanup."

4. Click OK.

Observe that if you do not see the Windows Update Cleanup option in Disk Cleanup, that means there aren't any files that can be safely deleted.

Use the Command Prompt to wash Up the SxS Folder

If you want a more thorough look at how much space the SxS folder is taking up and the option to cleanup unneeded files, make use of the Command Prompt.

1. Launch the command prompt with admin priviledges. This can be done by right-clicking around the Windows icon within the taskbar and click "Command Prompt (Admin)."

2. Enter the command: Dism.exe /online /Cleanup-Image /StartComponentCleanup

It might take a couple of minutes for the DISM tool to investigate the folder. When it is done, you'll see size details of the components within the WinSxS folder and, at the end, a recommendation to clean it up or not.

3. If recommended, clean up the folder by using this command within the Command Prompt: Dism.exe /online /Cleanup-Image /StartComponentCleanup

There's another command will uninstall Windows updates and repair packs, which saves extra space, but we do not recommend you do that, because you won't be able to uninstall any current service updates or service packs after performing this. The command is Dism.exe /online /Cleanup-Image /StartComponentCleanup

The cleanup usually takes some time, based on the body and how much you're deleting, but that extra room is going to be worth it.

Multiple desktops in Windows allow you to separate program windows into different groups. You might have all of your files associated with one project open in a single desktop, for example, and programs and files associated with a different project in another desktop. Microsoft added virtual desktops to Windows 10 for this multi-tasking organization. Here's how you can arrange it.

1. Click on the Task View icon within the taskbar. It appears as though two overlapping windows. Alternatively, use the Windows+Tab keyboard shortcut to enter Task View.

2. Click on the New desktop button in the Task View.

Windows can create an additional virtual desktop you are able to change to using the Windows+Tab keyboard shortcut.

Once your additional desktop is created, you can open new program windows in it. You can also drag a window in one desktop to another, and change to another desktop with the Windows+Tab keyboard shortcut.

Other shortcuts that will make using multiple virtual desktops easier:

WIN + CTRL + LEFT/RIGHT: Switch to the prior or next desktop
WIN + CTRL + D: Create a new desktop
WIN + CTRL + F4: Close the present desktop

It is a great way to organize and group files and programs according to how and when you should utilize them.

Windows 10 has offered the opportunity to mirror your screen to the dongle or device (streaming box, TV) compatible with the most popular Miracast standard since its launch in 2015. Microsoft's OS now lets your PC end up being the wireless display, receiving Miracast signals from the phone, tablet or other Windows 10 laptop or desktop.

For those who have a little Windows 10-powered computer connected to your TV, it can now be used as a wireless display dongle for the phone or laptop. When you're mirroring from a Windows 10 computer, you are able to extend rather than duplicate the screen so you can, for instance, play a film around the receiving display while you send emails on the primary one. Consider going for a Windows 10 tablet, propping it up next to your laptop and using it as a second monitor on the road.

While most modern devices with Wi-Fi have the ability to send out a Miracast signal, compatibility is spotty at best. Sometimes you need to try casting your screen 3 or 4 times before the process works. So be patient. If you accidentally rotated your screen while trying to extend your display, we have a fast solution for that.

Seeking to do screen mirroring on Windows 10? Here's how to turn your Windows 10 PC right into a Miracast-capable wireless display:

1. Open the experience center. It's represented by the speech bubble icon within the lower right corner of the screen.

2. Click Connect.

3. Click Projecting for this PC.

A settings window appears.

4. Select "Available Everywhere" or "Available everywhere on secure networks" from the top pulldown menu.

5. Select "First time only" or "Every time" under "Ask to project to this PC." I suggest picking "first time only," unless you're really worried that some rogue person is likely to grab your phone and project to your computer without your permission.

I suggest leaving "Require PIN for pairing" off because you need to grant permission around the receiving computer anyway. You can also decide whether you would like your computer to receive projection requests only if it's plugged in.

6. Click Yes when Windows 10 alerts you that another device wants to project to your computer.

The Windows connect app will launch in the own window. You are able to drag, resize or increase the window. We found that videos played smoothly inside a link between a Surface Pro 4 along with a ThinkPad T440s. Also, if the sending system is a Windows 10 PC and allows it, you can use the keyboard and mouse around the receiving computer to remotely control the sender.

How you can Mirror Your Windows 10 Screen to Another Windows 10 Device

Here's how to broadcast your screen from the sending device, if it's a Windows 10 computer. Android devices have different wireless display menus.

1. Open the experience center.

2. Click Connect. A list of available receiving devices appears as well as your other computer should be onto it.

3. Select the receiving device. You might want to wait one minute or longer for that devices to pair. This may also fail and you will need to repeat the process.

4. Toggle "Allow input" to on if you want to let the receiving device take control of your PC with its mouse and keyboard.

5. Click "Change projection mode" and select "Extend" from the menu that appears if you want to use the wireless display like a second desktop, rather than a mirror of your current desktop.

6. Click Disconnect when you wish to terminate your connection.

Adobe's popular Flash plugin has long been infamous, due to its security holes. Mozilla has even made the bold move of disabling it automatically in Firefox. However, Windows 10 includes Flash built right into the operating-system and it is Edge browser. Since Microsoft is managing the code, it may be safer, but a lot of individuals don't want to take the risk. Here's how to disable Flash in Microsoft Edge.

1. Click the menu button in Edge. It's the three dots within the upper right corner.

2. Select Settings in the menu.

3. Click the "View advanced settings" button. You will need to scroll down a little bit to locate it.

4. Toggle "Use Flash Player" to off.

Cortana along with other Microsoft services, such as Bing, use your recent searches and history to customize their search recommendations for you in Windows 10. If you do not want that personal data stored in your Microsoft account, you can clear it in a handful of steps.

1. Navigate to https://www.bing.com/account/personalization inside your browser.

2. Sign in with your Microsoft account if prompted.

3. Click the Clear button under "Interests" to delete your saved favorites and interests for Bing, MSN, and Cortana. Interests include news topics, weather, finance, and flights you've put into your Microsoft account, for instance, with interest tiles around the Bing homepage.

4. Click Clear to verify your choice.

5. Click the Clear button under "Other Cortana Data and Personalized Speech, Inking and Typing." This will pay off the info saved out of your calendar, contacts, location, and browsing history.

6. Again, click Clear to verify.

7. Stick to the other links on the page to pay off or manage additional saved info, such as your saved places in Bing Maps, Bing search history, and saved info for Xbox, OneDrive, Outlook, and Microsoft Advertising.

Observe that whenever you clear the personal info, Cortana along with other Microsoft services could be more limited in providing you personalized recommendations. You will also need to head back to the personalization page again after while using services to eradicate any new info saved to your Microsoft account.

Microsoft has started selling a Surface Go Kids bundle that includes not only the Surface Go, but also other goodies that are specifically aimed at kids who want to explore the field of tech while also having fun.

Surface Go is Microsoft's smallest and cheapest Surface model released so far, so it's specifically targeted at students and teachers who require a lightweight device that doesn't necessarily boast a crazy processing power.

And also the Surface Go, which runs Windows 10 Home in S Mode and is equipped with an Intel 4415Y processor, has so far been a very appealing product for this category of buyers.

This is why Microsoft has become trying to expand its audience with the discharge of the top Go Kids bundle, which much like its name suggests, is made with the concentrate on tech-savvy kids looking for a Windows 10 device.

What's included in the bundle?

The bundle comes with three items. First of all, it's the Surface Go itself, which comes in a non-LTE configuration, so you won't have on-the-go Internet access, albeit Wi-Fi should pretty much enough for most buyers. Then, the bundle includes the JBL Headphones for children (JBL JR300), which once more are specially sized for children.

And finally, it's a special Gumdrop Foam Tech Case for Surface Choose extra protection because when all parents knows, you really want to safeguard every little gadget as much as possible when a kid is around.

The case is available in purple and blue, and you may choose the color when ordering the bundle.

This offers are valid until December 31, and unfortunately, it's only targeted at customers in the United States, without any other markets included for the time being. It's understandable the promo runs so long as supplies last, so if you would like to get the bundle, you need to check out the Store right now to order it.

This past year, Netflix made it possible for iOS and Android users to download shows and films watching them offline. That functionality is finally visiting Windows 10. The feature is still rolling out, so you may avoid seeing it immediately.

To download content, you will need to use the Netflix app (which often comes as area of the standard Windows 10 bloatware package), so be sure you have that first. The library that's available for download is somewhat limited, but Netflix original series for example "House of Cards" and "BoJack Horseman" are shoe-ins.

To download, find an episode with the download symbol (an arrow pointing down) and press it. It'll download, and you can watch it offline.

To determine all the content which can be found to download for offline viewing, click on the hamburger menu in the top-left and select "Available for Download." Gleam section called "My Downloads" that shows something that you've downloaded to look at later.

This really is prone to make plane trips and other long slogs without an web connection that much easier. It's also helpful for those who have a poor connection and wish to watch a show without them hiccuping with the best parts.

NVIDIA has made available a brand new version of its Quadro graphics driver, namely release 440 U1 (440.97 WHQL), which is an ODE ('Optimal Drivers for Enterprise) package that implements full support for Microsoft's Windows 10, November 2019 Update (Update 19H2).

In addition to that, the present release delivers performance enhancements (as much as 30% gain) for apps such as Dassault Systemes SOLIDWORKS, PTC Creo, and Autodesk VRED, and adds G-SYNC support for windowed OpenGL and Vulkan applications.

Moreover, users can now merge and scale the content of two displays and output the final image to some separate display/projector connected to the same GPU, make use of several new extensions, and revel in additional changes as highlighted in the Release Notes below.

With regards to compatibility, version 440.97 is suitable for desktop and notebook configurations which are run by one of Microsoft's 64-bit variants of Windows 7, 8, 8.1, or 10 platforms, and for desktop systems running Windows Server 2008, 2012, 2016, or 2019 OSes.

Therefore, if you intend to apply this package, just save the proper one for your device, run it, wait because the wizard extracts all files required for cellular phone, and follow all instructions displayed for a complete upgrade.

Last but not least, once completed, it might be a good idea to execute a system reboot to allow all changes to consider effect properly. If the task isn't requested automatically through the wizard, make sure to carry it out manually to prevent any unwanted problems.

Quite simply, download NVIDIA Quadro Graphics Driver 440.97, apply it to the body and enjoy the changes this latest version brings about. Also, check our website constantly to remain up to speed using the latest releases.