Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

In Excel you want to have a sheet that can not add any columns and rows, what should you do? Using the protection by password is not correct!!

user-image
Question added by Deleted user
Date Posted: 2013/11/06
Deleted user
by Deleted user

It is soooo easy, we know that the last Cell in Excel is "IV65536", if we put a "*" in the that cell then you can not add any Column our Row in that sheet!!!!!!!!!!!!!!!!!

Without any protection you can do that. 

mohammed shafi ur rahman mohammed
by mohammed shafi ur rahman mohammed , Senior Accountant , Remix Tech LLC

click on review tab 

Protect work sheet 

Password (set password after selecting list as shown below)

allow all users of this worksheet to 

1.select locked cells (click on this/select this )

2.Select unlocked cells(click on this/select this )

3.format cells 

4.format rows (click on this/select this )

4. format coloumns(click on this/select this )

5.insert coloumns 

6.insert rows(click on this/select this )

set password 

 

More Questions Like This