• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

Office 2013

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 import text file in Excel

November 17, 2015 By Ravi Shankar Leave a Comment

This tutorial is provided step by step instruction to import a text file in to Worksheet in Excel 2016 and 2013. For this demo, let us take the following sample data with the columns separated from tabs and spaces.

image

Step 1: Launch Excel Workbook and click the Data menu. Then navigate to Get External Data section.

image

Step 2: Click the From Text option under Get External Data section.

image

Step 3: In the Import Text File window, select Text file and click Import button. This should display the following Text Import Wizard.

image

Step 4: The columns in the text file have been separated using the tabs. Hence we have selected Delimited option for “Choose the file type that best describes your data”.

Step 5: After selecting an appropriate value for Start import at row and File Origin, click the Next button.

Step 6: In Step 2 of Text Import Wizard, choose appropriate delimiter under Delimiters section. You can preview the selection using Data preview section.

image

I have selected “Treat consecutive delimiters as one” as the text file used for import has more than one consecutive delimiters. Now you can see the Data preview section display the of data as 2 columns.

image

Step 7: Click the Next button to access the data format screen in Text import Wizard.

image

Here you can set the data format for the columns to either General, Text or Date. Similarly if you do not want to import any column then highlight it under Data preview select and select Do not import.

image

Step 8: Click Finish button on Text Import Wizard for completion.

image

Step 9: Now you will be show the above dialog box to choose “Where do you want to put the data”. You can either specify range on existing worksheet or New worksheet.

Step 10: After selecting the appropriate option under Import Data screen, click OK button to insert data from the text file.

image

Filed Under: Excel, Excel 2013, Excel 2016, MS Office Tagged With: Delimited file, Excel 2013, Get External Data, Import text file, Office 2013

Insert currency symbol in Word 2016 & 2013

October 27, 2015 By Ravi Shankar Leave a Comment

This tutorial is about the steps required to insert symbols in Word 2016 and Word 2013 document. Let us say you want to include Indian Rupees in the document and want to add Rupee symbol.

Step 1: In the word document, navigate to the place where you want to insert Rupee symbol.

Step 2: Click the Insert menu followed by Symbol drop down under Symbols section.

image

Step 3: If the Rupee Symbol is not listed in the dropdown list then click the More Symbols option.

image

Step 4: Select Currency Symbols in Subset dropdown and pick Rupee symbol from the list. Clicking the Insert button should add symbol to the document.

If you are going to be use the symbol frequently then you can assign a shortcut key for the Rupee Symbol. Click the Shortcut Key button and enter a new shortcut key (e.g. Alt+Shift+S) in Customize Keyboard window.

image

Click the Assign button after entering the Shortcut key. Now if you want to insert rupee symbol in the document then use the Keyboard shortcut (e.g. Alt+Shift+S).

Filed Under: Word 2013, Word 2016 Tagged With: Assign Shortcut Key, insert symbol, Office 2013, Rupee Symbol, Word 2013

Different ways to link another document in Word

October 26, 2015 By Ravi Shankar Leave a Comment

Users of Word 2016 and 2013 can create a link to another document within their document using the Insert Object or Hyperlink feature. This is quite useful when you want to include reference documents inside your document.

Insert Object

Step 1: In the main document, navigate and place the cursor to the position where you want to insert the document.

Step 2: Click the Insert menu then the Object option available under Text section.

Insert Object Word 2013

Step 3: In the Object window, click Create from File tab and choose the required file via browse button.

image

Make sure to mark the check box with caption as “Display as icon”. If you want the changes to linked document to be reflected in your document then mark checkbox with label as Link to file.

Step 4: Click the OK button to confirm and save the changes. Now your document will have a link to the other document as shown below

image

Hyperlink

Another alternate way to link a word document is by creating hyperlink pointing to that document.

Step 1: Access the Insert Hyperlink window via the right click Context Menu or Hyperlink option under the Links (Insert menu)

Step 2: In the Link to section choose Existing File or Web Page then select Current Folder option under Look in section.

image

Step 3: Give a name to the Linked document by entering the name in Text to display and then pick the required document.

Step 4: Click Ok button to confirm and save the changes.

This should create a link to the document as shown below.

image

Filed Under: MS Office, Word 2013, Word 2016 Tagged With: Creat Hyperlink, Insert Object, Link document, Office 2013, Word 2013

Insert and Save watermark in Microsoft Word

October 1, 2015 By Ravi Shankar Leave a Comment

In this tutorial we see the steps required to Insert, Save watermark in Word 2013, Word 2010 and Word 2007. Word users can insert a watermark in a document using the option available as part of the Page Layout menu.

Insert Custom Watermark in Word 2016, Word 2013 , Word 2010 and Word 2007

Step 1: Click on the Page Layout (Word 2010 and Word 2007) / Design (Word 2016 and Word 2013)  menu then navigate to the Page Background section.

Watermark option under Page Background

Step 2: Click the Watermark drop down under the Page Background section.

Custom Watermark

Step 3: Click the Custom Watermark option to add your own text for the Watermark.

Insert Text Watermark in Word document

Step 4: Now enter your text by selecting Text Watermark radio option and providing the required Text. Click the Apply button to add the Watermark to the document.

Watermark in Word document

Insert Picture Watermark in Word document

Picture Watermark in Printed Watermark window

If you want to insert picture watermark in the document then In the Printed Watermark window, choose Picture watermark radio option and select the logo that needs to be added as watermark. Then select appropriate Scale and Washout option for the Watermark. In this example, I have selected the logo of Digital Answers blog.

Choose picture in Picture Watermark

Step 5: Click Apply to have the preview of the Watermark. And if you are satisfied with the changes then click the OK button.

Save Watermark in Word 2013, Word 2010 and Word 2007

Step 1: Double click the Header section of document and select the Watermark as shown below.

Inserted Watermark

Step 2: Click the Design menu (Word 2013) or Page Layout menu (Word 2010 and Word 2007) and navigate to the Watermark option under Page Background section. Then select Save Selection to Watermark Gallery from the drop down.

Save selection to Watermark Gallery

Step 3: In the Create New Building Block window, enter name for the Watermark and click OK button.

Create New Building Block

Newly saved Watermark should now be available as part of the Gallery.

Saved Watermark

Filed Under: MS Office, Word 2007, Word 2010, Word 2013, Word 2016 Tagged With: Insert, Office 2010, Office 2013, Picture Watermark, Save Watermark, Watermark, Word 2007, Word 2010, Word 2013

How to repair Microsoft Office 2013

October 12, 2014 By Ravi Shankar Leave a Comment

This tutorial provides step by step instruction to repair Office 2013 products like Word 2013, Excel 2013, Outlook 2013 etc.. When you encounter problems with your Microsoft Office 2013 installation, then you can try these steps.

Step 1: Right click on the Start menu and select Control Panel from the menu list.

Access Control Panel on Windows 8

Step 2: In the Control Panel window, select Programs followed Programs and Features.

 

Windows 8 Program Features

Step 3: Then select Microsoft Office in the Programs list and click Change button available in the menu bar. You can also access Change button by right clicking on the selected Program.

Change Programs Installation
Step 4: In “Change your installation of Microsoft Office Professional Plus 2013” screen, select Repair radio option and click Continue.

Repair Microsoft Office 2013

This should do the necessary configuration and start repairing Office 2013

image

Repairing Microsoft Office Professional Plus 2013

Step 5: The following confirmation message will be displayed and you will asked to restart the system to reflect the changes.

image

Click Yes button to reboot the system.

Reboot Windows 8

Also See: How to repair Microsoft Office 2010

Filed Under: Excel, Excel 2013, Office 2013, Outlook 2013, Word 2013 Tagged With: Office 2013, Repair, Windows 8

How to reduce size of document with images in Microsoft Word

October 12, 2014 By Ravi Shankar Leave a Comment

Microsoft Word provides users with the option to reduce the file size of the document with images. In this tutorial, we will see the technique of reducing the file size in Word 2013 and Word 2011 for Mac.

Reduce images size in Word 2013

Word 2013 users can use the Compress Pictures option available as part of Format Picture to compress the images in the document.

Step 1: Click the Format menu in Microsoft Word 2013. Please note the Format menu will be available only after selecting the image on the document.

image

Step 2: In the Format menu, navigate to Adjust section and click the Compress Pictures option. This should display the following Compress Pictures window.

image

Now you can choose the desired option under Compression options and Target Output. Let say you want to only share the document with other users using email, then go for “E-mail (96 ppi): minimize document size for sharing”.

Step 3: After selecting the required options, click Ok button to apply the changes to images.

Compress images in Word 2011 for Mac

Step 1: Select the image in the document and click Format Picture menu.

201401021315.jpg

Step 2: Under Format Picture menu, click the Compress Option. This should display the following Reduce File Size screen.

201401021317.jpg

Step 3: Now choose the Picture Quality drop down to apply appropriate picture quality as per your needs. You can apply the changes to all the pictures in the file or just Selected pictures

Step 4: Click OK button to apply the changes to the document.


Filed Under: Apple, Mac, MS Office, Office 2013, Word 2013 Tagged With: Apple, compress images, document file size, Mac, Office 2013, reduce file size, Word 2011 for Mac, Word 2013

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