ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
تاريخ النشر: 2015/04/09
Khan said
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل 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
من قبل Mohammed Shamseer Vettan , Technical Lead, Solution Architect, Full Stack .Net Developer , Digipresence LLC

U can give password to excel

 

المزيد من الأسئلة المماثلة