Excel Tricks: Convert Lowercase to Uppercase in MS Excel with Shortcut

Convert Lowercase to Uppercase in MS Excel

It is not possible to directly convert upper case to lower case letters and lowercase to upper case letter in Excel itself .

It may be possible with help of some macros. But for time being we can follow a shortcut procedure to accomplish the task.


Follow the below procedure to convert lowercase to upper case and vice-versa in MS excel.


1.Copy the row or column of text which you need to convert Small to capital letters or Vice-versa.

2.Now open MS word or MS outlook (HTML view)

3.Paste the data that you copied in MS excel

4.Select All the data by pressing Ctrl+A



5.Now press Shift+F3 , If only first letter is changed to different case, again press Shift+F3 one more time.

6.Now all the selected data will be converted into alternate case.

7.Now select all the data (Ctrl+A) and copy it.

8.Go back to excel, select the first row or column where the data should be entered and Paste the data (Ctrl+V)

9.You can choose Paste with source formatting and formula to get back the same settings as it was initially being set.

Adsense : Wire Transfer | Bank Commission Details

Google Adsense Program has changed the payment system for most of the countries from cheque to wire transfer method.

As the delivery of cheques to the publishers requires lot of time to deliver, Google implemented the Wire transfer system for quickest transfer of monthly payment.

Google Adsense make the payment at 21st of every month and those who chose their mode of payment as Wire transfer will receive the money within 3 days (most of the case) after the transaction done by Google.

Changing the Payment method to Wire transfer:

• Go to your Adsense account page. Click Gear Icon-Payments - Payment Settings - Payment method - Add a new payment method as Wire transfer
• Add the Bank Details like Account number, Your Name as registered in the bank account , IFSC code of the bank , SWIFT-BIC code of the bank etc.
• You can get the SWIFT BIC code from your bank customer care.
• Note that you would be able to add the payment method once you reach the threshold limit.

Bank Commission for Wire Transfer: 

• As it is familiar that the minimum threshold value is 100$ for Adsense payment , the commission fee for wire transfer is comparatively less that varies from bank to bank.
• For example, the commission fee for Standard Chartered Bank, India per wire transfer transaction is 33 INR that is approximately equal to 0.5 $ 
• Generally it is reported that the commission fee vary from 0.5$ to 1$

Excel : Not able to Pick Objects, Chart in MS Excel

Difficulty Faced:

While working in Excel workbook, Sometimes we cannot pick any objects like charts, Pictures, Autoshapes etc

Troubleshooting Method :

Method 1 : 

• Go to Find and Pick Select Objects option. Now go and try to pick the objects you want to select.
• If still you are not able to select the objects like auto-shapes, charts and other picture objects try method 2.

Method 2:

• Check whether your Excel workbook is in shared status. If it is in shared status, near the file name of , it will be displayed as shared with square brackets as shown below.

• Now Go to Review - Share work book - Uncheck the sharing option - save the workbook.
• Then try to select the objects .

Caution: Ensure no body is using this file while you are removing the sharing status. If anybody is using this file at the same time, request him to save and close the file to proceed with method 2.

Tips :

• If you want to select more than one objects at a time, Press ctrl key and select the desired objects.
• If you want to deselect specific objects, you can click the same selected objects once again to deselect it.

Google Chrome : Hidden Game without Internet connection in Chrome Offline

Have You ever noticed a default offline game is hidden inside our Google Chrome Browser.



Here is the trick to how to open that classical dinosaur jump game which is hidden in every Google Chrome Browser for both Desktop and mobile versions.

Step 1: Disconnect your Internet connection and mobile data connection. Because, this game works only when there is no internet connection.

Step 2: Open your Google Chrome Browser.

Step 3: Type any web address like yahoo.com and press Enter or GO

Step 4: Now a message screen like below will be displayed with a dinosaur symbol and a message ,

Unable to connect to the Internet. Google Chrome can’t display the webpage because your computer isn’t connected to the Internet.

Step 5:Just press Space Bar for Desktop version or Tap on that dinosaur for Mobile version. Hurray.. the Classical Jump Game Started now and you can score as high as you can.



You can surprise your friend by showing this default offline game hiding inside every chrome browser.

UG NX : Creating a Simple L Bracket with two fixing holes :Tutorial

Before start creating the component, you have to make a quick plan in your mind that how you are going to make the model.



For example, for the below L Bracket, we are going to draw a L Shaped, 2D sketch with required dimensions.
Extrude it to form a 3D L-shaped bracket. Finally to make fixing holes using hole feature.

• Open UG NX software. Go to File - New - and select model. Give a new model name called Bracket.prt . Remember where this file is stored in your computer.
• Once you created the new file, ensure that you are in Modeling Application.
• Go to Insert -  Sketch
• Now the tools that are needed to draw a sketch will appear in the bottom of the screen.
• Using line, arc curves create a L shaped sketch roughly with your own dimensions.
• Using Inferred dimensions, mark the dimensions. Marking all the necessary dimensions is known as constraining the sketch.
• Once you drawn the L-shaped sketch, Click on finish Sketch.

• Go to part navigator which appear in the left side of the screen. Here you can find the history of the component. Now you can see a Datum coordinate system and Sketch in the history tree.
• We are going to convert this sketch into a 3D model. Go to Insert - Design Feature - Extrude
• Now a form named Extrude will open in the screen. You have to fill from top to bottom and the * marked parameters are necessary to finish the operation.
• Select the curves of 2D sketch . Press Enter and enter the extrude start length as 0 and end length as some appropriate value. Press OK
• We are almost done with the bracket . Only thing remaining is Fixing holes.
• Go to Insert - Design Feature - Hole
• Choose the type of hole as simple hole.Select the surface you want to make the hole and specify the center position and click finish sketch.
• Change the Size of the hole dimension as you wish. Press OK

Now we have obtained the L-shaped bracket with two fixing holes.

UG NX - Modeling : Introduction :

UG NX - Modeling : Introduction :

In Modeling Application we can design 3D models using commands like Extrude , Revolve , Sweep, Variational sweep , Adding hole, Embosses, Darts etc and Extending surfaces, Trimming Surfaces.
Apart from these basic operations some of the advance operations are available to accomplish some complex features of a component.



The file and storage concept is similar to usual excel, word documents. So ,if you are familiar with those file storage concepts, then you will feel easy to work with creating, saving and editing UG files.

If we want to design a 3D component, we have to start with a 2D sketch. Every design software work in this way.

Step 1: Create a 2D Sketch
Step 2: Convert in to 3D model using options available in the CAD software.

For example if you want to create a solid 3D cube with a hole,

Step 1: Sketch a 2D square
Step 2: Extrude it into a 3D cube
Step 3: Sketch the 2D circle of hole diameter in the surface of cube.
Step 4: Extrude with remove material option to get the hole.

This is a simple illustration and this methodology applicable even for a complex part.

We will start with a simple component which explains some basic tools of 2D Sketching followed by 3D operations like Extrude, revolve etc.

As a exception, there are 3D curves , which can be converted into A-surfaces (smooth finished surfaces)

User Interface of Unigraphic NX | Comparing Ideas NX interface

UG NX is the advancement of I-deas software. Because of the robust nature of I-deas and to overcome its drawback to compete with other software like CATIA, ProE, Solidworks etc , Unigraphic NX was developed.

So , those who were worked in I-deas may find little easier to cope up with this software.



The User Interface used in latest versions of UG NX is called ribbon interface. It is similar to the interface that is used in Microsoft Office Tools like MS word, MS excel etc.

Ribbon Interface :

What is Ribbon Interface ? It simply indicates that most of the options will be available in the screen itself as a set of icon groups. We don't need to waste time in searching the options inside any menu lists.

In addition to the icons available in the screen, a classic way of menu lists also available in UG NX.

So , you can find the same option in two or three places. This is just to enhance the user experience and to improve the easiness to work in the software.