Tech2 Touch

Author: Aniruddh

  • Set Default OS while booting in Multi Boot OS systems

    Some Laptops and Desktops have multiple versions of Windows.  The default operating system is automatically sets to the latest OS we installed.  There are times Primary OS we are using is not set as default one. So below is the steps to set the default Operating systems. Microsoft is providing a simple and very easy way of setting the default version of Windows to boot. So here is the guide, on how to set default Windows OS for booting.
    Change the default OS
    Steps for Setting default OS while booting:

    • Double click on the ‘My Computer” icon
    • New screen comes up. In the new screen select ” System Properties” button
    • Then select “Advanced system settings” link from the left panel.
    • Click on “Advance” Tab
    • Click on “Setting” button under the “Startup and recovery” Section
    • Select the default Operating system which needs to be set as Default OS  from Default operating system drop down menu.
    • Click ‘OK’ to Save.

    Steps for Setting default OS while booting in Windows 7:

    • Right click on “Computer” Icon which available in start menu right side.
    • Click on ” Advance System Setting”
    • Go to “Advanced” Tab.
    • Click on “Setting” button under the “Start up and recovery” Section
    • Select the default Operating system which needs to be set as Default OS  from Default operating system drop down menu.
    • Click ‘OK’ to Save.

    Note:

    • This will work only if the multiple OS are Windows based OS like Windows XP, Windows Vista or Windows 7. This will not work if you are using Windows and Linux OS.
    • These setting needs to be changes in the Latest OS installed on your system. For example if you have Windows XP and Windows 7, then you need to set this settings in Windows 7.

  • Using Loops in Excel VBA

    Looping is used to repeatedly running a set of codes till it completes given condition. The loops are the fundamental component of any programming Language. In Excel VBA too there are many loop constructs. Let us have a close look into basic loop constructs.

    Basic Loop constructs of Excel VBA:

    • For…..next
    • Do……While
    • Do……Until
    • While……….Loop
    • For Each……Next
    For……Next Loop:

    This loop is used when there is a need to execute a statement or a block of statements for certain number of times.
    Example for For…..Next Loop:
    For i =1 to 10
         Total=Total+i
    Next i

    This code will calculate the sum of numbers from 1 to 10.  In this example statement ‘Total=Total+i’ repeats 10 times.  ‘i’ and ‘Total’ are the variable used in the code.
    In this example for For….Next loop following steps took place:
    This loop will work as long as the value of ‘i’ is more than 1 and less than 10.
    1. The For loop initializes the value of ‘i’ as 1. As 1 is less than, 10 the next statement executed.
    2. The code   ‘Total=Total+i’ is executed for first time.
    3. The code ‘Next’ increments the value of ‘i’ by 1
    4. The control shifts to the begining of the loop, where the value of the variable ‘i’ value is checked
    5. Till value of ‘i’ is less than 10 step 2 and 3  are executed.
    6. As soon as value of ‘i’ becomes more than 10  the loop terminates. 

  • Removing Duplicates in Excel

    We sometime look for easy way to remove duplicate  entries from a large table without any filters or complicated formulas. Starting Office 2007, Microsoft added a direct method to remove duplicates from a range.  There is one shortfall in this method which I will describe later.

    • Use mouse or keyboard arrow keys with “Shift” button pressed to select the area which contains duplicate content.
    • Click on “Data” tab of excel and click “Remove duplicate” button in the multi function tool bar.
    • A dialog box pops up. In the dialog box define the columns of the area to be included in the comparison of individual rows. All cells of the two rows should thus not display the same content due to which the rows become duplicates of each other.
    • In the column field of dialog box, remove the check marks in front of the columns which needs to be ignored during the comparison and click ‘OK’.
    • The duplicates in the columns of excel has been removed.

    Note: If all the columns are not included in the comparison(when there are obvious differences between individual row),  Excel always first top most row out of the rows that have been identified as duplicate. This is needs attention when the previously excluded cells are required later.

    This method short fall is that, you will not be able to see which cells has duplicates. If you want to know which cells having the duplicate values, go to “Conditional formating” and select “Highlight Cell Rules”. In that, choose “Duplicate Values”.  In the pop up select color which you want to see for the duplicate values. Now, use a filter by color and select the color you have opted for duplicats. It will show all the cells with duplicate values. Once found, you can decide on which data need to be removed and which needs to be retained.

  • Rotating Tables in Excel

    After we create a  tables in Excel, we will realize that the columns could be better as rows and vice versa. So in this post we will have a look into excel tip which describes how to rotate tables or swapping columns and rows in Excel. This tip will work on Excel XP, Excel 2003, Excel 2007, Excel 2010. Swapping of columns and rows in excel using this method is very simple and it does not changes the data.

    How to Swap Row and Column in Excel Sheet

    Follow the steps given below, to perform swapping of rows and columns in a range.

    Swapping of rows and Columns in Excel

    • Select the area whose column and rows needs to be swapped.
    • Right click the selected area and select “Copy” if you want to create a new table keeping the original or Select “Cut” if you want to entirely replace the Table.
    • Select the cell where the table should be placed.Ensure that area where the we want to insert the Table should be the same as original.
    • Right click on your mouse or keyboard shortcut, select “Paste Special”.
    • A pop up dialogue box appears. Select the option “Transpose” which is places bottom right corner.
    • Select “OK”. Done. Your Table rows and columns swapped.

    If you are facing any issue for transposing the rows and columns then, please leave your issue in the comment section below.

  • Finding the Last Row in Excel using Excel VBA

    In excel there are situations where we need to find last row of an sheet. This can achieved by defining a variable and assigning the last row value to the variable and using offset property to find the last row.

    Method 1: Declaring the variable and assigning the last row to the variable.
    Eg:
    Dim FinRow   ‘Finrow is variable which hold the value of last row.
    Finrow=Range(“A65536”).End(x1Up).Row
    Now Finrow variable contains the last row number in Column “A”

    Now if you want to put total in the last row of Column “A” then use
    Range(“A”&Finrow+1).Value=”Total”