Digital Answers

How to tech tutorials in simple words

Office 2013

Disable conversion of two numbers with dash as date in Excel

by 3 Comments

Microsoft Excel has a feature that automatically coverts two numbers separated by dash in to a date formatted value. For example if you type 6-7 in a cell, Excel would reformat this in to a date value as 7-Jun. But if you do not want to reformat then you can use any of the below mentioned solutions to disable this feature.

Solution 1: Prefixing the values with apostrophe

The simplest solution is to add apostrophe before 6-7. This would display the typed value without reformatting it.

Auto format values with hyphen to date

Solution 2: Change format to Text Format

Another alternate solution is to change the formatting of the cell to Text format. Select the cell (or columns), right click and pick Format Cells from the menu list.

Format Cells in Excel

In the Format Cells window, select Text Format under Number tab and click OK button to apply the changes.

Change format to Text in Excel

Also See: How to add country code to phone numbers in Excel

How to increase number of worksheets Excel

by 1 Comment

Microsoft Excel by default contains 3 worksheets while creating a new Workbook. For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain. This can be modified using Excel Options. Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013, Excel 2010 and Excel 2007

In Excel 2013 and Excel 2010 –> Click on File menu and then Options.

increase sheets in Workbook in Excel 2013

In Excel 2007 –> Click on Excel Options and then Popular menu.

Excel Options in Excel 2007

Increase worksheets for new workbook in Excel 2007

Under When creating new workbooks section there is include this many sheets fields. This can be used for increasing the number worksheets while creating a new workbook. The minimum value is 1 and the maximum is 255. Check out the below video demo to increase worksheets size in Excel 2013

Also See: How to move or copy worksheets in Excel 2013

Repeat action keyboard shortcut in Microsoft Office

by 2 Comments

Microsoft Office Applications such as Word and Excel, last action can be repeated using keyboard shortcuts. For example if you have formatted a word with specific style and you want to repeat/apply the same format for other words then you can press F4 or Ctrl + Y or Alt + Enter. This can be used for copying drawings or formatting excel cells thus reducing the steps and saves time.

Change the keyboard shortcut for Repeat Action

Microsoft Office users can change the keyboard shortcut associated for Repeat action using Settings. Let us see these steps in Word 2016 & 2013

Step 1: Click File menu then Options and navigate to Customize Ribbon

Customize Keyboard Shortcuts in Microsoft Office

Step 2: In the Customize Ribbon screen, click Customize button available next to Keyboard shortcuts.

Change keyboard shortcut for Repeat Action

Step 3: In the Customize Keyboard window, select All Commands under Categories and pick EditRedoOrRepeat under Commands. You should be able to see the keys that are currently associated with Repeat action.

Step 4: Navigate to Press new shortcut key option and enter the keyboard shortcut.

Step 5: Click Assign to confirm and apply your changes.

Quickly print emails and attachments in Outlook

by Leave a Comment

Outlook 2016, 2013 and Outlook 2010 allow users to quickly print email & attachments using quick print options available as part of context menu. This is quite useful when you do not want to open an email and print the attachments.

Enable default printer

First you need to enable the default printer under Print options. Click File menu –> Print

Print Options in Outlook 2013 and Outlook 2010

In the Print screen, click Print Options button and mark the check box with caption as “Print attached files. Attachments will print to the default printer only.”

Set default printer in Outlook 2010 and Outlook 2013

Quick Print in Outlook 2013 and Outlook 2010

Now you can navigate to the email with attachment. Right click and select Quick Print from the right click context menu.

Quick Print attachment in Outlook 2013 and Outlook 2010

How to Add calculator in Excel 2013 & 2010

by 1 Comment

Excel users can customize the Quick Access Toolbar and add Calculator as part of the toolbar. This would allow users to access Calculator without leaving Excel application. Let us now see the steps for adding Calculator as part of QAT

Adding Calculator to Quick Access Toolbar in Excel 2013 & Excel 2010

Step 1: Launch Excel and click Customize Quick Access Toolbar dropdown.

Customize Quick Access Toolbar in Excel 2013

Step 2: Select More Commands from the drop down list.

Commands Not in the Ribbon

Step 3:  In the Excel Options window, select Commands Not in the Ribbon for the “Choose commands from” dropdown.

Caculator to QAT

Step 4: Scroll down the commands list and select Calculate Full or Calculator.

Add Calculator to QAT

Then Click Add button to add the command as part of the Customize Quick Access Toolbar list. Click OK button on Excel Options screen to close the Window.

Now you should see Calculator as part of QAT as shown in the below screenshot. And you can quickly access Calculator without leaving Excel 2013.

Calculator in Excel 2013

 

 

 

How to recover a workbook in Excel 2013 and Excel 2010

by 1 Comment

recycle files folder

This tutorial explains the auto recover feature available in Excel 2013 and Excel 2010. The auto recover feature regularly takes a backup of the workbook and stores it in a pre defined location. This feature is useful if Excel suddenly crashes and you want to recover the working copy.

Document Recovery

A document recovery pane will be displayed on the left hand side of the Excel worksheet when excel is opened after a crash.This would contain the workbook(s) which were kept open during the crash.

image

If you want to recover any of the displayed workbook, then select the required file from the available files list.

Change AutoRecover file location

You can specify the path for auto recovery feature using Save workbooks Options. Click the File menu then Options link and then navigate to the Save tab.

image

Again navigate to the Save workbooks section in Save Options screen. Using AutoRecover file location you can specify the path for automatic backup.

Change AutoRecover Time interval

Using Save AutoRecover information spinner field you can increase or decrease the minutes at which the auto save needs to happen.

Disable AuoRecovery

We have seen the importance of AutoRecovery feature in Excel and by default this is enabled. But Excel also provides option for disabling this feature.

image

You can disable this by navigating to AutoRecover exceptions section then un tick the checkbox with label as Disable AutoRecover for this workbook only.

Any changes made to this would get reflected after clicking on the OK button available at the bottom of the Save options screen.