Tags Microsoft Excel

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Electronics>Computers

I have made an excel sheet and want to lock certain cells to where they can not be typed in. Is there a way to do this to where I type in some cells and lock other cells?

Updated: 11/6/2022

Wiki User

∙ 13y ago

Best Answer

Change the cell formatting to unprotect for the cells in which you want to type.
Turn on protection for the entire sheet.

Wiki User

∙ 13y ago

This answer is:

ariane jemida ∙

Lvl 1

∙ 11mo ago

This is how you lock the the cells in excel youtu.be/n4-m383UN2U

Add your answer:

Earn +20 pts

Q: I have made an excel sheet and want to lock certain cells to where they can not be typed in. Is there a way to do this to where I type in some cells and lock other cells?

Write your answer...

Submit

Still have questions?

imp

Related questions

How many cells in a 2007 Excel sheet?

17,179,869,184 cells in one excel

Can you protect certain rows or cells on an excel sheet vs the entire page?

Yes. You can turn on protection for any portion of the worksheet you choose.

What is the purpose of the cell cursor in an excel sheet?

to select cells

What removes cells rows and columns from a spread sheet in Excel?

The Delete command.

What is true about Excel checker?

Excel Checker is an Excel add-on that can find every occurrence of cells containing Data Validation or Conditional formatting and list them out on a separate sheet.

How do you use a sheet for another sheet in Excel?

You can reference other sheets in the same workbook by putting the sheet name followed by an exclamation mark and then the cells you want. While on Sheet1, to reference cell C7 on Sheet3, you could do this: =Sheet3!C7

How many ways of referencing cells in a formula in an Excel Sheet?

Three: Relative, Absolute and Mixed.

How do you make a result sheet in Excel?

how to create a excel sheet

What are Rows and Columns in Microsoft Excel?

They are what they say. A row is a line of cells horizontally and a column is a vertical row of cells.

What is the full form of PFA in Excel sheet?

Pfa the excel sheet

What is inactive cell in excel?

At any one time you can only be working on one cell in Excel, like when you are typing data. Even if you have many cells selected, only one can actually be used. That cell is the active cell. All other cells are inactive. So an inactive cell is any cell that is not the active cell.

Does Excel allow symbols in sheet names?

Yes, you can use characters other than letters and numbers in sheet names.

Trending Questions

How much is a dell xps 630i worth? What is heuristics in IDS terminology? How does a baby jaguar eat from is mother? How do you open the tabs dialog box? How do you do the glitch on running Fred for computer? How do lemmings behave when too many are living close together? Why multilayer reference model preferred over single layers structure? How do you double space pages document? How many gallons and quarts are in 21 quarts? How do you pass a stomach virus? What is the 7Th step of the Windows XP Startup Process? What if you soak electronics? What type of hacker uses a scanning device to find unsecured wireless networks and break into those networks? Is there storage larger than a exabyte? Types of fields support input mask? Write a list of the hardware and software that is usually supplied with a new computer? Facade is a pane in johari window? Which versions of Windows contain the Snipping Tool utility? How do you perform integration maths in casio fx-570? Your dog has had a lot of litters and im not a breeder you dont breed your dog for money but she got pregnant again and im scared she might die will she?

Still have questions?

imp

Previously Viewed

I have made an excel sheet and want to lock certain cells to where they can not be typed in. Is there a way to do this to where I type in some cells and lock other cells?

Resources

Top Categories

Product

Company

Copyright ©2024 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.