Viewing: Excel 2016

Disable autocomplete suggestion feature in Excel

Excel Auto Complete features automatically suggests a value based on previous entries. Similar to disabling auto fill feature, Excel provides option for disabling the autocomplete suggestion feature as well. So you turn off auto complete suggestion feature if you find it distracting.Listed below are the steps to disable autocomplete suggestion in Excel 2016, Excel 2013 […] Read More

How to clear content only in Excel

Microsoft Excel provides users with various formatting option such as Number, Currency, Date and time that can be applied to a cell. But if you have a scenario where you want to only clear the content of the excel sheet and to preserve the format applied to the cells then you can use Clear Contents […] Read More

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 insert special characters in Excel

This short tutorial is about the steps required for inserting special characters in Excel 2016 & 2013. For example, you want to insert Copyright, Registered, Trademark symbols then you can use the available as part of Insert menu. Listed below are the steps for inserting copyright symbol in ExcelStep 1: Place the cursor to the […] Read More

Screen capture in Excel

Excel 2016 & 2013 allows users to insert screenshot of open windows or take quick snapshot of part of screen. The screen capture feature in Excel is available as part of the Insert menu.Click the Insert menu and navigate to Illustrations section.Under Illustrations section, click the Screenshot option.Now if you want to insert any open […] Read More

How to move or copy worksheets in Excel

This is a short tutorial is about the steps required for moving or copying worksheets in Excel 2016 and Excel 2013. Excel users can copy or move users using the right click context menu or Format menu options.Step 1: Select the Sheet tab that needs to be copied or moved. If you want to copy […] Read More

How to use conditional formatting to colour alternate rows in Excel

Excel 2016 & 2013 users can use conditional formatting to colour alternate rows. Let us take the following sample dataNow you can add background colours to alternate rows by adding conditional formatting rules.Listed below are the steps for changing the background colour of alternate rows using conditional formatting.Step 1: Select the data for which the […] Read More

How to use Watch Window in Excel

Watch Window in excel helps users to monitor cells and their formulas. This tool is quite useful when you have a large data set and want to periodically monitor the result. Let us see this with an example worksheet used for calculating expenses.This excel worksheet uses formula for calculating Total monthly expenses and Annual Expense. […] Read More

How to hide and unhide worksheets in Excel

When you are sharing your excel workbook to other users and want to hide unnecessary worksheets then you can follow below mentioned steps.If you want to make life little tougher for the users to unhide the worksheet then you can use xlSheetVeryHidden attribute to hide a Worksheet.Click the Developer menu and navigate to Controls section. […] Read More

How to enable developer menu in Excel

This tutorial is about the steps required to enable developer menu Excel 2016 and Excel 2013. The Developer menu provides option for writing VBA code, enable or disable add-ins, form controls and XML interactionsStep 1: Click the File menu and select Options from the list.Step 2: In the Excel Options window, navigate to Customize Ribbon […] 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

Excel displays formula instead of value

In this article we are going to see one of the possible scenario where Excel 2016 & 2013 displays formula instead of value. Let us take the following sample data where cell C4 is showing test instead of calculated value. Navigate to Cell C3 and check the Format specified for the Cell. Now change the […] Read More

How to add dropdown list in Excel

In this excel tutorial, we are going to see how to add dropdown list in Excel 2016 and 2013. Excel users can add drop down using the option available as part of Data Validation settings. Adding dropdown in Microsoft Excel Step 1: Click Data in Office Ribbon and navigate to Data Tools section. Step 2: […] Read More

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

How to add background in Excel

Excel 2016 and 2013 users can customize the look of a worksheet by adding background image. Let say you have got the following worksheet and want to add background image to it. Step 1: Click the Page layout tab and navigate to Page Setup section. Step 2: In the Page Setup section, click the Background […] Read More

1 2 3

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