TIP 13 : Outlook : Go To Date Shortcut

In this blog we will see how to use keyboard shortcut to go to specific day, week, month and work week calendar in outlook.

Go to calendar in the outlook and press CTRL + G. It will open up a Go To Date pop up with date and show in drop down list.

We can select either day, week, month or work week calendar in the Show in list and specific go to date in the Date list.

TIP 12 : Outlook : Create Table Template For Quick Access

In this blog we will see how to create a table template and use it in your mails using single click action in fraction of seconds. We have many instances where we use same table structure and layout and we use copy and paste feature to add the same table to the mails which is time consuming. This blog will help you quickly access commonly used tables in your mails. 

Create a table structure and layout which you will be using as a table template. Select the entire table using cross arrow icon on top left corner of table.

Go to insert tab, then click on Quick Part icon and choose Save Selection to Quick Part Gallery.. option. It will open up a Create New Building Block pop up.

Give the name to the table template in Name property and press OK. It will add the table template in the Quick Part Gallery.

Now to use the table in your mails without recreating or using copy and paste function we can directly add the table template from the Quick Part Gallery using single mouse click button.  

TIP 11 : MS Excel : Sheet Selection

In this blog we will see how we can quickly select sheet using single click when we have large number of sheets in the excel file. This shortcut will save your time in selecting a sheet without traversing all the sheets using arrow buttons.

As shown in screenshot below we have large number of sheets and it time consuming to select sheet 20 by traversing from sheet 1 to sheet 20. We can select sheet within fraction of seconds using this method.   

• Press mouse right button on the arrow keys.

• It will open up a pop with a list of all the sheet names. Select the sheet and press OK, it will open up the selected sheet in excel file. 

TIP 10 : Outlook : Create Search Folder

How To Create Search Folder in Outlook

In this blog we will see how to create a search folder in outlook to easily find the mail from specific person. There are instances when we need reference to older mail to reply to any other particular email and we spend most of the time in finding the mail. We can save time by creating search folder in Outlook. 

Search folder as such do not contains any email it just like a saved search to refer email conversations. It also segregates the mails folder-wise, emails from archive is stored under archieve header, emails from inbox are stored under inbox header.   

Follow below steps to create the search folder -

• Right click on the Search Folders option on the left side panel of Outlook window

• Click on New Search Folder... to create new search. It will open a pop up to select from different criteria. Select Mail from and to specific person from the list.

• Click Choose to select sent to and receive from mail recipients for customized search folder.

• Select the name of the person from the list to create search folder for its emails and press OK.

•    We can see the customized search folder created under search folders section in the left hand side panel in Outlook.

TIP 9 : MS Excel : Select Entire Row/Column

Shortcut To Select Entire Row/Column In Excel Sheet

In this blog we will look for keyboard shortcuts to select entire row and column in the excel sheet.

Select the cell in the row or column which you want to select. 

• CTRL + Spacebar - Select entire column

• Shift + Spacebar - Select entire row

TIP 8 : MS Excel : Sheet Navigation

Shortcut To Navigate Between Sheets in Excel File

In this blog we will see how to navigate among sheets in the file. We can navigate both left and right of the current sheet without moving mouse at all.

Sheet2 is the current sheet in the below screenshot.

Press CTRL + Page Down key to move right of the current sheet.

Press CTRL + Page Up key to move left of the current sheet. We can traverse from Sheet1 to Sheet3 by pressing CTRL + Page Up key twice 

 

TIP 7 : MS Excel : Create New Sheet

Shortcut To Add New Sheet In Excel

In this blog we will see how we can add new sheet in excel file using keyboard shortcut without using mouse at all.

Press SHIFT + F11 to add new sheet in excel file. It will always add sheet left to the current selected sheet.