Excel users can sort a column using the Sort feature available as part of Sort & Filter menu. But what if you want to flip a column upside down. Let us see this with an example column having some text values as shown below. We will not be able to apply sort feature directly on […]
Excel 2010
Prevent users from adding new worksheet in Excel
Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to […]
How to check version of Excel
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 […]
How to enable auto filter for protected sheet in Excel
We had already seen the following tutorials related with protection of worksheet in Excel 2016, 2013 & 2010. Prevent users from adding new worksheet. Password Protect Worksheet in Excel. Unprotect Worksheet in Excel. And if a worksheet with auto filter is protected then users will not be able to use auto filter unless it is […]
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 unhide comments in Excel
Excel 2013 and Excel 2010 generally shows comments in worksheet with the Indicator as shown below. And when you hover over the indicator it will display the added comments. But in case if you are not able see the comments added to your worksheet then try the unhide option available as part of the Click […]
How to search, print and unhide comments in Excel
Adding a comment to a cell in Microsoft Excel is very useful feature. You can always locate a comment by red arrow appearing at the top right corner of the cell. List below are the steps to search, print and unhide comments in Excel 2013 and Excel 2010. Search comment in Excel 2013 and Excel […]
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 […]