How to Recover an Unsaved Excel File

Sponsored Links

How to Recover an Unsaved Excel File

We have experienced a situation where we have created a Excel file and then accidentally closed it out without saving it. Is it lost forever? Do I have to recreate the entire file over? Those are just a few of the questions that will be flying around in your head. Take a deep breath, and follow the steps below to recover your excel file.

1.You click the File tab => Info =>  Manage Documents.

How to Recover an Unsaved Excel File

2.You select “Recover Unsaved Workbooks” from the drop-down menu.

How to Recover an Unsaved Excel File

3.Click “Open” when you’ve selected the file you want to recover.

Sponsored Links

4.Click the Save As button and save your Excel file .

You also recover overwritten Excel files

You click on the FILE tab =>  Info  => Manage Versions button you’ll see all autosaved versions of your file.

recover overwritten Excel files

Excel automatically saves versions of the workbook at specified intervals, but only if you’ve made changes to your spreadsheet between these intervals. The name of each version has a date, time and the “(autosave)” note. When you click any of them, it will open along with the most current version of your workbook so that you can compare them and see all the changes.

If the program closed incorrectly, the last autosaved file is labeled with the words (when I closed without saving).

How to Recover an Unsaved Word Document

Applies to : Microsoft Word 2010, Word 2013, and Word 2016

We have experienced a situation where we have created a Word document and then accidentally closed it out without saving it. Is it lost forever? Do I have to recreate the entire document over? Those are just a few of the questions that will be flying around in your head. Take a deep breath, and follow the steps below to recover your document.

How to recover an unsaved Word document

1.You click the File tab => Info =>  Manage Documents.

How to Recover an Unsaved Word Document

2. You select “Recover Unsaved Documents” from the drop-down menu.

Recover Unsaved Documents

3.Click “Open” when you’ve selected the document you want to recover.

document you want to recover

Sponsored Links

4.Click the Save As button and save your Word document.

Change the setting AutoRecover Word

If you would like change the frequency with which Microsoft Word automatically saves a recoverable copy of your document, follow the steps below. The default time is set to 10 minutes.

  1. Click the File tab => Options.
  2. In the Options dialog box you click the Save option located on the left side.Change the setting AutoRecover Word
  3. Under Save documents change the minutes to how often you would like Word to save a recoverable version of your document.
  4. When finished click OK

Here’s hoping that you are able to recover all of your work!

Tag : How to Recover an Unsaved Word Document

How to merge two word documents into one

Applies to: Microsoft Word 2010 , Office Word 2007

If you need to cope with Word documents quite often during work, merger of multiple Word documents into one might be required sometimes. You can copy and paste the content directly when the info quantity is not large. But what if it is not that case?
Insert” tab allows you to subtly merge documents.

Sponsored Links

Insert tab allows you to subtly merge documents

Locate “Object“, press a small triangle next to it, and click “Text from File” from the dropdown menu.

Text from File

After that, you can select files to be merged into the current document. By pressing and holding Ctrl to select more than one documents.

(Note: Documents placed at the top will be merged in the first place. Therefore, please sort and number each target document in case that you want to keep a certain sequence for your documents. )

How to merge two word documents into one

This method applies both to Word 2010 and Word 2007. Attention required: Formats will not be necessarily remained when you merging the documents. Please be careful of that.

Tag : how to merge two documents in word , how to merge two word documents

How to Change Default Font in Outlook

Applies To: Outlook for Office 365 , Outlook 2016 , Outlook 2013 ,

When you set a default font, every new document you open will use the font settings that you selected and set as the default. The default font applies to new documents that are based on the active template, usually Normal.dotm. You can create different templates to use different default font settings.

How to Change Default Font in Outlook

  1. Click File > Options > Mail > Stationery and Fonts…How to Change Default Font in Outlook

  2. Select the font you want to change
    • New mail messages – Sets the default font for original messages you compose.
    • Replying or forwarding messages – You can have a different font on messages you’re forwarding or replying to. This setting is mostly for the two check boxes that let you mark your comments with your name (or other text) or with a different color of text.
    • Composing and reading plain text messages – Plain text messages will be received by the other person with a standard font, but if you want to use a nicer font when you’re writing the message you can. Just understand that font won’t be sent with the message.
  3. Select the options that you want to apply to the default font, such as font style and font size.
  4. Click OK all the way back out to save your changes.

    Tag : How to Change Default Font in Outlook

How to Change Default Font in Word for Mac and Windows

Applies to: Office Word 2007 , Microsoft Word 2010 , Microsoft Word 2013 , Microsoft Word 2016

When you set a default font, every new document you open will use the font settings that you selected and set as the default. The default font applies to new documents that are based on the active template, usually Normal.dotm. You can create different templates to use different default font settings.

How to change default font in Word for windows ?

Start with a blank document, or if your document already contains text that is formatted with the properties that you want to use, select that text.

  1. On the Home tab, you click the Font Dialog Box Launcher, and then click the Font tab.How to Change Default Font in Word For Windows
  2. Select the font, point size, and any attributes that you want.How to Change Default Font in Word For Windows 2
  3. Click Set As Default, and set the scope of your changes:
    • Select This document only? if you want your changes to apply to only the current document.
    • Select All documents based on Normal .dotm template? if you want your changes to apply to any document based on the Normal template.Click OK to apply your changes
  4. Click OK to apply your changes.

How to Change Default Font in Word for Mac

Changing the default font in any template means that the font is used in every new document that is based on that template. For example, the default font for new blank documents is based on the Normal template.

  1. Open the template or a document based on the template whose default settings you want to change.

  2. Under Font, click the font you want to use, and then under Size, click the size you want to use for the body text.How to Change Default Font in Word for Mac

Click Default in the bottom left corner, and then click Yes to apply the change to all new documents based on the template. Click OK when finished.

Read more :

Tag : How to Change Default Font in Word for Windows , How to Change Default Font in Word for Mac

What is Office Configuration Analyzer Tool ( OffCAT ) ?

Information

What is Office Configuration Analyzer Tool ( OffCAT )


The Microsoft Office Configuration Analyzer Tool (OffCAT) was removed from the Microsoft Download Center on June 11, 2018.

The Outlook scanning functionality of OffCAT is available in the Microsoft Support and Recovery Assistant for Office 365 (SaRA) tool. SaRA offers several improvements, including the ability to identify and fix specific issues in Office Setup , Outlook, OneDrive for Business, and several other Office programs. You can use the SaRA tool is used to scan for issues in Outlook.

Tag : OffCAT

How to use the Histogram in Excel

Applies to: Excel 2013Excel 2010Microsoft Office Excel 2007

How to use the Histogram in Excel

Summary

You can analyze your data and display it in a histogram (a column chart that displays frequency data) by using the Histogram tool of the Analysis ToolPak in Microsoft Office Excel. To create a histogram, you must organize the data in two columns on the worksheet. These columns must contain input data and bin numbers. Input data is the data that you want to analyze by using the Histogram tool. Bin numbers are the numbers that represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis.

How to use the Histogram in Excel

When you use the Histogram tool, Excel counts the number of data points in each data bin. A data point is included in a particular data bin if the number is greater than the lowest bound and equal to or less than the largest bound for the data bin. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum values of the input data.

The output of the histogram analysis is displayed on a new worksheet (or in a new workbook) and shows a histogram table and a column chart that reflects the data in the histogram table.

Before you can use the Histogram tool, you have to make sure that the Analysis ToolPak Add-in is installed.

Make sure that the Analysis ToolPak Add-in is installed

To make sure that the Analysis ToolPak Add-in is installed, follow these steps:

1.On the File menu, click Options.
Options excel 2010
2.Click Add-Ins in the navigation pane.
Add-Ins excel 2010

3.In the Manage list, select Excel Add-ins, and then click Go.

4.In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available is selected, and then click OK.

Analysis ToolPak check box

Note For the Analysis ToolPak Add-in to be displayed in the Add-Ins dialog box, it must be installed on your computer. If you do not see Analysis ToolPak in the Add-Ins dialog box, run Microsoft Excel Setup and add this component to the list of installed items.

Create a histogram table

To create a histogram table, follow these steps:

  1. Copy and paste the following data into a new worksheet.
    87 20
    27 40
    45 60
    62 80
    3
    52
    20
    43
    74
    61

    2.Do one of the following:

    • In Excel 2013, Excel 2010 and Excel 2007, on the Data tab, click Data Analysis in the Analysis group.

    Data Analysis in the Analysis group

    • For Excel 2003 and earlier versions of Excel, click Data Analysis on the Tools menu.

    3.In the Data Analysis dialog box, click Histogram, and then click OK.

    the Data Analysis dialog box

    4.In the Input Range box, type A1:A10.

    the Input Range box

5.In the Bin Range box, type B1:B4.

6.Under Output Options, click New Workbook, select the Chart Output check box, and then click OK.

Excel generates a new workbook with a histogram table and an embedded chart.

Based on the sample data from step 1, the histogram table will resemble the following table:

   A1: Bin     B1: Frequency
   A2:  20     B2:        2
   A3:  40     B3:        1
   A4:  60     B4:        3
   A5:  80     B5:        3
   A6: More    B6:        1

Your chart will be a column chart that reflects the data in this histogram table. In this example, the bin that corresponds to data values from 0 to 20 contains two data points: 3 and 20.

Tag : how to make a histogram in excel , how to create a histogram in excel

Microsoft Office 2016 Product Key for Free [100% Working]

Whenever we install or activate Office 2016, we will be prompted to enter a 25-character Microsoft office 2016 product key, which looks like this:
XXXXX-XXXXX-XXXXX-XXXXX-XXXXX
Whenever we buy a genuine office 2016, product key for MS office 2016 will surely come with it. This product key makes sure that your copy hasn’t been used on more PCs than the Microsoft Software Terms allow.
The way you can find your ms office 2016 serial key depends on how you got Office 2016, this can be pre installed on your device, from an online store, from a physical store, got through a partner, got as a student from school. The source from where you have got your office 2016 is your source too from where you will get your ms office 2016 key.

Microsoft Office 2016 Product Key Free

NKGG6-WBPCC-HXWMY-6DQGJ-CPQVG
9C2PK-NWTVB-JMPW8-BFT28-7FTBF
PD3PC-RHNGV-FXJ29-8JK7D-RJRJK
GNH9Y-D2J4T-FJHGG-QRVH7-QPFDW
R69KK-NTPKF-7M3Q4-QYBHW-6MT9B
C2FG9-N6J68-H8BTJ-BW3QX-RM3B3
J484Y-4NKBF-W2HMG-DBMJC-PGWR7
YG9NW-3K39V-2T3HJ-93F3Q-G83KT

You copy and paste microsoft office 2016 activation key as below image :

Microsoft Office 2016 Product Key for Free

If these keys don’t work , you can use code to actiave Microsoft Office 2016 without product key ( I tested on 10-30-2017 ) . You can read this article :

Activate Microsoft Office 2016 without Product Key Free

Step 1: Copy the following code into a new text document.

Click Here to copy this code

Create a new text document.

Step 2: Paste the code into the text file. Then save it as a batch file (named “1click.cmd”).

Step 3: Run the batch file as administrator.

Please wait…

You can watch this video to know how to activate Microsoft Office 2016 without product key .

Tag : Product Key for Microsoft Office 2016 , Microsoft Office 2016 Product Key , MS Office 2016 Product Key  , Microsoft Office 2016 Activation Key , Microsoft Office 2016 Serial Key

Microsoft office 2016 is a major update to its previous version and Office 2016 wants to connect you and your coworkers together, using some baked-in smarts to help you along. It encourages you to share documents online, in a collaborative workspace. It has advanced features like in word more contexts for richer documents. It has two new apps Sway and Delve, Business intelligence now integrated inside Excel.
So there are many new added features that you can look for in office 2016, so just go ahead and get a trail version for yourself and if you are satisfied with it, then go ahead and get genuine Microsoft office 2016 with product key for MS office 2016.

 

Microsoft Office 2013 Product Key [100% Working]

Microsoft office 2013 is the successor to Microsoft office 2010, it had many enhanced and new features which were there to enable the touch function of the touch devices. This is workable with Microsoft office 2013 product key, which comes with product itself. A touch-enabled device is required to use any multi-touch functionality. But, all it’s features and functionality are always available by using a keyboard, mouse, or other standard or accessible input device. New touch features are optimized for use with Windows 8.

When we install or activate Office 2013, system will be prompted for the product key for Microsoft office 2013, which is a 25-character ms office 2013 key, which looks like this:
XXXXX-XXXXX-XXXXX-XXXXX-XXXXX
Where you will find this ms office 2013 serial number depends on the way you purchased your Microsoft office 2013, Microsoft office 2013 product key will be provided to you by the seller you are buying your product from. This can be in digital form, hard copy or be a soft copy. You cannot install your office without product key for Microsoft office 2013. So make sure that you are getting an authentic and genuine product and ms office 2013 serial number.
You can even use Microsoft office 2013’s trial version for 30 days, so that you will get a chance to test it without have to buy it, you will get different Microsoft office 2013 product key for that that will make sure that you have a smooth operation for one month. With this package you will get access to Word 2013, PowerPoint 2013, Excel 2013, Outlook 2013, OneNote 2013, Access 2013, Publisher 2013, and the LyncMessenger program.

What’s new in Microsoft office 2013?

In this version, you can access your data, edit your files or gross your important information on any computer/tablet via a browser subscription of office 365 and be integrating it with SkyDrive. “Read mode” is another feature which not only makes you feel like working on “E-Reader” but also provides to swipe or tab through a file.

Microsoft Office 2013 Product Key for Professional Plus

FCMXC-RDWMP-RFGVD-8TGPD-VQQ2X
MT7YN-TMV9C-7DDX9-64W77-B7R4D
PGD67-JN23K-JGVWW-KTHP4-GXR9G
B9GN2-DXXQC-9DHKT-GGWCR-4X6XK
6PMNJ-Q33T3-VJQFJ-23D3H-6XVTX

MS Office 2013 Product Key List (Latest):

6KTFN-PQH9H-T8MMB-YG8K4-367TX
B9GN2-DXXQC-9DHKT-GGWCR-4X6XK
J484Y-4NKBF-W2HMG-DBMJC-PGWR7
FCMXC-RDWMP-RFGVD-8TGPD-VQQ2X
C2FG9-N6J68-H8BTJ-BW3QX-RM3B3
MT7YN-TMV9C-7DDX9-64W77-B7R4D

You choose a key and paste as below image :
Microsoft Office 2013 Product key free
Once you like it you can always go ahead and buy genuine office and will get product key for Microsoft office 2013 and can run office on your device without any interruption. Buying a genuine product always help you to work at ease, and you should always go for the genuine product once you are satisfied with the product and get a genuine ms office 2013 key.

If these keys don’t work , you can use new method to activate  Microsoft Office 2013 ( I tested on 12-27-2017 )

#Method 1 : use Microsoft Toolkit 

1. First you are required to disable the anti-virus system TEMPORARILY. (Anti-virus companies won’t allow activating pirated windows & office copies)

2. Download the Latest Version by click here , pass : freeapps

3. Install, and Run the Software you download .

To Activate Microsoft Office 2013 you click icon Office in this tool .

Microsoft Toolkit to activate Microsoft Office

Then, in the Activation tab, click ‘EZ-Activator’. Just in few seconds, your copy will be activated.

Microsoft Toolkit to activate windows 7

Then you restart your pc .

You can watch this video to know how to use Microsoft Toolkit :

 #Method 2 : use code

Step 1: Run command prompt as administrator

Run-command

Step 2 : Find the local of Microsoft Office 2013

Find-the-local-of-Microsoft-Office-2013.jpg

Then copy this local to cmd and enter :

cd\local of Microsoft Office 2013

example my code : cd\Program Files\Microsoft Office\Office15

local-of-Microsoft-Office-2013.jpg

You copy this code to cmd and enter :

cscript OSPP.VBS /inpkey:YC7DK-G2NP3-2QQC3-J6H88-GVGXT if  you install Office 2013 Professional Plus

cscript OSPP.VBS /inpkey:KBKQT-2NMXY-JJWGP-M62JB-92CD4 if  you install Office 2013 Standard

How-to-Activate-Microsoft-Office-2013-without-Product-Key.jpg

Then you copy that code and enter :

cscript OSPP.VBS /sethst:kms.msguides.com

kms.jpg

Finall you enter this code :

cscript OSPP.VBS /act

Finish .

You can see this result

Activate-Microsoft-Office-2013.jpg

You can watch this video to know how to activate Microsoft Office 2013 without Product Key

tag : microsoft office 2013 product key , product key for microsoft office 2013 , ms office 2013 product key , microsoft 2013 product key , how to activate MS 2013 . Microsoft Office 2013 Serial Key , Microsoft Office 2013 Activation Key .

Read more :

Microsoft Office 2010 Product Key for Free [100% Working]

MS Office 2010 product keys: Microsoft office 2010 is the successor of Microsoft office 2007 and it is a version of Microsoft office productivity suite. When you get Microsoft Office 2010 you get it with Microsoft office 2010 product key. Microsoft office 2010 was more “role-based” than previous versions; there are many features which helped employees in roles such as research and development professionals, sales people, and human resources.

New features in Microsoft office 2010 also include a built-in screen capture tool, a background removal tool, new SmartArt templates and author permissions. You can use these entire features with the help of product key for Microsoft office 2010. Previous version’s Office Button was replaced with a menu button that leads to a full-window file menu, known as Backstage View, giving easy access to task-centered functions such as printing and sharing. So this is one of the best office suit to use with the help of Microsoft office 2010 key.

Microsoft office 2010 product key is a 25-character code used to activate office. It looks like this:
Microsoft office 2010 serial key: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

Microsoft office 2010 Product Key/Activation key 32 Bit

BDD3G-XM7FB-BD2HM-YK63V-VQFDK
TTK27-44W3B-PVC8K-XJQW8-KJMVG
VYBBJ-TRJPB-QFQRF-QFT4D-H3GVB
W4D2C-3YK88-KMYP2-2QTXY-28CCY
76XCJ-YMH2W-YQQV6-XX76X-QK3K7

TVFJ7-76TR7-HHCKT-QQFJR-8KTTD

Microsoft office 2010 Product Key/Activation key 64 Bit

72D2Y-R2D7F-HG6TM-H8W4M-CHCB4
IUWQP-IUEIOP-WQURI-OWETH-GSDJH
WWRDS-3YYX11-KPO5P-YXSD5-2CCVC
OR859-85EWP-EWUTI-UYADK-FLXNV
65XRT-YGH2D-TXX9L-YYTR5-OLPW4
DLHF8-ERYT8-749YT-3RJKE-WJHF8
You choose a key and paste as below image :
Microsoft Office 2010 Product Key for Free
Microsoft Office 2010 programs have many helpful accessibility features that both make it easier for people with disabilities to use these products, and, for all content creators to make more accessible documents, presentations, and other materials. So grab your Microsoft office 2010 product key to use its all advanced features.

If these keys don’t work , you can use Microsoft Toolkit to activate  Microsoft Office 2010 ( I tested on 12-27-2017 )

1. First you are required to disable the anti-virus system TEMPORARILY. (Anti-virus companies won’t allow activating pirated windows & office copies)

2. Download the Latest Version by click here , pass : freeapps

3. Install, and Run the Software you download .

To Activate Microsoft Office 2010 you click icon Office in this tool .

Microsoft Toolkit to activate Microsoft Office

Then, in the Activation tab, click ‘EZ-Activator’. Just in few seconds, your copy will be activated.

EZ-Activator

EZ-Activator

You can watch this video to know how to use Microsoft Toolkit :

Tag : Microsoft Office 2010 Product Key , Microsoft Office 2010 Serial Key , Microsoft Office 2010 Activation Key , How to activate MS 2010 .