Do you want to make your spreadsheet read-only for others? Let's know how to mark the file as Final!

Very often you share your spreadsheet with others and you want that they can only see the content in "Read Only" mode. That means you do not want them to edit or reuse your file for some other purpose.

For this, you often protect the file and make it password protected/ read only. But in Excel there is another option of making your file "Read only" for others and also you can activate the option - that your content is FINAL and you don't want anyone to update the same.

To do this, you have to visit the File option and click the "Protect Workbook" dropdown as shown below. Post that you will get an option called "Mark as Final". This will let the users know that this is a final version and thus read only.

For more details on Encrypting your file, protecting particular cells, columns and formatting etc. Please get in touch with me at Samrat.biswaas@gmail.com.

Samrat Biswas

Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.

--------------------------------------------------------------------------------------------------------------------
Reach me @ +91 8095039316
 

How to recover unsaved files in MS Excel 2013?

Many a times you do some calculations in a spreadsheet or prepare a small report for some use. After creating that, either you realize that this work is of no use in future or accidently you close the file without saving it. Then in couple days time you realize that, had that been with me it would have been very helpful. Isn't it?

In MS Excel, there is an option of recovering your unsaved files. To do this, open any spreadsheet and go to the File option. There you click the "Manage Versions Option" as shown below.

 

Click the "Recover Unsaved Workbooks". This will open the folder location where unsaved Excel files are stored automatically.

And there it is!! You have your unsaved file stored here. For more details on this you can reach me at samrat.biswaas@gmail.com or +91 8095039316.

Samrat Biswas, MOS in Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.
--------------------------------------------------------------------------------------------------------------------

What are Sparklines in Excel?

Sparklines

Sparklines are mini charts placed in single cell, derived from a range of data from your selection. There are three different types of Sparklines.
a) Line
b) Column
c) Win/ Loss

Line Sparklines

 

Column Sparklines

 

Win/Loss Sparklines

 

For more details on Sparklines, how to do this and its proper usage you can reach me with your questions.

Samrat Biswas, MOS in Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.

-------------------------------------------------------------------------------------------------------------------
Reach me @ +91 8095039316

Know how to load Developer's ribbon in Excel 2013!

What is Developer's Ribbon?

Developer's ribbon has tools like Code, Add-Inns, Controls, XML and Modify. This is used for creating and editing macros, inserting VB controls etc. By default this ribbon is not loaded by itself when you start your Excel. You have to check this option; to have this in your default ribbon.

 How to do this?

After opening a blank excel spreadsheet, click File menu and then click Options. This will pop up the dialog box of Excel Options as shown below.

 
 

Visit Customize ribbon option in the left hand side and check the developers tab option in the main tab column in your right hand side. And then click Ok.

 

For more details on the individual tools of developers tab please reach me at Samrat.biswaas@gmail.com.

 

 

Samrat Biswas, Microsoft Certified in

Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint. Contact No: +91 8095039316/ +91 9900070933