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