This Excel tutorial explains how to protect a cell in Excel 2013 (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: How do I protect a cell from being edited by others in Microsoft Excel 2013?
Ms Excel 2013 Parts
Excel 2013 is a powerful spreadsheet program designed for professional use across a range of industries. The program is part of the larger Microsoft Office package. That means it is easy to import and export data between other Microsoft programs such as Word or PowerPoint. Excel 2013 allows you to enter rows and columns of data on a large grid. A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Excel 2013.
Answer: First, you'll need to un-protect all of the cells on your sheet. To do this, select all of the rows and columns in your sheet. Right-click on then select 'Format Cells' from the popup menu.
When the Format Cells window appears, select the Protection tab. Uncheck the 'Locked' checkbox. Click on the OK button.
Next, select the cell(s) that you wish to protect. Right-click and then select 'Format Cells' from the popup menu.
When the Format Cells window appears, select the Protection tab. Check the 'Locked' checkbox. Click the OK button.
Some of the popular features in Visual Studio that help you to be more productive as you develop software include: 1. Squiggles and Quick ActionsSquiggles are wavy underlines that alert you to errors or potential problems in your code as you type. These visual clues enable you to fix problems immediately without waiting for the error to be discovered during build or when you run the program. If you hover over a. Build and run code on a remote machine or Windows Subsystem for Linux and browse, edit, and debug from within Visual Studio. Use CMake to target multiple platforms from the comfort of a single IDE. Development applications – Get Started. Components – Visual Studio C core features – Windows Universal C Runtime – Visual C for Linux Development. Use of visual studio.
For the locking of the cells to take effect, you must also protect the worksheet. To do this, select the REVIEW tab from the toolbar at the top of the screen. Then click on Protect Sheet button.
A 'Protect Sheet' window will appear. You may enter a password to protect the sheet if you wish. The password is optional. Click on the OK button.
How long have you been using Microsoft Excel?
Have you ever thought how Excel or the other electronic spreadsheet softwares came to existence?
In today’s post, we will go back in time to trace the origin of Excel. So, here we go:
While the origin of electronic spreadsheets can be traced back to 1978, but it wasn’t until 1982 when Microsoft jumped into the arena of Electronic spreadsheets with a product known as MultiPlan.
Muliplan was Microsoft’s first electronic spreadsheet program. It was introduced in 1982 as a competitor for VisiCalc (the first ever electronic spreadsheet program). The key difference between Multiplan and its competitors was Microsoft's decision to use R1C1 addressing instead of the A1 addressing which was introduced by VisiCalc.
Muliplan was very popular on CP/M systems, but on MS-DOS systems it lost fame to Lotus 1-2-3. This thing motivated Microsoft to develop another spreadsheet product Excel.The first version of Excel was released in 1985 for Mac. Later in November 1987, the first Windows version was released.
It all started with VisiCalc:
Ms Excel 2013 Notes
In 1978, Harvard Business School student Dan Bricklin developed a program called VisiCalc. It was a relatively small program with few basic capabilities. It could only calculate data within a matrix of 5 columns by 20 rows.
To make VisiCalc more powerful Bricklin hired Bob Frankston, who is also known as the co-creator of VisiCalc. Frankston made the program fast and with better arithmetic. VisiCalc was an instant success and the duo were able to sell around 1 million copies of the program.
Note: You can still download an original copy of Visicalc from Dan Bricklin’s website: http://www.bricklin.com/history/vcexecutable.htm [size: 27 K]
What followed VisiCalc?
After the phenomenal success of VisiCalc, a team headed by Mitch Kapor in 1983, developed a new spreadsheet program called Lotus 1-2-3. Mitch and his team power packed Lotus 1-2-3 with charting, graphing and rudimentary database capabilities along with the basic arithmetic. This made Lotus 1-2-3 a new favourite in the industry.
Although, before this in 1982 Microsoft had already launched Muliplan but it was outshined by Lotus 1-2-3. And this thing provoked Microsoft to come up with Microsoft Excel and rest is history.
The Infographic on History of Microsoft Excel:
Ms Excel 2013
This infographic takes a closer look at the history of Excel, circa 1978-2013.