Excel 2010

Prevent users from adding new worksheet in Excel

January 25, 2016 By Ravi Shankar 2 Comments

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 change the permission. You can access Protect Workbook Structure from the Info menu.

Click the File menu and then navigate to Info menu and click the drop down arrow under Protect Workbook option. From the list of available option select Protect Workbook Structure. This would display the following Protect Structure and Windows. Mark the check box with label as Structure. If you want to password protect it then enter a password in the Password field. Click Ok button to save and confirm the changes.

How to hide row and column headers in Excel

October 19, 2015 By Ravi Shankar Leave a Comment

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 options link.

Step 2: In The Excel Options windows, select Advanced tab and scroll down to Display options for this worksheet section.

Step 3: To hide the rows and columns headers in a Excel 2010 worksheet, un mark the checkbox labelled as Show row and column headers.

Click OK button available at the bottom of the screen to confirm the changes.

Also See: How to hide header/footer while typing in Excel

How to check version of Excel

October 17, 2015 By Ravi Shankar Leave a Comment

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 if you want to see additional information then you can click on the Additional Version and Copyright Information. This would display the following About Microsoft Excel Window

Also See: Disable automatic conversion of hyperlink in Excel

How to enable auto filter for protected sheet in Excel

October 10, 2015 By Ravi Shankar 11 Comments

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 enabled while protecting the worksheet. This tutorial is about the steps required for enabling auto filter for a protected worksheet in Excel 2010.

Click the Protect Sheet option available under Review menu or Info menu.

Review Menu

Click Review menu –> Changes –> Protect Sheet

Info Menu

Click File menu –> Info menu –> Protect Workbook –> Protect Current Sheet.

On clicking the Protect Sheet option would display the following Protect Sheet window.

Scroll down the “Allow all users of this worksheet to” list and make sure to tick the check box with caption as “Use AutoFilter”. Click OK button to confirm and save the changes.

Now excel users will be able to use the auto filter option even in a protected worksheet.

How to change worksheet theme in Excel

October 8, 2015 By Ravi Shankar Leave a Comment

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 users to change the overall design of the worksheet including fonts, colors and effects.

From the Themes drop down, you can pick any theme from the built-in list. If you want to look for more themes then you can download themes from office.com and select it using the Browse For themes option. Excel 2010 also provides option to save the current theme for future re-use.

Hide worksheet formula in Excel 2013 & Excel 2010

July 26, 2015 By Ravi Shankar Leave a Comment

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 formula has been entered and navigate to Format menu and click the Format Cell menu option (You can also right click and select Format Cell in the Context menu).

In the Format Cell window, navigate to Protection tab and tick the checkbox with Label as Hidden. Click the Ok button to save the changes.

Then right click on the Sheet and select Protect Sheet from the list of available menu option.

In the Protect Sheet window, tick the check box with label as Protect worksheet and contents of locked cells.

If you want to just hide formula then it is not needed to password protect the sheet. Click Ok button to save the changes.

Now when you navigate to the Formula Cell, the formula bar will not displayed any information.

Bu this you can prevent excel users from seeing formula used in the worksheet.

How to unhide comments in Excel

July 25, 2015 By Ravi Shankar 1 Comment

Excel 2013 and Excel 2010 generally shows comments in worksheet with the Indicator as shown below.

And when you hover over the indicator it will display the added comments.

But in case if you are not able see the comments added to your worksheet then try the unhide option available as part of the

Click the File menu and then the Options link
In the Excel Option window, navigate to Advanced Options
Scroll down to display section and For cells with comments radio option select your preferred choice i.e either Indicators only, and comments on hover or Comments and indicators.
4. Click Ok to save and confirm the changes.

How to search, print and unhide comments in Excel

July 24, 2015 By Ravi Shankar 2 Comments

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 2010

But searching and finding inserted comments in a excel worksheet with number of rows spanning across more than a page will be a huge task. This can be simplified using the Search Comments option available as part of the Find feature. To find comments in Excel 2010 and Excel 2013, navigate to Editing section and click the drop down arrow available next to Find & Select option.

This would display the following menu options as part of the Find & Select feature.

Click Comments from the list of available menus. This would locate the comment in your Excel Worksheet. And if you have more than one comment, then press tab to navigate to each comment.

Print cell comment in Excel 2013 and Excel 2010

Excel by default does not print the comments and you can enable this feature using the Page Setup option.

Let us added the following comment for a cell in Excel Worksheet.

Now when you navigate to Print Preview option (File –> Print), Excel will not show the added comments. Click the Page Setup option available under Print Preview Settings page.

In the Page Setup Window, click the Sheet tab and navigate to Print section. For comments drop down, choose “At end of sheet” or “As displayed on sheet” for Comments. Let us go with “At end of sheet”, click Ok button to confirm and save the changes.

Now the print preview screen will display the comments at the end of sheet and the same will get printed while printing the worksheet.

Unhide comment in Excel 2013 and Excel 2010

If you are not able see the comments in worksheet then you can try to use the unhide option available as part of the Excel Advanced Options.

Click the File menu and then the Options link.
In the Excel Option window, navigate to Advanced Options.
Scroll down to display section and For cells with comments radio option select your preferred choice i.e either Indicators only, and comments on hover or Comments and indicators.

Click Ok to save and confirm the changes.

Also See: How to Insert, Delete, Customize Comments in Excel 2010