Ravi Shankar – Page 11 – Tweaking Apps

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

Remove page number from selected pages in Word

October 15, 2015 By Ravi Shankar Leave a Comment

This is in response to the query posted by a reader that “How to remove a page number without removing all page numbers ”.

Word 2016, 2013 and 2010 have a feature that allows users to remove page number for selected pages alone. The option is know as “Section Break” and it is available as part of the Page Setup menu. For example if you have 5 pages in a document and want to remove the page number for the 4th Page then you can follow the below mentioned steps.

Step 1:- In the Word document, scroll down to the page with number as 4.

Step 2:- Navigate to Page Layout menu then click the Break menu option under Page Setup section.

Step 3 :- Select Next Page from the Breaks menu drop down list.

Step 4 :- Then double click the Footer of the new page section.

Step 5 :- Select Same as Previous option in the document and un select the Link to Previous available under the Header & Footer Tools.

Step 6 :- Now you can edit or remove the page number from only the selected page.

How to add filename to footer in Word

October 15, 2015 By Ravi Shankar Leave a Comment

Word 2016, 2013 and 2010 allows users to add filename to the footer section using Quick Parts. For example, if you want add filename in a three column footer then you can do the following.

Insert Footer

In the Word document, navigate to Insert menu, click the Footer option and pick Blank (Three Columns) from drop down list.

Insert filename in Footer

After selecting the column where you want to insert filename, navigate to Quick Parts under Text section and click the Filed menu option.

In the Filed window, select Filename under Field names and choose your preferred format i.e. Uppercase, Lowercase, First capital, Title case and None.

If you want to add path to the filename then navigate to Fields options section and tick the check box with label as Add path to filename. Click OK button to confirm and save the changes. Now your Footer section will reflect the filename with the path.

Update filename in Footer

In future if you change the name of the file then you can update the footer with the new filename by right clicking on the filename section and selecting Update Filed menu option.

How to use AutoText template in Outlook

October 15, 2015 By Ravi Shankar Leave a Comment

We had already seen about creating email templates to avoid repetitive work in Outlook 2016, 2013 and 2010. Auto Text is another template like feature that allows users store pre defined text which gets highlighted when you start typing the first few lines of the text and pressing Enter key will automatically populate the text.

Creating Auto Text entry in Outlook

You can create AutoText templates for the text which gets used very often when you are writing an email in Outlook. For example, if you send lot of emails to your subscribers then you can add some thing like “Dear readers” as a AutoText entry. This can be done by typing Dear readers in New Message window, then press Alt + F3 after selecting the text. This would display the following Create New Building Block window.

You can provide a description for your new entry and click Ok button. Now when you start typing first few letters of “Dear Readers”, Outlook will start highlighting the AutoText entry as shown below.

On Pressing Enter key, “Dear Readers” will be automatically populated in the message window.

Manage AutoText entries in Outlook

Users of Outlook can manage AutoText entries by using option available as part of Insert menu. Click the Insert menu in New Message window, then Quick Parts –> AutoText. Right clicking on the AutoText entries will display menu list with Organize and Delete option.

Using the Building Blocks Organizer, users can Edit, Delete and Insert AutoText entries in Outlook 2010.

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.

Missing header and footer problem in Word

October 13, 2015 By Ravi Shankar Leave a Comment

Word 2016, 2013 & 2010 have an option that allows users to show or hide white space between pages in Print Layout. Hiding the white spaces between pages will also hide the header and footer in the document. You can solve the missing header and footer problem by any of the following ways.

Displays Options

Click File menu –> Options –> Display Options.

Then navigate to Page display Options and make sure to mark the check box with label as Show white space between pages in Print Layout view.

Show the white space using mouse

The other alternative way is to Show the white space by double clicking on the page break line. When you hover the mouse over the page break the following message appears.

And by double clicking on the line should un hide the white space between the pages and also the headers and footers.

« Previous Page