Saturday, October 5, 2013

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
 
 
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Preface 2nd Edition

The Kindle edition of this book was liked by many individuals. There are multiple different messages and post on Facebook or in Excel in MS ...

  • About #N/A Error
    This error indicates that a value is not available to a function or formula. Symptom Excel displays #N/A in one or more cells on a workshee...
  • Use of Advance Filter in MS Excel
    Advance filter available in "Data" ribbon is used to filter your data with some complex criteria. To use advance filter option you...
  • How to move texts from Notepad to Column in MS Excel?
    This is also known as "Import a Delimited Text File". Step 1: To import a Delimited Text File, the user has to go to the “DATA” ri...