MS Office

How to find mailbox size in Microsoft Outlook

October 21, 2015 By Ravi Shankar Leave a Comment

Microsoft Outlook users can find the mailbox size using the option available as part of Mailbox Cleanup. If your organization has set quota for Outlook mailbox then you need to make sure you do not exceed the limit. You can do this by periodically checking the mailbox size and do the necessary clean up activity if the mailbox size is about to exceed.

3 simple steps to manage mailbox size

Monitor Mailbox size regularly using View Mailbox size feature.
Use Auto Archive option to archive old mails to a .PST files.
Empty Deleted item folder.

These steps has to be followed either weekly or monthly or quarterly depending upon number of and size of the emails received. List below are steps to find out mailbox size in Outlook 2013, Outlook 2010 and Outlook 2007

Finding mailbox size in Outlook 2016, 2013, 2010 and 2007

Outlook 2016 and 2013

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

Step 2: Click the Cleanup Tools option under Mailbox Cleanup section in Account Information screen.

Step 3: Select Mailbox Cleanup from the Cleanup Tools dropdown list.

Step 4: In the Mailbox Cleanup window, click the View Mailbox Size option. This would display the following Folder Size window, with the Total Size including the Size of subfolders.

Outlook 2010

Outlook 2010 users need to follow the above Step 1 and Step 2. Only the mailbox cleanup window in Outlook 2010 is different from that of Outlook 2013.

Clicking on View Mailbox Size button will display the Folder size of your Outlook Mailbox.

Demo Video – How to find mailbox size in Outlook 2010

Outlook 2007

Mailbox Cleanup in Outlook 2007 can be accessed via the Tools menu.

This provides various option such as View Mailbox Size, finding items based on date and size, Auto Archive option, Empty Deleted Item and View Conflicts Size

Also See: How to change the send and receive emails settings in Outlook

How to insert or remove pages in Word

October 20, 2015 By Ravi Shankar 9 Comments

This tutorial explains the steps required to insert or delete empty pages in Word 2016, 2013 and 2010.

Adding new page to Word document

There are different ways of inserting new page in Word document such as

Using the Blank Page option available as part of Insert menu.
Using the Page Break option available as part of Insert menu.
Simply press Enter on the Keyboard at the end of page.

Insert Blank Page

Navigate to Insert menu and click the Black Page option under Pages section.

When you want quickly insert multiple blank pages then you can use this option.

Insert Page Break

If you want to create a new page with the existing content then click the Page Break option under the Pages section.

The most easiest way to add new page is by pressing the Enter key on the Keyboard at the bottom of an existing page.

Delete page

Users can remove an empty or blank pages in Word document by

Pressing the Backspace key on the Keyboard from the end of the page that needs to be removed.
Pressing the Delete key on the Keyboard from the end of the page after which the pages needs to be removed.
Use the Show paragraph marker then press the Delete key on the Keyboard

How to change default ruler units in Excel

October 19, 2015 By Ravi Shankar Leave a Comment

The default ruler units in Excel 2016, 2013 and Excel 2010 is set to Centimetres and users can change this default units using the Settings available as part of the Excel options.

View Ruler in Excel 2013

The Page Layout view will be display the ruler in Excel. And in case if the ruler is not displayed then make sure to mark the checkbox with label as Ruler.

Change ruler units in Excel

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

Step 2: In the Excel options window, click Advanced tab and navigate to Display section.

Step 3: In the Display section, click the Ruler units drop down and select your preferred unit.

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

Turn off automatically created border lines in Word

October 19, 2015 By Ravi Shankar Leave a Comment

Word 2016, 2013 and 2010 have a feature that allows users to automatically create border lines by just typing the character three times. For example if you type dash (-) three times and press enter key in a document, Word will automatically draw a border line with dash character. This is useful when your want to quickly draw border lines in your document.

AutoFormat As You Type – Border lines

Word application allows also users to turn off this feature using the Proofing options. Click the File menu then Options link. In Word Options window, click AutoCorrect options button under Proofing tab.

Then in the AutoCorrect window, navigate to Apply as you type section under AutoFormat As You Type tab. Now un mark the check box with label as Border lines. Click Ok button to confirm and save the changes.

Quickly turn off border line feature

You can quickly turn off border line feature using the AutoCorrect Context menu Options. Type the character 3 times and press enter to draw the border line. Now select “Stop Automatically Creating Border lines” option from the drop down list.

If you want to temporarily stop creating border line just for one or two occurrences then you press Ctrl + Z to undo the changes.

How to enable insert equation in Word

October 19, 2015 By Ravi Shankar 8 Comments

Word 2016, 2013 and 2010 provide users with the option to insert mathematical equations in a document. This is quite useful when you are preparing a word document with mathematical questions. Users can insert equations using the option available as part of the Office Ribbon’s Insert menu.

But when you open an existing document created in Word 2003, the equation menu option would be disabled.

This is because this feature is available only for document with extension as .docx and not doc. And to resolve this problem all you need to do is to resave the document in Word 2010 file format. Please make sure to pick the value for Save as type drop down as “Word Document (*.docx)”.

The following confirmation message would be displayed, click OK to continue with converting the document.

By this way you can enable the insert equation option in a Word document.

How to hide row and column headers in Excel

October 19, 2015 By Ravi Shankar Leave a Comment

Excel Worksheet by default displays the rows and columns header. For some reason if you want to hide these headers then you can use Excel Advanced Options. Listed below the steps to hide or unhide row and column headers in Excel 2016, Excel 2010 and Excel 2010.

Step 1: Click the File menu and then options link.

Step 2: In The Excel Options windows, select Advanced tab and scroll down to Display options for this worksheet section.

Step 3: To hide the rows and columns headers in a Excel 2010 worksheet, un mark the checkbox labelled as Show row and column headers.

Click OK button available at the bottom of the screen to confirm the changes.

Also See: How to hide header/footer while typing in Excel

How to check version of Excel

October 17, 2015 By Ravi Shankar Leave a Comment

In Excel 2016, 2013 and 2010, the version of excel can be checked using the Help or Account menu.

Click the File menu and select Help menu.

Navigate to the About Microsoft Excel section displayed on the right hand side. This would display the Excel Version details, as shown below.

Screenshot in Excel 2013

And if you want to see additional information then you can click on the Additional Version and Copyright Information. This would display the following About Microsoft Excel Window

Also See: Disable automatic conversion of hyperlink in Excel

How set paper size to A5 in Word

October 14, 2015 By Ravi Shankar 8 Comments

We had earlier covered about the steps required for changing the paper size in Word. And to this couple of readers had asked question on How to add A5 to the paper size list. So in case you don’t see A5 or any other paper size then use the custom paper size option available as Page Setup. Let us see how to add A5 paper size to the Page Setup in Word 2016, 2013 & 2010

Click File then Print menu and navigate to Settings section.

Click the drop down with value displayed as Letter. Then select the More Paper Sizes from the list.

In the Page Setup window, navigate to Page Size and set the value for the drop down to Custom Size. Then enter the Width and Height for A5 Paper Size as 5.8” and 8.3” respectively. Then click the OK button to confirm and save the changes.

Note :- If you are not sure about the Height and Width of Paper Sizes (4A0 to A10) then refer this website.

« Previous Page