How to Microsoft office File (I.e. Excel, word, power point, Access ) mack Read only ?

The Object of this block :

After working done in any MS office file, we can save it as read only, so in future nobody can change it.

In MS office, A Option Call "Mark as Final" will convert file normal file into Read-only file.

How to Convert Normal MS Excel Workbook into Read-only Workbook Using " Mark as Final".

1. On the File tab,

2. Click Prepare > Mark as Final.

3. Click Ok.

Now, This Excel Workbook is Read Only and No one can Change it.

If, You Require to Convert Read-only Workbook into Normal Workbook (i.e. Editable Workbook)
Follow Above Three Step Again.

Grow The info.

Comments

How to Stop Back Dated Entries In Tally ?

The object of This Block : You Can Stop Create/alter Entry in Tally from Date Specified By You. (I.e. you are in 18-19 and you want to stop create/alter entry before 31.03.2018) Block of Info : Useful Term: "Current Date for tally": Menace "Date of Last Voucher entry in tally" (you can see on Gateway of tally Also) We are Require to Mack Following two type of login security : 1) Admin Login : (Admin name and Password) 2) User Login : ( User Name and Password) Let’s, Do it : 1) To Set Admin Name and Password · Gateway of Tally > Co. Info (Alt + f3) > Alter. · Select Company name · Mack “yes’ to ‘Use Security Controls” · Set: “Name of Admin” and “Password” · Reload Company By using Above “Name and “Pas...

Excel Ctrl +

Object of This Block: To Get Knowledge of MS Excel “Ctrl + Letter” Shortcuts, That will Increase our work speed in excel. Ctrl + · Ctrl + A - selects the whole worksheet or the whole date · Ctrl + B - bold the selected data · Ctrl + C - copy the selected data · Ctrl + D - copy the above cell data in current cell · Ctrl + F - open Find dialog box · Ctrl + G - open Go To dialog box · Ctrl + H - open the Replace dialog box · Ctrl + I - italics the selected data · Ctrl + K - open Insert Hyperlink dialo...

Name Rang in Excel and it's use.

Object of This block: How We Can Define Name Range in Excel , How it's Useful to us. What is Name Range? Name Range: Giving One Custom Name to One or More than One Cell in Excel . Ex. A2 = net profit C1:C10 = productlist How to Create Name Range: 1. First Select One or More Cell Which of Those, You want to Give a Name. 2. Go to Name box 3. Give a Name to Selected Cell or Cells. ( In this C1:C10 = Productlist ) The following Characters are not allowed as Name: Space is Not Allowed as Part of a Name. Names can't look like Cell addresses, Such as A$2 or A2C2 C, c, R, r -- Can't be Used as Names -- Excel Uses Them as Selection Shortcuts Names are not Case Sensitive. For example, PROUCTLIST and productlist are treated as the same name. Now, We Understand Use of Name Range: 1. On data validation: While Creating a dr...

Blocks of Info

Search This Blog