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 […]
Excel 2016
How to import text file in Excel
This tutorial is provided step by step instruction to import a text file in to Worksheet in Excel 2016 and 2013. For this demo, let us take the following sample data with the columns separated from tabs and spaces. Step 1: Launch Excel Workbook and click the Data menu. Then navigate to Get External Data […]
How to disable auto fill feature in Excel
Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill […]
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 […]