How to hide row and column headers in Excel

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 […]

Hide worksheet formula in Excel 2013 & Excel 2010

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 […]

How to Insert, Delete, Customize Comments in Excel

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 […]

How to hide header/footer while typing in Excel 2010

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 […]