Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

Locking the contents of a row

Hi  

Using Excel for windows Office 2013.

Is there a way to lock a row so no changes can be made in it?

Also if I hide a row will that prevent changes to be made in it, such as row and column color changes etc.

Thanks!

Rowby
0
Rowby Goren
Asked:
Rowby Goren
1 Solution
 
mankowitzCommented:
Select the rows you want to protect and do Home>Format>Lock Cells
Next, lock the sheet with Home>format>protect sheet

See this : http://www.dummies.com/how-to/content/how-to-protect-a-document-in-excel-2013.html
0
 
Rowby GorenAuthor Commented:
Thanks, mankowitz,

That worked perfectly!

...Rowby
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now