Wednesday, December 28, 2016

How to: Show the Developer Tab on the Ribbon

To access the Developer tab on the ribbon of an Office application, you must configure it to show that tab because it doesn't appear by default.

1. Right click anywhere on the ribbon, and then click Customize the Ribbon.  customize-ribbon

2. Under Customize the Ribbon, on the right side of the dialog box

3. Check the Developer check box.  turn-on-developer-tab

4. Click OK.

5. You can find the Developer tab next to the View tab.  developer-tab

Hope this helps!!

Monday, December 26, 2016

How to load Visual Studio without extensions

All versions of visual studio can be started with a set of arguments.

Using devenv.exe /SafeMode allows you to run any version of visual studio (devenv.exe) in SafeMode that will disable 3rd party plugins.

Using devenv.exe /ResetSettings will restore Visual Studio default settings

Run these commands from Command prompt in admin mode. For additional options refer MSDN for help.

Thursday, December 22, 2016

Useful Visual Studio Extensions

The Visual Studio Gallery is the best place to find tools, controls, extensions and templates to help make your life as a developer easier and more productive.

These extensions are almost always language/platform agnostic and just make Visual Studio better and/or easier to work in. A lot of these owned by Microsoft, Microsoft DevLabs, or Microsoft employees or individuals. These extensions generally fall into language specific or technology specific extensions. That really means they may only b useful to you at certain times.

These are only few that I found useful and helpful. But there are lot out there Visual Studio Market Place.

Thursday, December 15, 2016

How to change Excel column names form A,B,C to 1,2,3 or vice versa

This happens when excel column labels are numeric rather than alphabetic. For example, instead of seeing A, B, and C at the top of your worksheet columns, you see 1, 2, 3, and so on.

2016-12-26_1611

The A1 Reference Style

By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65,536). These letters and numbers are called row and column headings.

The R1C1 Reference Style

Excel can also use the R1C1 reference style, in which both the rows and the columns on the worksheet are numbered. The R1C1 reference style is useful if you want to compute row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number.

To toggle between A1 and R1C1 Reference styles 

  1. Start Microsoft Excel.
  2. On the Tools menu, click Options.
  3. Click the General tab.
  4. Under Settings, click to clear the R1C1 reference style check box (upper-left corner), and then click OK.

If you select the R1C1 reference style check box, Excel changes the reference style of both row and column headings, and cell references from the A1 style to the R1C1 style.

2016-12-26_1615

Visual Studio 2017 RC is now available for download

Microsoft announced the Release Candidate (RC) bits of next major version of Visual Studio named as 'Visual Studio 2017', which is already known to us as 'Visual Studio 15'.

Visual Studio 2017 RC offers productive developer tools and powerful services for individual developers and small teams. Visual Studio Community 2017 RC is a free, fully featured, and extensible IDE for individual developers, open source projects, education and academic research. You can create applications for Android, iOS, Windows and the web. Integrated Azure tools make it easy to create cloud-first applications directly out-of-the-box.

Download Visual Studio 2017 RC

Before starting the download, please note that, it is a Release Candidate (RC) for Visual Studio 2017 and is a web installer that supports the following languages: Chinese-Simplified, Chinese-Taiwan, Czech, English, French, German, Italian, Japanese, Korean, Polish, Portuguese-Brazil, Spanish, Russian and Turkish at this moment.

You can download any of the below editions of Visual Studio 2017 RC directly from Microsoft servers: