• 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

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

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

How to repair Microsoft Office 2013

October 12, 2014 by Admin 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

Primary Sidebar

Recent Posts

  • Streamline your Excel spreadsheets with these easy steps to hide rows and columns
  • Effortlessly Convert Text Cases in Excel with These Methods
  • 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

blogmines.com Copyright © 2023