• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

Office 2010

How to increase number of worksheets Excel

March 18, 2016 By Ravi Shankar Leave a 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 Ravi Shankar Leave a Comment

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 Ravi Shankar 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 Ravi Shankar 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

Different ways to find bookmarks in Word

October 10, 2015 By Ravi Shankar Leave a Comment

We had earlier seen about the steps required to insert bookmark in Word 2016, 2013 & 2010. This article explains the different ways to find out and navigate to bookmarks in a Word document.

Bookmark Option

Users can quickly launch the Bookmark option by pressing Ctrl + Shift + F5. Bookmark option allows users to create new bookmark as well as navigate to existing bookmark. In the Bookmark option window, you can navigate to a bookmark by either by double clicking on the name or by selecting the name then clicking the Go To button.

image

Find and Replace Dialog

Users can also navigate to bookmark using the Find and Replace dialog. Press F5 to launch Find and Replace dialog, then click GoTo tab and enter bookmark name and press Enter.

image

 

And if you have created many bookmarks and don’t remember the name of the bookmark then you can you pick it from the bookmark list. In the Go to what option, select Bookmark from the option list. A drop down list would be appear below the Enter bookmark name with list of available bookmarks. Pick the bookmark name from the list and click the Go To option.

image

Filed Under: Office 2010, Word 2010 Tagged With: Bookmarks, Bookmarks list, Find, Go To, Word 2010

Show or hide scroll bars in Word

October 10, 2015 By Ravi Shankar 5 Comments

In this tutorial we are going to see how to show or hide scrollbars in Word 2016, 2013 & 2010. Microsoft Word users can use the settings available as Word Options to show or hide vertical and horizontal bars.

image

Display Settings – Horizontal and Vertical Scroll bars

Click the File menu –> Options, this would display the Word Options window.

image

In the Word Options window, click Advanced tab and scroll down to Display section. Now you can show or hide scroll bars using the check boxes with label as “Show horizontal scroll bar” and “Show vertical scroll bar”. After making changes to the required check boxes, click OK button to confirm and save the changes.

Filed Under: Office 2010, Word 2010 Tagged With: display, hide, horizontal, Office 2010, scroll bars, Show, vertical, Word 2010

Quickly print emails and attachments in Outlook

October 10, 2015 By Ravi Shankar 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 background color to paragraph in Word

October 9, 2015 By Ravi Shankar 2 Comments

In this short tutorial we are going to see how to add background color to texts or paragraph in Word 2016, Word 2013 and Word 2010. For example, if you want to add background color to a paragraph then you can follow the below mentioned steps.

  • Select the paragraph and navigate to Paragraph section under Home menu.

image

  • Click the arrow pointing downwards with paint icon.

image

  • Now pick the desired color under Theme Colors or Standard Colors. You could immediately see the preview of the color shading effect for the selected Paragraph.
  • If you want to add background shading with custom color then click More Colors option and define your colors under Custom tab.

image

Filed Under: Office 2010, Word 2010 Tagged With: Add, background color, custom color, paragraph, shading, Word 2010

  1. Pages:
  2. 1
  3. 2
  4. 3
  5. 4
  6. 5
  7. 6
  8. 7
  9. 8
  10. 9
  11. »
Next Page »

Primary Sidebar

TwitterLinkedin

Recent Posts

  • How to block keywords in Jio broadband
  • How to disable opening an app automatically at login in Mac
  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy