login office Archives - www.office.com/setup

January 8, 2021January 8, 2021

How You Can Reduce Excel File Size Without Deleting Data?

How You Can Reduce Excel File Size Without Deleting Data? Office.com/setup

Sometimes, a large-sized Excel workbook creates lots of problems like the file will respond very slow, it will take more time to save any changes, and it take time to upload etc. So in this blog, you will read how to reduce Excel File Size without deleting data. For assistance, you can visit to the official website of MS Office via www.office.com/setup.

Method To Reduce Excel File Size Without Deleting Data: office.com/setup

1. Remove Cell Formatting:

First, you should select the range over which you want to clear the formatting. Then, you should go to the Home Tab and then click on Editing Group and then choose Clear and then select Clear Formats option.

2. Reduce The Size Of The Image File Added In MS Excel:

For this, you should open your excel file which contains an image or logo and then just choose the pictures for compressing. Now, you should go to the Picture Tools and then click on Format tab, and then in the Adjust group how to reduce Excel file size you should hit on the Compress Pictures. If in case, you only see the Adjust group then you will see the Compress Pictures button appears without a label. If you want to decrease the size of a specific image and then you should leave all other images present in the document, and then mark the Apply only to this picture check box. If in case, you unmark the Apply only to this picture checkbox then this will override any previous modifications which you have done for other images. After this, you should go to the Resolution and then just select the resolution which you want and then click on OK button .

3. Convert File type to Binary Format (XLSB):

For this, you should click on the File tab and then you should go to the Save As option. Now, you should click on the Browse button just to change the file type. Here from the Save As dialog box, you should pick the Excel Binary Workbook (.xlsb) file type. And then click on Save option.

4. Remove Unnecessary Formulas:

You should open the Excel file and then press the ctrl + A keys just to select the entire worksheet/dataset and then just press the F5 key. Now, you should open the Go To option and then click on the ‘Special’. After this, you should select the Formulas and then just click on OK button. Here, you have selected all the cells which have a formula. Then, you should press the ctrl + C key to copy the selected cells. Now, you should click on the Home tab and then from the Clipboard group, you should click on the Paste option. After this, you should click on the Paste Value icon.

5. Compress The File (ZIP IT):

First, you should right-click on the Excel File which you want to zip. Now, you should take your mouse cursor to the Send to option and then just click on the ‘Compressed (zipped) folder’ option.

The above method will help you to reduce the Excel File Size Without Deleting Data. But if the customer need any kind of support then just contact to the customer care of MS Office via www.office.com/setup.

Also Read – Easy Method to Solve MS Office Error Code 30068

January 6, 2021January 6, 2021

Easy Method to Solve MS Office Error Code 30068

Easy Method to Solve MS Office.com/setup Error Code 30068:

MS Office is one of the best software which is available for both official and home purpose. And you can download and install this software through www.office.com/setup. But sometimes users face issues while installing MS Office. Hence, in this blog you will read the solution of Office Error Code 30068.

Solutions to Resolve Office Error Code 30068: Office.com/setup

Resolve Www.office.com/setup Error Code 30068

1. Restart PC and Try to Install MS Office Again:

First, you should restart your Computer system because restarting your computer can fix many issues. When your computer restarted, then you should try to reinstall office suite. If you face any problem in installing office online, then you should do it offline installation just by using office set up.

2. Check the Status of Click-to-Run Service:

You should press Win + R key at the same time just to open the Run dialog box. After this, type “services.msc” in the open field and tap on Enter or OK button to open services. Now, you should check for the Microsoft Click-to-Run services in the list in the services section and then just double click on it. At this point, you should go to the General tab and then in the Startup section, just click on the drop-down menu and here you should select Automatic. Then, you should click on Apply button, and then choose OK, just to save the changes. After this, you should try to reinstall the office suite and just check if the problem is fixed or not.

3. Uninstall MS Office and Try to Reinstall:

If you want to uninstall MS Office suite, then you should download the Microsoft Office Uninstall tool from the official website of Microsoft and then just run the setup. This will delete the incomplete Office installation and all the unwanted files. But if the Uninstaller tool shows you, “Office installation is missing”, then you should check if there is an ongoing installation of Office.

4. Start Full System Scan Using ASR.:

For this, you should switch on the computer. In case, the computer is already on, then it should be rebooted. After this, the BIOS screen will appear but if the Windows pops up then you should reboot the computer and again try it. When you’re on the BIOS screen, then you should press F8 key and it will show you the Advanced Options dialog box. Now, you should go to the Advanced option and then you should select Safe Mode with Networking and then just click on it. Here, the Windows will try to load the SafeMode with Networking. After this, click on the start menu and then open RUN option. This will open up the MS Windows Run Box. In the Run dialog box, you should type in the URL address and then click on Enter or Ok button. Now, the program will be downloaded, and when it is downloaded, you should open the launcher to install the program. When installation process complete, you should run ASR to perform a full system scan. After this, you should click on the “Fix, Clean & Optimize Now” button.

The above method will solve the Office Error Code 30068. If you want any kind of help or support, then jut contact to the customer care of MS Office via www.office.com/setup.

January 2, 2021January 2, 2021

Basics Tips You Should Know For PowerPoint Presentation

If the user wants to create the effective and powerful presentation, then you should follow some tips. To install MS PowerPoint just visit to the site via www.office.com/setup. In this blog, you will learn how to create a effective presentation.

Tips For PowerPoint Presentation: office.com/setup

1. Choose an Appropriate Template:

For this, you should go to File. And then you have to select New option. After this, you should Browse by category or just search for a specific type of template. At last, you should choose the template which you want to use and then select Create.

2. Display PowerPoint Shows in Widescreen:

In PowerPoint on a PC, you should go to Design. Then, you have to select Slide Size in the Customize group. After this, you should choose Widescreen (16:9).

In PowerPoint for Mac, you should go to File. Then, you have to select Page Setup. Now in the Page Setup dialog box, you should choose Widescreen (16:9) under Slides Sized For.

3. Limit Fonts:

You should stick with two attractive fonts throughout your slideshow. Just choose one font for the titles and the other font for the other content. This will give a refined appearance to your presentation.

4. Insert Quality Images:

It is advised you should add professional stock photos, or the high-resolution pictures which you took yourself, or the other high-quality graphics to your PowerPoint slides.

5. Go Easy on the Animations:

You should use an animated transition which grabs your audience’s attention during a slideshow presentation. Don’t use too many animations.

6. Show and Tell:

Do not give too much information at one time. Just you should cover a single point on a slide. You should ensure that the slide title show the point which you want to make and you can add bullet points to just clarify your message.

7. Resume Your PowerPoint Show After a Pause:

You should stop the presentation for some time and then resume after a short break. Here, you can pause and then resume a slideshow with ease. You should press B to pause with a black screen or just press W to pause with a white screen. After this, you should press B or W again just to resume the presentation.

8. Create an Obvious Ending:

You should inform your audience that the presentation is over. For this, you should create a slide with message that the slideshow has finished.

9. Start Another Presenter’s Slide Show:

For this, you should select text or an object on the final slide of the first presentation. And then click on this, just to go to the next slideshow. Now, you should go to Insert option. Then, you have to select Link or Hyperlink just to open the Insert Hyperlink dialog box. After this, you should choose Existing File or Web Page. Now, you have to go to the presentation file which you want to link to. Then, you have to select Bookmark and then choose the title of the slide which you want to link to. At the end, you should select OK option.

These are the basic PowerPoint Presentation Tips which everyone should follow. If the user need help, then just go to the site of MS Office via www.office.com/setup.

Also Visit Here – How to Troubleshoot MS Word Not Responding Issue?

April 15, 2020April 15, 2020

How you can Create a Custom Dictionary In Microsoft Word?

Today, Microsoft Office becomes the major player in all the software’s. As this software, completely satisfies the need of the computer users. And it is estimated that for the next ten years no other software can compete with this software as it has all the applications which is necessary to run the organizations, schools, colleges, etc. You can install this software through office.com/setup. This software has user friendly interface and it is totally compatible with all the devices like Window OS, Mac, Computers, Laptops and Android Phones etc.

Microsoft Word users provide its customer a default custom dictionary for their spelling preferences. If you right-click on a flagged word and select “Add to Dictionary,” then this word goes to your default custom dictionary. In this blog, you will learn how to create additional custom dictionaries in MS Word.

Create a Customer Dictionary in MS Word:

First you have to select the File tab. Then you have to select Options in the backstage view. After this, you have to select Proofing in the Word Options dialog box. Here you have to select the Custom Dictionaries button. Now you have to select any of the options in the Custom Dictionaries to make the new button. After this, just select the New button. Just choose a file location for your new dictionary in the Create Custom Dictionary. The default location which is chosen by the Word will be totally appropriate for the users. Now you have to type the name of your new custom dictionary in the File name text box. Here you have to Select the Save button. The Create Custom Dictionary will close automatically, and your new dictionary will appear in the Custom Dictionary. You can also uncheck the new dictionary if you do not want it to be applied to the current documents. Just select the OK button. Now, you can populate your newly created custom dictionary.

Add Words To A Custom Dictionary:

First you have to select the File tab and then just select Options in the Backstage view. After this, you have to select Proofing in the Word Options. Now, you have to select the Custom Dictionaries button. Here just select your new dictionary in the Custom Dictionaries. Now, you have to select the Edit Word List button. After this, you have to type one word at a time into the Word text box in the Edit Word List. Here you have to Select the Add button for each word. Now just select the OK button to save your changes. At the end, the Custom Dictionaries will close automatically.

For more details, you can visit to the official websites of MS Office through www.office.com/setup.

January 4, 2020January 4, 2020

How to add Hyperlinks, Bookmark and Mailto links in Excel?

MS Office is the software which has so many applications. Every application has different functions. In every application of Microsoft Office there are so many things which you can perform. So, in this blog we discuss about how to add hyperlinks, bookmarks and mailto links in MS Excel. MS Office makes the work of every firm easier. You can install via www.office.com/setup.

A hyperlink gives you the way to open the web page by selecting a cell in the worksheet. By using this, you can easily access to other Excel workbooks.

Bookmark creates a link to the specific area in the current worksheet or to the different worksheet in the Excel file.

Mailto links is the link in email address. Hyperlinks and Bookmarks make it easier to navigate between areas of related data. Mailto links makes it easier to send an email message to an individual or organization.

Add Hyperlink to the Web page and to Excel file:

Add Hyperlink to Web Page:

For this, first open the Insert Hyperlink dialog box, and then select the Existing File or Web page tab. Now in the address line, type a full URL address. And select ok to complete the hyperlink and close the dialog box.

Add Hyperlink to a Excel file:

First of all, open the insert Hyperlink dialog box and select the existing file or Web page tab. After this, select the Browse for file to open the link to file dialog box. Then find the file name and select the file and select ok. The file will be added to the address line in the Insert Hyperlink dialog box. Now select OK to complete the hyperlink and close the dialog box.

How to create the Bookmark to the same Worksheet:

First of all, type the name in the cell which will act as a anchor text for the bookmark and press Enter. After this select the cell to make it a active cell. Then open the Insert Hyperlink dialog box. Now select the place in this document tab. In the Type the cell reference box, you have to enter a cell reference to a different location on the same worksheet. At the end, select OK to complete the bookmark and close the dialog box.

How to insert the Mailto link into an Excel File?

First of all type a name in a cell which will act as the anchor text for the mailto link and press Enter. After this, select that cell to make it active cell. Now you have to open the Insert Hyperlink dialog box. Then select the E-mail Address tab. Now in the Email address field, enter the email address of the person who will receive the email. Under the Subject line, enter the subject of the email. At the end, select OK to complete the mailto link and close the dialog box.

If you still have any doubts, then you can contact to the customer care of MS Office via Office.com/setup . Or you can also call on the toll free number for help and support.