How You Can Add Macro Shortcut to Microsoft Office Word?

A macro is basically a code which runs in the background of the MS Word application. With macros, you can open documents, format documents, run formulas or you can perform anything which you type on a keyboard. In this blog, you will read how you can add Macro Shortcut to Microsoft Office Word. In case, for details the user can visit to the site via www.office.com/setup.

Create a Macro in Microsoft Office Word: office.com/setup

First, you should go to the “View” option and then just under “Macros” you should choose “Record Macros” in Word 2007 and above. And in Word 2003, you should click on Tools and then choose Macros and then you should select Record Macros. After this, you should assign a name for your macro in the “Macro name” box. Then, you have to click on the template or document in the “Store macro” box in which you wish to store the macro. Here, you have to type a description for the new created macro in the “Description” box. At this point, you have to press on “OK” button to begin the macro recording. Remember, the macro will record all your keystrokes and also the mouse clicks. Now, you have to perform the actions which you wish to replace with the macro. When, you finish typing your documents and the action which you want to record. After this, stop macro recording for this use: you have to click on “Macros” and then select “Stop Recording”. Here, your macro will be saved. If you want to run the macro, you should go to View and then select Macros. Now under Macro Name, you should click on the macro which you want to run. Then, you should click on the “Run” button.

To Assign Keyboard Shortcut to an Existing Macro:

You should choose File and then select Options. After this, you should click on “Customize Ribbon”. Now, you should click on the “Customize” button which is next to “Keyboard Shortcuts”, just at the bottom of the dialog box. Here, you will see the “Customize Keyboard” dialog box appears. Now in the Categories list, you should scroll down to the bottom of the list and then click on “Macros”. You will see the list of the macros in the current document which appears in the Macros list.

If in case, you cannot see the macros in the list then you should check out the document name in the option “Save Changes in” which is located below the macros list option, just give the correct document name on which you had created the macros. Now, you have to select the macro for which you want to assign the shortcut. Then, you have to type the Shortcut Key in the “Keyboard Shortcut” option which is there in the window. At last, you should tap on “Close” option.

Read_More :- Complete Information About PowerPoint Shortcut and Hotkeys

The above method will help you to add Macro Shortcut to Microsoft Office Word. If the user need more information, then they can call the customer care of Microsoft via www.office.com/setup.

When Discord is Not Connecting! What to Do?

Discord is basically the group chatting app in which you can make voice; video and text message to your friends and colleagues. It is available for Mac, PC, IPhone and Android devices. But if Discord is not connecting properly then it will prevent you from sending messages and from accessing the content which is downloaded in the app. Hence, in this blog you will read the solution if Discord is not working properly. If you need technical support then you can contact to the customer care of Microsoft through office.com/setup.

Causes for Discord Not Working:

The causes of Discord not working are high volumes of traffic, if there is internet connectivity issues and if there is corrupted app data.

Solution to Fix Discord Not Connecting Issue: www.office.com/setup

  1. The first thing you should do is to check the Discord’s status and services. Because it is possible the services may be down that is why it is causing the issue. You can check the current status of Discord through DiscordStatus.com.
  2. You must check your internet connection as it might be possible that your smartphone is out of range and not getting connectivity properly. So, you must check internet connection on other apps like Facebook or Twitter to verify it.
  3. You should disable Airplane Mode because the Airplane Mode disables all the cellular and internet connections.
  4. You should temporarily disable Wi-Fi on your iPhone or Android smartphone because may be you are using a dead Wi-Fi signal. And just use your cellular network to check that now you can connect to Discord or not.
  5. To fix the issue, you should properly close the app and wait for some time and then again reopen it.
  6. You should update your Discord app so that it can connect to the Discord servers.
  7. You should also update your operating system as it fixes internet connectivity errors and make your device more secure and efficient.
  8. You can restart your device as this fixes a wide variety of technical issues as well as connectivity issues.
  9. In case, you are using Windows 10, then you should right-click on the Discord app’s icon in File Explorer and then just select Troubleshoot compatibility. This will quickly scan your device and the app’s files and immediately fix the error.
  10. You should turned off the proxy server settings as it can disrupt a connection to Discord.
  11.  If you are using a VPN internet connection, then it can also affect Discord so you must turn it off temporarily in your device.
  12. You should change your DNS servers and just set the Preferred DNS Server to 8.8.8.8 and the Alternate DNS Server to 8.8.4.4. As this might fixes the error.
  13. In spite of the above solutions, if you are still facing the issue then you should delete the Discord app from your device and again try to reinstalling it.

Read More- How to Troubleshoot Common IPhone 8 Issues?

The above method will help you to fix the issue if Discord is not connecting. But if you still face the issue, then you can contact to the technical team of Microsoft for help via office.com/setup.

What are the Tips to Repair and Recover XLS/XLSX File?

If the user is facing problem in recovering corrupt XLS files then you should read this blog. In this, you will get the tips to repair and recover all your corrupt XLS files in the easy way. In case, you need support then you can contact to the expert of Microsoft Office through www.office.com/setup.

Solution To Fix XLS/XLSX File : office.com/setup

 1: Run Excel Inbuilt Tool “Open and Repair”:

You should click on “Open” option in the File Menu. Now from the list, you have to select corrupted XLSX file. Here, from the drop-down list of the “Open” tab,  you have to select “Open and Repair”. At last, you should click on the “repair” button just to repair the Excel file.

2: Use Microsoft Office Tools:

 For this, you have to go to Start menu and then just select All Programs. After this, you should select Microsoft Office and then choose Microsoft Office Tools. Now, you have to select Microsoft Office Application Recovery. From the dialog box, you have to choose Microsoft Office Excel. Here, you have to click on Recover Application.  This will take few minutes. After this, you have to respond the message Send Report To Microsoft prompt. Here, the recovery tool will close Excel file and you have to restart it. Now, it displays a list of recovered corrupted XLSX files.

3: Recover Data Only:

First, you have to click on File option and then select Open option. After this, you have to move to the folder which contains corrupted XLSX file. Here, you have to right-click on the corrupted XLS file name and then just click on Copy option and after this, press on Cancel option. At this point, you have to click on File button and then select New option. Here, under New option, you have to select Blank workbook. After this, you have to select corrupted XLSX. Now, in the Update Values dialogue, you have to click on OK button. Then, you have to select the sheet in select Sheet dialogue and after this, just click on OK button. Here, you have to choose the cell and then click on Home option and choose Copy option. You should select the area of the data in the original workbook. After this, you should click on Home and then choose Paste option. Then, just click on Home option and then select Copy again. At last, you have to click on Home option and then on the below arrow Paste and then click on Values under Paste Values.

4. Restore Lost Excel From Recycle Bin:

For this, just go to the Recycle Bin folder and then you have to search for your deleted xlsx/xls files. When you get it, just right-click on it and then choose the Restore option. Now, your deleted xlsx/xls file will be restored in the original location from where it was deleted.

Click Here – Incredible Way to Fix Outlook Error Code 0x800CCC05

5. Recover Xlsx/Xls file From .Tmp Folder:

First, you should search for the temp files which have the same name as your lost Excel file with the .tmp extension. In case, you are a Windows 10/8/8.1 users then you should search in this location:

C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles

In case, you are a Windows 7/XP users then you have to search in this location:

C:\Users\name\AppData\Roaming\Microsoft\Excel\

You should search for the temporary Excel files which starts with special characters “~” or “$” and end with extension “.TMP”. When you get the temporary Excel file then just copy it and save it to another safe location. Remember to change the extension of .TMP to .XLSX or .XLS.

The above method will help you to repair and recover XLS/XLSX file. In case, you need any kind of help or support then you can contact to the expert of MS Office via www.office.com/setup.

How to Resolve If Outlook Search is Not Working?

Outlook search function is very important and the helpful tool of MS Office. It helps the users to search for specific information in an email message, like the sender, date, folder where it is saved, or also the keywords using Outlook-specific search. But sometimes users face the issue Outlook search function isn’t working. Hence, in this blog you will read the solution to fix Outlook Search is not working. But if you want technical support then you can contact to the expert of Microsoft Office team via office.com/setup.

Outlook search not working is basically due to an outdated program, an indexing error, and also because of some other problem. This issue can be fixed by updating MS Office, fixing the indexing error and also by repairing Outlook.

Solution To Fix Outlook Search Is Not Working: www.office.com/setup

  1. Update Microsoft Office: Out-of-date software cause many problems. Hence, updating Outlook may solve the issue of search function. So, you should check for available updates in Outlook. For this, you should start Outlook. And then you have to select File. Now, you should select Office Account. After this, you have to select Update Options under Product Information. Then, you have to select Enable Updates if this option is available. At last, you should select Update Now.
  2. Fix Indexing Error in Outlook: For this, you should start Outlook. And then you have to click in the Search box just to activate the Search Tools tab. After this, you should select the Search Tools drop-down in the Options group and then just select Indexing Status. Here, you will see a message which states that, Outlook has finished indexing all of your items. 0 items remaining to be indexed. In case, there are items left which need to be indexed, then you should wait for five minutes and then again try it. This method will fix the issue but in case, the problem is still there then you should move to the next step.
  3. Repair Outlook: For this, fist you should close all Microsoft Office applications. Then, you have to type Apps & Features in the Windows search box. After this, you have to select Apps & Features. Now, you have to find and click on Microsoft Office which is there in the list of installed apps and features. Here, you have to select Modify option. Then, you have to select Quick Repair or Online Repair and then just select the Repair button. At the end, you have to restart Outlook when the repair procedure is finished.

Read Also – How to Setup iCloud on Mac, Window and IOS Device?

The above method will help you to solve Outlook Search Not Working issue. In case the users need any technical support for fixing the error then they can anytime contact to the customer care of MS Office. The experts are experienced and always available to solve the queries of the user. If the users need more information, then they can visit to the official site of MS Office through office.com/setup.

How to Setup iCloud on Mac, Window and IOS Device?

ICloud is the cloud data storage and syncing service, through which you can share your data like contacts, calendars, emails, and photos across multiple computers. If you make changes to your iCloud-enabled apps, then those changes will automatically upload to your account. In this blog, you will read how to setup ICloud on Mac, Window and IOS devices. For technical support, just contact to the executive of Microsoft through www.office.com/setup.

Set up iCloud on Mac OS: office.com/setup

To access your iCloud settings, you have to click on the Apple menu which is located on the top left corner of the screen and then just choose System Preferences. After this, you should click on iCloud. If in case, you are not signed in to your iCloud account, then just sign in to your account. Now, you should check the box which is next to iCloud Drive just to turn it on. Then, you have to click on Options just to customize iCloud Drive. At this point, you have to check the box which is next to each iCloud feature that you want to enable and just click on Done option to save the settings.

Set up iCloud on Windows:

For this, you have to open the Microsoft Store on your PC. Then you have to search for iCloud in the search bar. Now, you should click on Get to download the software. After this, you should click on Launch option to open iCloud. In case, Windows asks you want to allow iCloud just to make changes, then you should click on Yes option. After this, you should sign in with your Apple ID/iTunes account. In case, you have two-factor authentication set up for your Apple devices, then you should validate the device you just signed in on. After this, you should check the box which is next to each iCloud feature that you want to enable. At last, you should click on Apply option to save the changes and then just click on Close option to close the settings window.

Read Also – How You Can Access Your Files On Mobile Phone Without Internet?

Set Up and Use iCloud on iOS Devices

 You should open the Settings app. Then, you have to click your name which is at the top of the computer screen. Now, you should select on iCloud. In case, you are not signed in, then you should click on the Account field and then just sign in with your Apple ID. Here, you should move the slider to On/green for each feature which you want to enable. Now, at the bottom of the computer screen, you should hit on the iCloud Backup menu. In case, you want to back up the data on your iOS device to iCloud, then you should move the iCloud Backup slider to On/green. You should use iCloud to sync data between your computers and devices; this means that you have a backup of your data all the time. You can also restore backed-up data on the Internet.  iCloud users get free 5 GB of storage.

This method helps to setup iCloud on Mac, Window and IOS device. For more information, go to the site of MS Office via www.office.com/setup.