Topics Search

How to Lock Cells

How to Lock Cells
Views: 22
Sometimes you may want to lock cells in Excel so that other people can’t make changes to it. It could be to avoid tampering of critical data or prevent people from making changes in the formulas.
Sponsored Links:

Similar posts...

 

How to Lock Cells in Excel

How to Lock Cells in Excel Icon
Sometimes you may want to lock cells in Excel so that other people can’t make changes to it. It could be to avoid tampering of critical data or prevent people from making changes in the formulas.
 

How to Find and Remove Merged Cells

How to Find and Remove Merged Cells Icon
Do you merge cells in Excel? If yes, you need to know a few drawbacks of merging cells. To begin with, if you try and sort cells that have been merged, it will refuse to do so and show you an error that says – To do this, all the merged cells need to be of the same size...
 

Lock & Protect Formula Cells

Lock & Protect Formula Cells Icon
If you have a workbook with lots of formulas and you want to protect those formulas from being amended by other people who share your workbook, then you can! Press the Go To Special shortcut CTRL+G. Select the Constants box and press OK (this highlights all the non-formula cells)...
 

Excel 2010 Cell Basics

Excel 2010 Cell Basics Icon
You will need to know the basic ways you can work with cells and cell content in Excel to be able to use it to calculate, analyze, and organize data. In this lesson, you will learn how to select cells; insert content; and delete cells and cell content. You will also learn how to cut, copy and paste cells; drag and drop cells; and fill cells using the fill handle.
 

How to Center Text Across Multiple Cells

How to Center Text Across Multiple Cells Icon
If you have a label or heading on a spreadsheet in Excel that you want to center across a certain number of cells, there are couple of ways you can do this, with or without merging cells. We’ll show you both ways. First, we’ll center text across cells by merging cells. To do this, select the cells you want to merge.
 

How to add and delete, lock, format, merge and split cells

How to add and delete, lock, format, merge and split cells Icon
Microsoft Excel is a hugely popular piece of software that comes bundled with Microsoft Office. However, while it may be hugely popular, it can also be extremely confusing to use - especially when you start working with advanced features. Here, we show you how to use some of the basic Excel features including cell merging, formatting, deleting and adding cells and even cell locking.
 

Selecting Only Constants or Formulas

Selecting Only Constants or Formulas Icon
Sometimes you want to do something — such as format, delete or edit — all cells containing constants or formulas at the same time. Here’s how to select all such cells so you can thereafter do to them what you want. Microsoft created the moniker “Special Cells” as an umbrella name for groups of different classifications of cells. There is nothing special about Special Cells except their condition of interest at the moment you care about them.
 

Conditionally Formatting Locked and Unlocked Cells

Conditionally Formatting Locked and Unlocked Cells Icon
There are times when your users will find it easier to enter data directly into worksheet cells, instead of a userform interface. You’ll want to protect all the cells containing formulas and static header labels, while allowing certain cells to be unprotected for users to input data.
 

Delete Values From Cells While Keeping Formulas

Delete Values From Cells While Keeping Formulas Icon
One common way to set up a spreadsheet is to have input cells (which the user changes) and formula cells which work in tandem with those user input cells to display the results of the formulas. But what if you want to delete all of the data thats in the input cells but keep your formulas intact.
 

Excel 2010 Modifying Columns, Rows, and Cells

Excel 2010 Modifying Columns, Rows, and Cells Icon
When you open a new, blank workbook, the cells are set to a default size.You do have the ability to modify cells, and to insert and delete columns, rows, and cells, as needed. In this lesson, you will learn how to change row height and column width; insert and delete rows and columns; wrap text in a cell; and merge cells.