Category: Excel 2013
-
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…
-
Insert check mark in Microsoft Word
Insert check mark in Word 2010 and Word 2013 This tutorial provides steps required to insert tick or check mark in Word 2010, Word 2013 and Word 2016. The most common method is to use the option available as part of Insert > Symbol. Another alternate way is to change the font type to Windings…
-
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…