Viewing: Excel 2010

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

How to display results inside shapes in Excel

Here are the steps required for displaying any calculation result or cell value inside shapes in Excel 2016, 2013 and 2010. Let us see this with an example that displays the max of marks obtained in a shape.Step 1: Create the required Data set.Step 2: Select the cell to calculate the Max of marks, in […] Read More

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 2013And if you want to […] 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

Print end date of previous month in Excel

In Microsoft Excel, if you want to find out the end date of previous month for the given current date then you can use TODAY() or EOMONTH().TODAY() – Returns the current date formatted as a date.EOMONTH() – Returns the number of the last day of month before or after the specified number of month.For example […] Read More

How to turn off printing cell errors in Excel

In the previous post, we had seen how to print cell comments in Excel and in this tutorial we will be seeing the steps required to turn of the cell errors displayed while printing a Worksheet in Excel 2016, 2013 and 2010.A worksheet displays different cell errors, for example when you have an invalid expression […] 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 quickly find the sum of selected range in Excel

Even beginners to Microsoft Excel will be aware of sum function used for calculating the total for set of numbers. But if you want to quickly find out the sum of selected ranges then you can use the option available as part of Excel Status bar.For example, if you have got the above set of […] 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

Quickly delete blank rows in Excel

This tutorial explains the steps required for quickly deleting blank rows in Excel 2016, 2013 & 2010. For example, if you have analyzed some data and replaced the not required data with blank spaces. Now if you want quickly remove these blank rows then you can use option available as part of Go To feature.To […] Read More

How to preserve leading zero in Excel

Microsoft Excel 2016, 2013 and 2010 allows users to preserve the leading zero by defining a custom format. For example if you are entering a value in excel cell as 08500 and you haven’t specified any custom format then this value would appear as 8500. To preserve the leading zero, right click on the cell […] 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

How to display input message for cell in Excel

Excel 2016, 2013 & 2010 has a feature for displaying input message for a cell which would help users to enter the correct value/data type. This can be achieved using the Data Validation feature available in Excel.For example if you want to show a message to the user that the cell accepts only numbers, then […] Read More

How to copy column width in Excel worksheet

In this tutorial we will be seeing how to copy widths of column from one worksheet to another in Excel 2016, 2013 & 2010. This is a useful feature when you have customized the columns width in one worksheet and want to maintain the same column width for a different data set in another worksheet.Select […] Read More

How to insert time in Excel

Listed below are the instructions for adding current time (static and dynamic) in the Excel 2016, 2013 & 2010. Insert Current time (Static) Step 1: Navigate to cell where you want to show the time. Step 2: Press Ctrl + Shift +; then Enter. Step 3: To format the time, right click on the cell […] Read More

1 2 3 6

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