Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What are the available tools to protect my sheet in excel or hide it?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/04/09
Khan said
par Khan said , Science Teacher , Mahtab Khurshid Memorial School

Apply password under main manu Review>Protect Sheet option, Then right click on the sheet name and click on HIDE option of the drop down menu. 

Ahmed Maher
par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

from file > info > Protect workbook > Encrypt password

or from tab Review Protect worksheet

Abdul Basit Patangia
par Abdul Basit Patangia , Assistant Manager Marketing Services , Getz Pharma

You can go to the uper6th tab in excel (Name Review) .. After then you can find the icon of Protect Sheet .. you can click it. and type password what you want.

 

 

Ahmed Maher allam
par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

thank you mr khan said and mr Abdul basit

I agree with all the previous answers.

You are able to protect formula's, and specific rows and columns.

You may hide columns or rows, and once the sheet is protected by "Sheet Structure", users will not be able to review hidden columns or formulas.

The more drop-down selections there are for users, the more accurate the data sheet and more consistent the data will be.

My personal favourite; hide formulas with in a specific cell and row; which you are unable to hide the entire row or column by using CUSTOM FORMAT  ;;

BUT the worksheet must be structure password protected, otherwise the cell will get over-written. 

Shahid Chaudhry
par Shahid Chaudhry , Survey Engineer/Quantity Estimator , Archen Engineering Consultant

Also right click on sheet name>protect sheet > choose password > repeat password and done

FITAH MOHAMED
par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

You can hide an Excel sheet, but users can unhide it just as quickly. If you want a more securely hidden sheet, hide it in the Visual Basic Editor (VBE).Fortunately, the technique is simple for you -- and users won't suspect a thing.

**1** The traditional method for hiding a sheet:

1-Open a new workbook.

2-Click Sheet's tab to select it.

3-From the Format menu, choose Sheet.

3-From the resulting submenu, choose Hide. Excel hides Sheeet* and its tab

 

**2**hide it in the Visual Basic Editor

1- Switch to Excel's VBE (press [Alt]+[F11]).

2-In the Project Explorer, select the sheet you want to hide. 

3-In the Properties window, select2 - xl Sheet Very Hidden from the Visible property's drop-down list.

 

 

Santosh Thakor
par Santosh Thakor , Sr Software Developer , I-Link infosoft consultants Pvt Ltd

1. Select all content from the file

2. Change the text color as background of the file

3. Save this file

Reynaldo Corvera
par Reynaldo Corvera , Planner , Flexible Packaging

a .Select Review Tab Ribbon

    Choose: Protect Sheet or Protect Workbook ( use password protection.

b. Select Home Tab Ribbon in on each menu there is a small arrow pointing down right.. click and the format cell will popup on select Protection tab then uncheck Locked: then press ok..

select particular cells to lock then go to worksheet then right click then 

- protect sheet then put the password.. You formulas are protected .. but still you can use other cell for entering data.

 

Mohammed Shamseer Vettan
par Mohammed Shamseer Vettan , Technical Lead, Solution Architect, Full Stack .Net Developer , Digipresence LLC

U can give password to excel

 

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?