Viewing: Worksheet

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

How to quickly send worksheet as PDF in Excel

We have already covered the procedure for converting excel worksheet in to PDF. In this short tutorial we are going to see the the steps required for quickly sending worksheet as PDF in Excel 2016 and Excel 2013.Step 1: Open the Excel worksheet that needs to shared with other as PDF file.Step 2: Click the […] Read More

Rename a worksheet in Excel

In this short beginners tutorial, let us see the different ways to rename an worksheet in Excel 2016, 2013 and Excel 2010.The easiest option to rename a sheet is to simply double click the Sheet tab and rename it.  […] Read More

Change worksheet tab colour in Excel

Microsoft Excel 2016, 2013 and 2010 allow users to change the worksheet tab colour using the Format menu option or Context menu.This is the quickest way for changing the tab colour. Right click on the worksheet tab to launch the context menu. Navigate to Tab Colour menu option and select the preferred colour of your […] Read More

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

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 users […] Read More

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 formula has […] Read More

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

How to add photograph to Excel Worksheet

In this tutorial, we will see steps for adding photograph inside worksheet in Excel 2013. Apart from regular calculation, if you want to include some photos along with the data then you can follow to below mentioned steps. Step 1: Place your cursor on the cell where you want insert the photograph. Step 2: Navigate […] Read More

How to convert excel sheet to a PDF in Excel 2010

Excel 2010 provides option for converting excel sheet in to a PDF file. This can be done using the Save As option. Let us take the following sample data in excel that has to be converted in to PDF. Click the File menu –> and select Save As option from the menu list. In the […] Read More

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

How to change default number of worksheet in Excel 2011 Mac

The number of worksheet associated with a new workbook in Excel 2011 for Mac is 1. And if your work requires adding a worksheet then you can click the plus sign to insert new sheet. If you always require minimum of 3 worksheet in your new workbook then it is recommended to change the default […] Read More

How to unprotect a sheet in Excel 2010

We have already discussed about protecting a workbook structure and preventing users from adding new Worksheet. In this tutorial we will find out to unprotect a Workbook. When you navigate to the Info menu of a protected Workbook, it will display that the structure of the workbook is locked. You can remove this protection by […] Read More

How to insert header and footer in Excel 2010

Microsoft Excel 2010 provides option for inserting header and footer for Worksheets. This can be done using the Page Layout option. Click on the View menu and then select Page Layout option. The following Page Layout view will be displayed. click the Click to add header text and enter the Header for the Worksheet like […] Read More

Get your free copies of the following tech guides by joining the Digital Answers mailing list.