MS Office

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

Step 2: In the Customize Ribbon screen, click Customize button available next to Keyboard shortcuts.

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.

How to recall email message in Outlook

November 17, 2015 by Admin 7 Comments

Recall message in Outlook 2016, 2013 and Outlook 2010

Outlook has a feature that lets users to recall a sent message. This can be done by accessing the Recall This Message option available as part of Actions drop down. This feature is quite useful If you had sent an e-mail message to a user with incorrect information and you want to recall that message or resend the e-mail message with correct information.

Step 1: Open the email message which needs to be recalled from the Sent Mail items folder.

Step 2: Navigate to Move section and click Actions dropdown and select Recall This Message… from the menu list

Step 3: In the Recall This Message dialog, select whether you want to Delete unread copies of this message or Delete unread copies and replace with a new message.

If you want to receive any acknowledgement then you can tick the check box with caption as Tell me if recall succeeds or fails for each recipient

Demo Video – Recall message in Outlook 2010

Recall email message in Outlook 2007

In Outlook 2007, Recall This Message option is available as part of Other options. Open the email message that needs to be recalled. Click Other Options and select Recall This Message from the drop down menu list.

On selecting Recall This Message the following dialog box would be displayed

You can select the the following options depending on your requirement

Delete unread copies of this message
Delete unread copies and replace with a new message

And if you want to receive any acknowledge for deleting the unread copies then you select the checkbox Tell me if recall succeeds or fails for each recipient.

Also See: How to recall a message in Gmail

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.

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

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

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

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.

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.

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

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.

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

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.

Disable sending a read receipt in Outlook

November 9, 2015 by Admin 5 Comments

Microsoft Outlook will send a read receipt when a new message requests for read receipt. Sending read receipt option is by default enabled in Outlook. And if you do not want to send a read receipt request then you can disable using the options available as part of Outlook settings. Listed below are the steps to disable sending read receipt in Outlook 2016, 2013 and Outlook 2010

Step 1: Click File menu and select Options from the menu list.

Step 2: In the Options window, click to Mail tab and screen down to Tracking section.

Step 3: Select the radio option “Never send a read receipt” under “For any message received that includes a read receipt request”

Step 4: Click OK to confirm and save the changes.

Demo Video – Disable sending read receipt in Outlook 2010

Also See: Request for delivery message and receipt message in Outlook

How to disable auto fill feature in Excel

November 9, 2015 by Admin 15 Comments

Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill in Excel 2013, Excel 2010 and Excel 2007

Excel 2016, 2013 and 2010

Click on the File menu –> Options link and navigate to Advanced tab on the left hand side.

Under Editing options, un tick the check box with label as Enable fill handle and cell drag-and-drop. This will turn off the auto fill feature in Excel 2010.