Author: Aniruddh

  • Adding Page Numbers in MS Word

    We all know that what a time consuming task it is to try to put the unnumbered pages of a long document back in the right  order if they unorganised. Dont let it happen to you, when you create a long documents in MS Word next time. Add page numbers to MS Word documents to make your life easier. It is very simple task. In this MS Word Tips, we will see how to insert page numbers and customise it.

    How to Insert Page Numbers in MS Word

    Step 1: On the insert Tab, click the Page Number tool in the Header & Footer group. On the list, point to the location where you want the page number to be displayed. You can select header, or footer. Even you can choose the placement, right, left or even center.
    Step 2: Click the page-numbering  design you want in the gallery that appears.
    Step 3: You can customise  numbering format or the way the pages are numbered in a multisection document. To do this, click Page Number again, and choose Format Page Numbers from the displayed choices.
    Step 4: In the page Number Format dialog box, select the numbering format you want.
    Step 5: If you have more than one section in the MS word document, specify whether you want the page numbering to be continuous or to restart at the beginning of each section.
    Step 6: Click Ok.
    Step 7: If you dont like the way the page number looks or the where its positioned, click  Page Numbers, choose Remove Page Numbers and then choose a different numbering format.

  • How to Reset Nokia Lumia 620

    Nokia Lumia 620 is budget Windows Phone 8 running smartphone. It is very good performance generally. However, at times it hangs or freezes. If it is a occasional, then you can do soft reset on Lumia 620 which does not removes any personal files. This is the easiest method. However, if problem continues, then there is only one option, that Hard reset of Nokia Lumia 620. Below is the steps to reset Nokia Lumia smartphone.

    Soft reset Nokia Lumia 620

    Just press and hold Volume down key and power button for 2 seconds. The device will restart. This will be useful, if your Lumia 620 gets freezed.  It will clean up temporary files and free up memery. The performance increases.

    Hard reset Nokia Lumia 620

    At times, the Windows phones starts to hang or freeze oftenly to an extent we can use the device. It is highly irritating or frustrating to use a slow devices. In this scenario, we can use hard reset of the smartphone. Do note that, you will lose personal data and other updates you have installed on your smartphone when you perform hard reset. So back Nokia Lumia 620, before doing the hard reset.

    Hard Reset Nokia Lumia 620

    Steps to be followed to perform Hard reset Nokia Lumia 620
    Go to Settings
    About Phone
    Tap on the reset your phone
    You will get a notification on the deletion of all data from the phone. Click on Yes to continue the reset.

  • How to Update Moto G To Android KitKat

    Moto G is one of the sensational game changing smartphone. Rich features and very affordable in price. Dual sim, 4.5 inch 720p HD screen, quad core processor and pure Android are key features of the device. The price of Moto G starts from just Rs.12,500.
    Out of the box Moto G runs on Android 4.3 Jelly Bean. However, Motorola has released Android 4.4.2 Kitkat update to international variant long back and just two days back it started rolling out Kitkat update to Dual sim Moto G smartphone. Here is the quick steps to update Motorola Moto G smartphone to Latest Android Kitkat update.

    Update Moto G

    How to Update Moto G to Android 4.4 Kitkat Through OTA(Over The Air) Update

    • Go to Apps
    • Touch settings
    • Touch About phone
    • Touch System updates.
    When an update is available, you will be notified about the firmware update. Just follow the onscreen instructions to complete the installation. Once the installation complete, the device needs to restart to complete the process. No need to worry on losing the contacts, messages or any other data as it is official update and doed effects any data.

    How to Update to Android 4.4 Kitkat Through Moto G PC suite

    Updating through OTA is easy method. However, if you have slow internet connection or internet disconnection, then it is wise idea to update Moto G via PC suite. Motorola offers free PC suite for Moto G in the name of Motorola Device Manager. Here is the steps to update Moto G firmware.
    To Update Moto G through PC suite you need to have following requisites.

    • USB Cable
    • Motorola Device Manager PC suite
    • 2GB of available disk memory
    • Broadband internet connection
    Updating through Moto G PC Suite
    • Connect your device to the computer with a USB cable.
    • If it’s your first time connecting, you will be notified that device drivers are being installed on your your computer.
    • After your first connection, you should see a message about updates when you connect. If the update message does not appear, you can check for updates manually by clicking on the Motorola Device Manager (MDM) icon, Image. You’ll find it in your computer’s menu bar or the system tray. Then click Check for device update.
    • MDM will tell you if an update is available.
    • Simply follow the instructions on the screen to update your device.

    MDM regularly checks for updates when you connect your device to computer. However you can  check manually too any time by using the MDM icon Image . Just remember, your device has to be connected to computer to do this.

  • How to unhide first row or Column in a Excel Worksheet

    At times, in Excel worksheet the first row(Row 1) or first column(column A) doesnot show up. It is tricky to unhide  the first row or column as there is no easy way to do it. Based on the situation, you need to apply different method to access the first row or column. So here is the quick possible reasons for hidden first row or first column.
    Reasons and Solutions  for Hidden First Row or First Column

    Hidden First row or Column
    1. The row or column is hidden: Most of the time we might have hidden that row or column. Unhiding first row or column is as said earlier is not easy. For doing so, simplest method is to select whole sheet and right click and select Unhide.
    2. Another possibility is freezed columns or rows: If a excel worksheet has freezed row or columns, then also you will not be able to access some rows and column. Try Unfreezing by going to View->Freeze Panels.
    3. Row or Column size reduced to very small: Some excel worksheet which we get has very small sized row or column which we cannot see the row or column. In this scenario, select entire worksheet by selecting entire row. Right click and increase row height. If it is column, then select columns and enter higher column width.
    Other solutions for unhiding first row or column:
    1. In the Name Box next to the formula bar, type A1 and then press ENTER.
    2. On the Home tab, in the Editing group, click Find & Select, and then click Go To. In the Reference box, type A1 and then click OK.
    Hope these steps helped you to unhide your excel worksheet first row or column. Still if you have any problems share it in the comment section below.
  • How to use Moto G as modem to connect to PC

    Motorola Moto G is one of the best mid range smartphone. It is not as powerful as the most of the flagship smartphone in terms of the specification but in real time performance is outstanding for the price it is available. The price of Moto G is $179. The Moto G runs on Android Kitkat OS and powered by Dual core processor with 1GB of RAM. In this post let us see how to use the device as modem to connect to PC. This method of using Moto G tethering works with both the editions of Moto G.

    Read: moto g 2nd generation pros and cons & Pros and Cons of  Moto G .

     

    Motorola Moto G as modem

    How to use Motorola Moto G as modem to connect to PC

    To use Moto G as modem, you need to first enable the USB tethering. To do this follow the below steps.
    Step1:  Touch to the Apps.
    Step 2: Go to Settings.
    Step 3:  Tap on to More.
    Step 4:  Go to Tethering & Mobile Hotspot.
    Step 5:  Check the box for USB Tethering. Do note that, if you enabled WiFi or if USB cable is not connected, then USB tethering option will not be enabled.
    Once the tethering is enabled, Moto G works as a modem to use internet from PC. You can disable USB tethering by unchecking the tethering & Mobile Hotspot.
    Note:
    1. Moto G Tethering works with Windows Vista, Windows 7 and popular linux distributions such as Ubuntu, Fedora etc.

    2. Even you can also use Motorola Moto G as WiFi Hotspot to connect to any WiFi enabled devices using the Mobile Hotspot feature.

    How to use Moto G as WiFi Hotspot

    • Enable the mobile data on your Moto G.
    • Go to Settings->More–>Tethering & Mobile Hotspot
    • Check the Mobile Wi-Fi hotspot to enable WiFi Hotspot.

    Customising Moto G WiFi Hotspot Settings

    • Go to Settings->More–>Tethering & Mobile Hotspot
    • Tap to Set up Wi-Fi Hotspot.
    • Enter or Edit the Network SSID, Security Type and Password according to your wish.
    • Tap Save to save the settings.

    Moto G and Moto G 2nd Generation are the best priced well features smartphones available today. The timely Android upgrades, makes this device one of the most attractive phone to buy.

    Video Guide on How to Use Moto G as Wi-Fi Hotspot