Tech2 Touch

Author: Aniruddh

  • Hiding or Unhiding Rows and Columns in Excel using Buttons

    Have you seen a excel spreadsheets with + or – symbols which on clicking unhides or hides rows and columns?  You might think that, it is done using Excel VBA. But this is not done by any VBA code. It is a simple grouping features of Excel. It is very useful when you want to display only the summary and show details with single button click. Lets start learning how to group and ungroup in Excel.
    For example you might have data which contains datewise data along with Weekly summary. You can show only the summary and provide the option to user to view the details using the + or – buttons

    Steps to Group Rows or Columns in Excel

    Step 1: Select the cells you want to group it. You can choose rows or columns according to your requirement. In this example i am selecting the rows from A2 to A5.
    Step 2: Go to Data and click on Group and select Group once again.  Your selected rows or columns are grouped.
    Step 3: There will be  + sign when your details are grouped and showing only summary. Where clicking on + sign will expand the group

    Steps to Ungroup rows or Columns

    Step1: Select the rows or columns you have Group enabled.
    Step2: Go to Data and select Ungroup and choose Ungroup.
    Step3: The Group is removed.

    As mentioned earlier, grouping in excel is very useful for presenting the data in good manner. Advantages of grouping is it shows the summary and it required, the all the details are also there. Unlike simple row/column hiding, in grouping you will will have symbol which indicates that, there is a grouping.

    Hope this Excel tips is useful. If you find this guide useful, then please share it with your friends. Any queries and support needed, then leave a comment below.

  • How to Run PHP Scripts Using XAMPP

    We all know that, XAMPP is a free open source cross platform web server solution stack package, which consist mainly Apache HTTP server, MySQL server database and interpreters for script written in the PHP and Perl Programming languages. It is a good tool for learners of PHP, Perl or mySQL. Here is the simple steps to installing the XAMP and start using this for running your PHP scripts.

    Steps to run PHP Scripts Using XAMPP

    1. As said above, you can download XAMPP for free. You can get your free copy from here.
    2. Open the downloaded file and install the applications.
    3. Once installed, run the XAMPP control panel and start Apache and MySQL servers. Enable MySQL if your program needs database.

    running PHP scripts in XAMPP

    4. Click on the ‘Explore’ button on the XAMPP control panel. The new window opens with file explorer.  Search for the ‘htdocs’ folder.
    4. htdocs folder is the folder Apache server points to. In this folder you need to place the  PHP scripts your want to run.
    5. Open the browser and enter the address http:// localhost/yourphpscript.php, where yourphpscript is the script name of your php code.
    6. You can even create sub folders inside htdocs to place and run php scripts. If you are using folders insider htdocs, then you need to enter the following path in the browser address bar.
    http://localhost/foldername/yourphpscript.php where ‘foldername’ is the name of the folder which contains php scripts  created inside your htdoc folder.
    7. Your browser will execute the script and show the output.

  • Type Rupee Symbol in Excel 2010

    Ever since the introduction of Rupee symbol, usage is also increased. When we type, we would like to use Rupee symbol rather than Rs. I have already made a tutorial on how to type rupee symbol in keyboard windows. That post is useful if you want to write rupee symbol in MS word or blogging platforms such as blogger, WordPress etc.

    Recommended Reading:

    Type INR Symbol in Word

    Conditional VLOOKUP in EXCEL

    However, if you want to use Rupee symbol in  Excel 2010, there is a simple way than that. You can easily insert rupee symbol in excel spreadsheet by choosing the currency symbol rupee in the format tab. There is no need to install any update or any change of keyboard layout if you want to use Rupee symbol in excel 2010. Just follow the steps given below.

    Steps to Insert Rupee Symbol in Excel Worksheets

    Step1: Enter the values as desired.
    Step2: Select the cells which you want to insert rupee cell.
    Step 3: Right click and go to format cells.
    Step 4: Select Currency from the category.  In the symbol drop down, scroll down till you see ₹ English (India).

    Step 5: Click Ok. Your cells are converted into currency and it shows along with the rupee symbol.
    Hope this help on inserting rupee symbol in excel. If you have any difficulties, please share in the comment section.

    Note:
    • If you are not able to find English (India) under the symbol, then you need to install the keyboard layout and make it as default.
    • If you want to enter Rupee symbol while entering in the cell, you can use shortcut key Ctrl+Alt+$(4) combination.
    • If you want to update many rows, then you need to use the method which I have mentioned above.
    • This method of typing Rupee symbol works with Excel 2016 also.

    Video guide on how to use Rupee Symbol in EXCEL

  • Free Space by deleting the Windows Old files

    If you have installed newer version of Windows or reinstalled the your windows without formatting the drive, then you will notice a folder called Windows.old. This folder contains the files of your previous Windows files. It is very difficult to remove this folder manually. However you can use Windows built in feature called Disc cleanup to remove this folder. Ideally Windows.old folder is not required as it will be transferred to your newer version of Windows. Having said that, have a quick check on this and confirm that you have the data in your required place.
    Windows Disc Cleanup utility is also useful for removing temporary files,files in Recycle Bin etc . This will free up your hard disc drive. This will be very useful when you start getting notification on disc full.

    Steps to Clean up Windows.Old folder to free the space

    1. Go to ‘my computer’ by clicking desktop icon or by start menu. If you  are using Windows 8, then use Windows+E shortcut key to get My computer. 
    2. Right click on the drive where you have installed Windows.
    3. Click on properties from the menu list.
    4. In the General Tab, you will find a icon called Disc cleanup. Click on that.
    Disc Cleanup windows
    Disc cleanup

    5. Click on Clean Up System files.

    Windows drive cleaning
    Disc Cleanup menu

    6. The new Pop up menu comes out. In that select the Previous Windows Installation,Temporary Windows Installation files checkbox. You can even select Windows Update cleanup and Windows Upgrade Log files.
    7. Click on Ok to start clean up your temporary data.
    8.  It will take few seconds and the Windows.old folder is removed from your disc.

  • HTC One Tutorial On Adding And Syncing Contacts With Email Accounts Or Social network accounts

    HTC One is one of the most popular smartphone in the market right now. It comes with lot of features. Like many other Android smartphones, this phone too supports adding and syncing your data with email accounts and social networking sites such as facebook. The advantage of syncing your data with email accounts or social network sites is you will have a backup of your contacts,calendars and some other information. It will also help you to transfer or access your important data from other devices.

    HTC One Contact syncing

    Adding email account or Social networking accounts to HTC One

    As said earlier you  can sync your contacts, calendars etc from web to phone and vice versa in HTC One. First have your account which you want to sync ready and follow the below procedure.
    1. Go to Settings by sliding the notification panel. Choose Accounts&Sync
    2. Tap on to + to add the new account
    3. From the drop down list, select the account you want to add. It has google, facebook etc. Choose the accounts you want to add
    4. Sign in to your account if want to use your already exist account or create new account.
    5. Follow the onscreen instruction to complete the process.
    6. In settings-> Accounts&Sync , tap the auto sync On/Off to switch automatic sync of all your accounts.