Excel
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
21 January 2014
I intend to create suppliers bank details in excel sheet I need a solution that is how to lock account number in a cell because if we mistkaely click any cell thus changed any account number this will lead to credit to wrong account number this is being used for neft transactions to the bank for our regular banking insteda filling challan form
please send me a solution at he realiest
please send me a solution at he realiest
22 February 2014
Hi,
Select the entire worksheet--->Right click-->format cell--->Protection Tab---> Remove the selection from "Locked Option".
Block / select the entire column which is containing all account numbers---->Right-click--->format cells--->protection tab--> select locked option which you have removed in the previous step.
now go to review tab--->protect sheet with some password. That's it.
You can type the data all other places except the column where account number is displayed and the number is secure.
Select the entire worksheet--->Right click-->format cell--->Protection Tab---> Remove the selection from "Locked Option".
Block / select the entire column which is containing all account numbers---->Right-click--->format cells--->protection tab--> select locked option which you have removed in the previous step.
now go to review tab--->protect sheet with some password. That's it.
You can type the data all other places except the column where account number is displayed and the number is secure.
22 February 2014
Hi,
Select the entire worksheet--->Right click-->format cell--->Protection Tab---> Remove the selection from "Locked Option".
Block / select the entire column which is containing all account numbers---->Rightclick--->format cells--->protection tab--> select locked option which you have removed in the previous step.
now go to review tab--->protect sheet with some password. That's it.
You can type the data all other places except the column where account number is diplayed and the number is secure.
Select the entire worksheet--->Right click-->format cell--->Protection Tab---> Remove the selection from "Locked Option".
Block / select the entire column which is containing all account numbers---->Rightclick--->format cells--->protection tab--> select locked option which you have removed in the previous step.
now go to review tab--->protect sheet with some password. That's it.
You can type the data all other places except the column where account number is diplayed and the number is secure.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- REGARDING GST ON COMMERICIAL PROPERTY
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- GST on export of services and Input Credit
- TDS U/S. 194NF
- ITC temporary reversal and reclaim
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Applicable TDS rate for sale of property in Nov 2024
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
- Strategical investment in Public listed company
Trending Online Classes
CAclubindia
