How to sort excel sheets within a workbook

Microsoft Excel is one of the most used spreadsheet application and has lots of features that makes data processing easier. In excel, we can use macros too and in this tutorial, I'll write about sorting excel sheets within a workbook. Follow the steps given below:
1. Open Excel and create some sheets in the workbook. Rename them and arrange them randomly (I'm assuming an example sheet to start with). I've named the sheets as navy call list.

2. Now right click on any sheets and click "View Code" as shown in the screenshot below.

3. Now "Microsoft Visual Basic for Applications" window will be opened. Click on "Insert" and click on "Module".

4. A new module will be created and a blank editor will appear. Copy and paste the following code in the editor:

Sub Sort_Active_Book()
Dim i As Integer
Dim j As Integer
Dim iAnswer As VbMsgBoxResult
'
' Prompt the user as which direction they wish to
' sort the worksheets.
'
   iAnswer = MsgBox("Sort Sheets in Ascending Order?" & Chr(10) _
     & "Clicking No will sort in Descending Order", _
     vbYesNoCancel + vbQuestion + vbDefaultButton1, "Sort Worksheets")
   For i = 1 To Sheets.Count
      For j = 1 To Sheets.Count - 1
'
' If the answer is Yes, then sort in ascending order.
'
         If iAnswer = vbYes Then
            If UCase$(Sheets(j).Name) > UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
'
' If the answer is No, then sort in descending order.
'
         ElseIf iAnswer = vbNo Then
            If UCase$(Sheets(j).Name) < UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
         End If
      Next j
   Next i
End Sub

4. Now click on "File" and "Close and return to Microsoft excel".

5. Now in Excel, click on "View > Macros > View Macros". It will open the saved macros.

6. In the Macro window, you should see "Sort_Active_Book" macro. Click on it and click "Run". It will open a prompt, click on Yes if you want to sort the sheet in ascending order, click NO if you want to sort the sheet in descending order.

7. That's it, you can see that the sheets in your workbook are sorted.

Keep visiting for more tips and tricks.

Read More

Customize office C2R installation for Office 2013 and 2016 with Office Deployment Tool

MS Office is one of the most used office suit for all the office needs worldwide and it is available in different versions (2013/16/365). In the older versions, Microsoft used MSI installers which had the option to customize the installation of office, it means we could choose which application we want to install and which we don't but in the new versions of office Microsoft we can't customize the installation because Microsoft is using click to run installer for the installation of office. If you ask Microsoft about custom installation, they would say that it's not possible but actually it is possible using the office deployment tool. So in this article I'll tell you how to customize the office installation.
Follow the steps given below:

1. First of all download the offline ISO file of office from office.com/myaccount or from any mirror site (I'll use office 2016 Pro Plus in this tutorial).
2. After downloading the ISO file, mount it or extract it.
3. Inside the ISO file, you will get one folder, "Office" and two files, "autorun.inf" and "setup.exe". Now download the office deployment tool from this link: https://www.mediafire.com/?rg6cmy7y6i18lvq
4. After downloading the Office deployment tool, extract the file and you will get 3 files there, "Configuration.xml", "EULA" and "Setup.exe".
5. Now open the configuration.exe in notepad and you will see some code there which is given below:

<Configuration>
<Add SourcePath="YOUR OFFICE INSTALLATION FILE PATH\" OfficeClientEdition="32">
<Product ID="ProPlusRetail">
<Language ID="en-us" />
<ExcludeApp ID="Access" />
<ExcludeApp ID="Groove" />
<ExcludeApp ID="InfoPath" />
<ExcludeApp ID="Lync" />
<ExcludeApp ID="OneDrive" />
<ExcludeApp ID="OneNote" />
<ExcludeApp ID="Outlook" />
<ExcludeApp ID="SharePointDesigner" />
<ExcludeApp ID="Visio" />
</Product>
</Add> 

6. You can edit the code as per your convenience and customize the office installation. You can replace the source path with your own path where you have kept the office installation files which you got after extracting the ISO. You can edit the value of office client edition to 32 if you want 32 bit setup and 64 if you want 64 bit setup. In the product ID value, you can type the product ID which you are using, in my case it's ProPlusRetail. In the same way, you can edit the language ID also. Now you need to decide which app you don't want to install and then add the app name in the ExcludeApp ID value. You can get the Product ID and App ID details from this documentation: https://technet.microsoft.com/en-us/library/jj219426.aspx#bkmk_productelement
7. Once you are done with editing the xml file, save it.
8. Now open the office deployment tool folder and press and hold the shift key and while holding the shift key, right click in the empty area of the folder and click "Open Command Window Here". Command prompt will open.
9. Now type the following command: setup /configure configuration.xml and hit enter key.
10. That's it. Office installation will begin and only those components will be installed which were allowed in the xml file.
For better understanding, you may watch the video tutorial given below:


Keep visiting for more tips and tricks.

Read More

How to reset Microsoft Word settings to default

Microsoft Word is the most used word processing application worldwide and it is popular on both Windows and Mac operating systems. It is the part of the Microsoft Office package which include other essential office applications. In MS Word, sometimes we make some settings which we forget later and it disturbs the whole formatting of any new document. In this situation we need to reset the word settings to default and there is a very simple method for that but note that follow the steps which I'm giving carefully because we are going to make changes in Windows Registry and if you try to play around with it, your OS might crash and your office application might start misbehave.

1. First of all open RUN box by pressing windows and R keys together.
2. Now in the RUN box, type regedit and click OK. It will open registry editor.
3. Now in the registry, navigate to HKEY_CURRENT_USER > Software > Microsoft > Office > 12 > Word and expand it.
(The number 12 might be different as per the version of office installed in your computer)
4. Now you should see "Data" folder there. Just right click on it and delete it.

5. Now open your Microsoft word, it should be rest to it's defaults and you can use it without any problems.

Keep visiting for more tips and tricks.

Read More

Login box pops up in outlook again and again for gmail accounts : Fix It

In outlook, I have noticed that after configuring a gmail account, the sign in box pops up and asks for the password everytime and even after entering the correct password also, it pops up again and again. So many users think that it's an issue with outlook but NO, it's not the issue with outlook. There is a setting in your google account which needs to be changed to fix this issue. Sometimes, it pops up the following error message also:

To fix this issue, just follow the steps below:

• Open your web browser and sign into your gmail account.
• Now open the Sign-in & Security page of google account, click here to open: CLICK THIS LINK
• If two step verification is ON, then turn it off.
• If "Allow Less Secured Apps" option is OFF, turn it ON.

• Now you may close your web browser and open outlook again, it will not popup for password.

For more tips and tricks, keep visiting my site.

Read More

Easily Fix iCloud and Outlook Error: The set of folders cannot be opened

After the launch of Office 2016, the users of office 365 who installed the Office 2016 upgrade faced so many issues with iCloud and outlook. Contacts were lost, calendars stopped working and outlook launching issues took place. I found two error messages "Cannot start Microsoft Outlook. Cannot open the Outlook window. The set of folders cannot be opened" and "Cannot expand the folder. The set of folders cannot be opened. The information store could not be opened". Both of these error messages appeared because of icloud (sometimes this type of error message pops up if the pst file is corrupted and to fix the issue we can repair the pst file or reconfigure email address in a new outlook profile). So many users are still facing the same issue but the worst thing is that if you call Microsoft support then they deny for any support for icloud issues (you got a good luck if any techy geek handles your call  and resolves your issue in 10 minutes) and Apple support sends you back to Microsoft.

Resolving the issues with iCloud and outlook is very easy and the steps which I'm gonna provide you resolves most of the issues with icloud and outlook. Follow the steps below:

• The first thing which you have to do is to open the icloud windows app and sign out of the app.

• Now Open control panel and search for Mail (Microsoft outlook 2016) app and open this app.
• Click Show Profiles and then double click on the name of your default profile (generally the default name is outlook)
• Now Mail Setup window will appear. From that window, click Email Accounts button and it will show the list of email accounts configured in your outlook.
• Select the icloud email address from the list and click REMOVE button to delete the previous icloud configuration (don't worry, it will not delete your contacts or any icloud information)
• Now click Data Files tab and remove the icloud data file also.

• Close mail app and control panel now and open run box by pressing Windows+R keys together.
• In the run box, type appwiz.cpl and click OK to open Programs and Features.
• From the list of installed applications, search for icloud app and right click on it and click Change and then repair icloud.

• After completing the repair process, it will ask you to restart the computer, just restart the computer.
• After restarting the computer, open icloud app and then sign into your icloud account.

• After signing in, make sure to check the Mail, contacts,calendars and tasks check-box and click Apply. iCloud will start setting the content with the outlook.

• That's it. Open outlook and you will get all the errors fixed and all your missing contacts and calendars etc will be back in outlook.

I hope these steps will resolve your icloud and outlook issues. Keep visiting for more tips and tricks.

Read More

Outlook 2016 stuck on launch screen : Fix it

Windows 10 and office 2016/365 have got so many bugs and even after installing update fixes frequently it seems that Microsoft is not able to completely fix all the issues with it's new software. So many users are reporting that they are facing a strange issue with outlook 2016. After launching outlook 2016, it just gets stuck on launching screen and just says processing and never goes ahead of the blue launch screen. Well, users have reported that they tried everything which a normal user can do like online repair, uninstalling and re-installing office etc but the issue was still not resolved.
Why is this glitch there with outlook, I can't say but to fix this, you just need 4 seconds. Really, I'm not kidding. The fix works with all the Windows 8/8.1/10 devices. For windows 7, this fix doesn't work and you need to follow another process. Let's see how to fix this glitch in outlook.

Outlook 2016 stuck on launch screen : Fix it in Windows 8/8.1/10 computers

• Right click on Start button and click RUN or press Windows+R keys together from your keyboard to open RUN box.
• Now in the RUN box, type outlook /safe and click OK.
• It will launch outlook and will ask you to select profile, just click OK and outlook will be launched in safe mode.
• That's it. Now close outlook and open outlook normally, it will not get stuck on launch screen.

Outlook 2016 stuck on launch screen : Fix it in Windows 7 computers

First try the previous method and if that doesn't work (the second fix works with all Windows versions), then try the following steps:

• Open control panel and search for Mail (Microsoft Outlook 2016) and open it.
• Now click Show Profiles... button.
• Now you will see the name of the mail profile configured in your computer. Generally it's Outlook. Click Add... button and type the name of the new profile as Test and click Ok.
• After that, it will ask you to configure an email address. Just go ahead and configure any email address.
• That's it. Now close the mail app and control panel.
• Now press Windows+R keys together to open RUN box and then type Outlook /profiles and click OK.
• Now outlook will be launched and it will ask you to select profile. Click the dropdown menu and select Test and click OK.
• Outlook will be launched. Now close outlook and then re-open outlook normally, it will not stuck on the launching screen.

In this way, you can fix outlook launching issue without loosing any outlook information. For more tips and tricks keep visiting my site.

Read More

Fix outlook 2016 error for Excel attachments : This file cannot be previewed because there is no previewer installed for it

This file cannot be previewed because there is no previewer installed for it : This is one of the most common issues which Outlook 2016 users are facing. Office 365 users have reported that after upgrading to office 2016, they are getting this error while handling with the excel attachments in outlook. Uninstalling and reinstalling office didn't fix this issue. Online and quick repair also didn't fix this issue.
Well, to fix this issue, you can use a small registry tweak which I'm gonna share here. Just follow the steps given below:

• Open RUN by pressing windows and R keys together.
• In the run box, type regedit and click OK.
• After opening the registry editor, navigate to the location "HKEY_LOCAL_MACHINE\​SOFTWARE\​Microsoft\​Office\​ClickToRun\​REGISTRY\​MACHINE\​Software\​Microsoft\​Windows\​CurrentVersion\​PreviewHandlers"
• Now in the right side panel, delete the string {00020827-0000-0000-C000-000000000046}
• Now create a new string and name it to {00020827-0000-0000-C000-000000000046}
• Now double click on the string and in the filed of value, type Microsoft Excel Previewer and click OK.
• Now exit from the registry editor and open outlook and try to preview your excel attachments. It will not give any error messages.

If you are a lazy guy and don't want to mess with your registry, then no worries, you can download the registry fix from the link ahead and run it in your computer to fix this issue: Download the Fix

Read More

Fix for error code 0X8004FC12 while office 2016 activation

If you are using Microsoft Office 2016 and getting the error code 0X8004FC12 at the time of activation, then here is a solution to fix this issue. In most of the cases, I tried uninstalling office completely and reinstalled it in administrator account and it fixed this issue but if you still face this error code and want to resolve it, then use the following methods:

1. Temporarily disable your antivirus and disable your windows firewall and try activating office, it should get activated.
2. If the above option didn't work, then reset your TCP/IP by running the official fixit tool by Microsoft. Download the fixit from this link and run it. Now try to activate your office program.
3. If you still face activation issue, then open the command prompt with administrative rights and run the following commands:

net localgroup Administrators localservice /add
fsutil resource setautoreset true C:\
netsh int ip reset resetlog.txt

Now restart the computer and then try reactivating office again. It should be activated and you should not see any error messages.
4. If the issue is still not resolved, then follow these steps to enable TLS 1.2:
> Open RUN by pressing Windows key + R
> In the run box, type inetcpl.cpl and click OK.
> It will open Internet Properties, click Advanced tab.

> In the list of the available options, scroll down tillthe end and enable Use TLS 1.2 if it is unchecked.
> Now click Apply then OK.

For more tips and tricks,keep visiting PC Tricks Guru.

Read More