• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Office 2013

How to increase number of worksheets Excel

March 18, 2016 by Admin 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

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, Office 2007, Office 2010, Office 2013 Tagged With: Decrease sheets, increase sheets, Workbook, Worksheets Size

Repeat action keyboard shortcut in Microsoft Office

November 18, 2015 by Admin 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.

Filed Under: Excel, MS Office, Office 2007, Office 2010, Office 2013, Office 2016 Tagged With: Microsoft Office, Office 2007, Office 2010, Office 2013

Quickly print emails and attachments in Outlook

October 10, 2015 by Admin 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

Filed Under: MS Office, Office 2010, Office 2013, Outlook 2010, Outlook 2013 Tagged With: Attachment, Default Printer, Quick Print

How to Add calculator in Excel 2013 & 2010

July 21, 2015 by Admin 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

 

 

 

Filed Under: Excel, Excel 2013, Office 2013 Tagged With: Add Caculator, Customize Ribbon, Excel 2013, Quick Access Toolbar

How to recover a workbook in Excel 2013 and Excel 2010

May 29, 2015 by Admin 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.

del.icio.us Tags: Excel 2010,auto recover,auorecovery,workbook,backup,file location,time interval

Filed Under: Excel, Excel 2010, Excel 2013, Office 2010, Office 2013 Tagged With: auorecovery, auto recover, Backup, Excel 2010, file location, time interval, Workbook

Change the default file location in Excel 2013 and Excel 2010

May 28, 2015 by Admin 1 Comment

DefaultFileLocation

We have already seen the following articles on Microsoft Word 2010 and Microsoft PowerPoint 2010.

  • How to change default file location in Word 2010.
  • How to change default file location in PowerPoint 2010.

In this tutorial we are going to see how to change the default file location in Microsoft Excel 2013 and Excel 2010.

Click the File menu on Microsoft Excel and then the options link.

Change file location excel 2010

In the Option window, navigate to Save workbooks section under Save option. Windows Vista and Windows 7 operating system will have the default file location set to their users document folder. Now change this to your preferred working folder by making the necessary changes to Default file location property. After making the change, click Ok button to confirm and save the changes.

del.icio.us Tags: Excel 2010,default file location,Change file location

Filed Under: Excel, Excel 2010, Excel 2013, Office 2010, Office 2013 Tagged With: Change file location, default file location, Excel 2010

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel
  • How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
  • How to increase number of worksheets Excel

blogmines.com Copyright © 2023