• 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 2010

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

How to quickly block sender in Outlook

October 13, 2015 by Admin 15 Comments

If you are receiving junk or spam emails in your Outlook email client and you do want to receive emails from these senders then you can use Junk email settings in Outlook to block these senders. To quickly block a sender in Outlook 2016, 2013 & 2010, select by right clicking the email and pick Block Sender option from the menu list.

image

This would display the following confirmation message and the message will be moved to the Junk email folder.

image

Instead of selecting Junk email options from the context menu, you can also try the Junk menu option which is available as part of the Home Menu.

image

Filed Under: Office 2010, Outlook 2010 Tagged With: block sender, Junk email, Office 2010, Outlook 2010

Print list of emails in Outlook

October 11, 2015 by Admin 1 Comment

We know how to quickly print an email message in Outlook 2016, 2013 & 2010. And in this tutorial we will be seeing the steps required for printing the list of emails in Inbox or any folder. This would be quite useful when you have daily task schedule meeting with your team and the tasks for each individual is allocated based on the emails received for that day.

Click the File menu and select Print from the menu list.

image

Then navigate to Settings section and select Table Style from the list. This would only print heading information of the emails as displayed on your Inbox.

image

In case if you want to include other columns in the list then you can use the View –> Change View Settings to pick the desired columns.

Filed Under: Office 2010, Outlook 2010 Tagged With: Change View, emails, Outlook 2010, Print, table style

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 change worksheet theme in Excel

October 8, 2015 by Admin Leave a Comment

In this short tutorial we will be seeing how to change theme of worksheet in Excel 2016, Excel 2013 & Excel 2010. You can change the theme using the option available as part of the Page Layout menu.

Navigate to Page Layout and click the Themes menu option under Themes section. The themes option allows users to change the overall design of the worksheet including fonts, colors and effects.

image

From the Themes drop down, you can pick any theme from the built-in list. If you want to look for more themes then you can download themes from office.com and select it using the Browse For themes option. Excel 2010 also provides option to save the current theme for future re-use.

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: chgange, Colors, effects, Excel 2010, Fonts, theme, Worksheet

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • 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