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 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 change worksheet theme in Excel
In this short tutorial we will be seeing how to change theme of worksheet in Excel 2016, Excel 2013 & Excel 2010. You can change the theme using the option available as part of the Page Layout menu. Navigate to Page Layout and click the Themes menu option under Themes section. The themes option allows […]
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 […]
Changing column width in excel 2013 and excel 2010
There are different ways for changing the column width of cell in Excel 2010 and Excel 2013. Some of them are listed below Double Clicking Column Header The easiest one for adjusting the column width is to double click the Column Header of cell whose width needs to be changed depending on the longest length […]
How to hide header/footer while typing in Excel 2010
This is in response to question asked by a reader of this blog related with header and footer in Excel 2010. how do I make the header / footer not visible on the page while typing? When you click on the insert header and footer option in Excel 2010, excel would immediately change the view […]