hide

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

Show or hide scroll bars in Word

October 10, 2015 By Ravi Shankar 5 Comments

In this tutorial we are going to see how to show or hide scrollbars in Word 2016, 2013 & 2010. Microsoft Word users can use the settings available as Word Options to show or hide vertical and horizontal bars.

Display Settings – Horizontal and Vertical Scroll bars

Click the File menu –> Options, this would display the Word Options window.

In the Word Options window, click Advanced tab and scroll down to Display section. Now you can show or hide scroll bars using the check boxes with label as “Show horizontal scroll bar” and “Show vertical scroll bar”. After making changes to the required check boxes, click OK button to confirm and save the changes.

Hide worksheet formula in Excel 2013 & Excel 2010

July 26, 2015 By Ravi Shankar Leave a Comment

Excel 2013 and Excel 2010 allow users to hide formula used in a Worksheet. You can use this feature when you want to prevent any one from accidentally changing the entered formula.

Let us say you want to hide the formula (=SUM(F5:F8)) which has been used in the bellow example.

Select the cell where the formula has been entered and navigate to Format menu and click the Format Cell menu option (You can also right click and select Format Cell in the Context menu).

In the Format Cell window, navigate to Protection tab and tick the checkbox with Label as Hidden. Click the Ok button to save the changes.

Then right click on the Sheet and select Protect Sheet from the list of available menu option.

In the Protect Sheet window, tick the check box with label as Protect worksheet and contents of locked cells.

If you want to just hide formula then it is not needed to password protect the sheet. Click Ok button to save the changes.

Now when you navigate to the Formula Cell, the formula bar will not displayed any information.

Bu this you can prevent excel users from seeing formula used in the worksheet.

How to Insert, Delete, Customize Comments in Excel

July 22, 2015 By Ravi Shankar 8 Comments

This tutorial provides information on the comment feature available in Excel 2013 & Excel 2010. The following will be covered as part of this tutorial.

How to insert comment
Customize the comment box
Navigate between Comments
Delete Comment

How to insert comment

Excel allows users to insert comment using the options available as part of the Review menu. But if you want to quickly insert then right click on the cell and select Insert Comment from the listed menus.

Customize Comment

A typical comment box in Excel is as shown below.

In order to change the name that appears on the Comment box, click on the File menu then the Option link then in the General tab, navigate to Personalize your copy if Microsoft Office and enter your desired name in the User name box. Click OK button to save the changes. Now the entered name will appear when you Insert new Comments.

Similarly if you want to change the Font Style used in Comment box then select then right click on the Comment box and select Format Comment menu option.

The Format Comment window allows you change the Comments Font Style.

Navigate between Comments

If you have more than one comment inserted in the Excel worksheet and you want to navigate between the comments then you can use the menu options available as part of the Comment section under Review menu. The list option includes Show All Comments, Previous and Next.

Delete Comment

A Comment can be quickly deleted are hidden by right clicking on the cell and selecting the required menu option. You can also use the menu option available as part of the Comments section under Review menu.

By this way you can Insert, customise, navigate and delete comments in Excel 2013 and Excel 2010

How to turn off the reading pane in Outlook 2013 & Outlook 2010

July 21, 2015 By Ravi Shankar 1 Comment

Outlook 2013 & Outlook 2010 have reading pane which displays the email details when we browse through the messages. This reading pane can be positioned either to the right or bottom of the email list.

A Sample message displayed in Reading Pane is shown below

If you want to turn off the reading pane using the Options available as part of View menu. Navigate to View menu then to the Layout section.

In the Layout section, click the down arrow available below the Reading Pane and select Off from the list of available menus.

By this way you can hide the reading pane in Outlook 2010.

Video demo – Turn off reading pane in Outlook 2013 & Outlook 2010

How to hide bookmarks bar in Safari on iPad

February 12, 2012 By Ravi Shankar 10 Comments

Safari browser on iPad, like any other PC or Mac browsers allows users to save webpage URL as bookmark. It also provides a separate Bookmarks Bar for easily accessing these saved URLs.

Screenshot with saved bookmarks

If you are not using the Bookmarks Bar on Safari then you have the option to turn off the display of Bookmarks Bar. This would give more space for the web page browsing and you can still access the saved bookmarks using the Safari browser menu items.

Hide Bookmarks Bar on Safari

Navigate to iPad home screen and tap the settings icon. Then navigate to the General section under Safari settings.

Slide the ON/OFF switch to turn off the “Always Show Bookmarks Bar”

How to hide header/footer while typing in Excel 2010

February 7, 2012 By Ravi Shankar Leave a Comment

This is in response to question asked by a reader of this blog related with header and footer in Excel 2010.

how do I make the header / footer not visible on the page while typing?

When you click on the insert header and footer option in Excel 2010, excel would immediately change the view to Page Layout. Hence you would see the newly added header and footer in your worksheet.

After typing the required header and footer details and do not want to see header and footer while typing you excel sheet in the data section then you can change the view to Normal by selecting Normal under the Workbook Views section.

This would temporarily hide the inserted header and footer in the Worksheet and you can always get it back by changing the Workbook view to Page Layout.

del.icio.us Tags: Excel 2010,Header,Footer,Hide,Workbook,Worksheet,Views,Normal,Page Layout

Insert slide number in Keynote on Mac OS X Lion

October 19, 2011 By Ravi Shankar Leave a Comment

In this short tutorial we will see how to insert slide number in Keynote on Mac OS X Lion system. Keynote users can insert slide number using the option available as part of the Slide menu.

Click the Slide menu and select Show Slide Number on All Slides. This would display the number at the bottom of the slide. And if you do not want to display the slide number then again click Slide menu and select Hide Slide Numbers on All Slides.