How to change default ruler units in Excel

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

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

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

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 Add calculator in Excel 2013 & 2010

Excel users can customize the Quick Access Toolbar and add Calculator as part of the toolbar. This would allow users to access Calculator without leaving Excel application. Let us now see the steps for adding Calculator as part of QAT Adding Calculator to Quick Access Toolbar in Excel 2013 & Excel 2010 Step 1: Launch […]