Author: Zeynep

Most of you would be thinking, what is ‘e’ or Euler’s numbers? Here’s the answer to both.

What is Euler’s Numbers?

‘E’ represents one of the most important numbers in mathematics and equates to the decimal 2.718282. It is an irrational number and cannot be expressed in the form P / Q (i.e. fractional form). It is also the base of the natural logarithm.

First introduced by Leonhard Euler, it is known as Euler’s E or Euler’s number. The significance of e in mathematics roots in several reasons. There are many ways how you can bring this number to use – a few are listed below.

• E forms the base for the natural logarithm.
• It is used for continuous compounding operations.
• It is used in many statistical forecasting models.
• E is the limit for the expression [(1 + 1 / n) * n] where the value for ‘n’ can go up to infinity.
• On a broader scale, the Euler’s e is used in many operations ranging from determining simple exponential growth to decay.

Pro Tip: Euler’s ‘e' is not to be confused with Euler's constant, which is also a recurring number equivalent to  0.5772. Euler’s constant is denoted by lower case gamma and has a wide application in harmonic series. However, both Euler’s constant and Euler’s ‘e’ are entirely different concepts.

How to Use ‘e’ in Excel?

After we have seen what Euler’s ‘e’ is, it is now time to see how this works in Excel. In mathematics, most operations involving ‘e’ would use it as the base for different exponential powers.

= e ^ ^x

In the above equation, ‘e’ is the number 2.718282, whereas ‘x’ represents any number to whose power ‘e’ is to be raised.

= 2.718282 ^ (any power)

However, the number 2.718282 is an irrational (recurring) fraction, so rounding it might not yield the exact right figure. Also, it is often difficult to memorize the said long decimal number. This is where Excel comes to the rescue.

Excel has an inbuilt EXP function that enables Excel users to raise the number 2.718282 to any power and yield desired results.

EXP Function

The EXP function won’t take much of your time and effort to master. It has only one argument and is simple to use.

Syntax:

= EXP (number)

The argument ‘number’ is used to denote the number whose power is to be found.

Return value:

The EXP function returns the value of ‘e’ raised to the power of the input number.

Examples:

Let us see the EXP function in action to learn how you may bring it to use.

In the image below, we have applied the EXP function to find the exponential power for the number 2.

You must have found this one pretty simple. Nevertheless, this is not the only way how the EXP function can be brought to use.

For instance, you may use it to find the exponential growth of different cell values. See here.

As evident above, the EXP function first finds the value for ‘B3 – 5’ where B3 = 10. After that, it applies the Excel function to the value for ‘B3 – 5’, which equates to 5.

You can nest into EXP many other complex functions like in the example below.

Note: If you set up the EXP function as EXP(0), the results would be equivalent to 1 as any number raised to the power 0 equates to 1.

Conclusion:

Euler’s e stands out as one of the most important mathematic constants that deal with problems of exponential growth and decay.

The EXP function in Excel makes the application of Euler’s E way easier and swifter than you could ever do manually. Also, you barely need to put in much effort to learn how to bring this function to use.

Try and test the EXP function of Excel, and you are all set to be able to use it in your daily operations.

A drop-down list in Excel helps you input data correctly and properly from a list of pre-defined inputs. It works as a data validation check and avoids any chance of inputting invalid data. As it restricts the values that can be entered into a cell, it is one of the most used functions of Excel.

A drop-down list carries a list of multiple inputs and makes data entry time-saving and error-free. However, you can remove the drop-down list when you have finished data entry or if you do not want to limit the user to a small set of values.

Apart from the benefits that a drop-down list has to offer, it takes a fine deal of effort to remove a drop-down list from Excel.

Removing any existing drop-down list or multiple drop-down lists from your Excel spreadsheet is not as easy as just selecting the cell and pressing the Delete key.

To know the exact steps involved in deleting a drop-down list from Excel, continue reading the article that follows.

There are three ways how you can remove a drop-down list in Excel – let’s look into each of them.

1. Data Validation

This is the most commonly used method of removing drop-down lists from Excel. Take a look at the example below.

The above example demonstrates the sales record of a store, displaying various brands of mobile phones, along with their prices. Every phone brand has its unique product ID.

Column F represents the payment methods used for selling these mobile phones. The column ‘Payment Type’ contains a drop-down list of various options used to receive payments against mobile phone sales.

If you want to remove the drop-down list in cell F4, the Data Validation dialogue box is the best option. To learn how you can remove the said drop-down list using the data validation technique, follow the steps below.

Step 1

Select the cell containing the drop-down list, which is F4 in this case.

Step 2

Go to the Data tab in the Ribbon and select Data Validation from the drop-down menu that appears.

Step 3

Select the “Clear All” button and press the “Ok” button. Make sure to have selected the “List” option under the “Allow” tab.

This removes the drop-down list from cell F4. Also, the arrow at the right side of cell F4 has been removed, as shown in the following image.

Pro Tip: 
This method removes the drop-down list from any cell but keeps the last values selected from the list within the cell. So, if you have used the drop-down list for easy data entry and later want to remove the list, this option would work best for you. Using Data Validation, you can remove the drop-down list without having to lose the cell values.

How to remove the drop-down list from multiple cells all at once?

If you want to remove multiple drop-down lists simultaneously, you can still do it by using Data Validation.

Select the cells from where you want to remove the drop-down list and repeat the above-mentioned steps.

Excel would remove drop-down lists from all the selected cells while preserving the cell values.

How to remove all drop-down lists from a spreadsheet at once?

If you want to remove all the drop-down lists from your worksheet, the process remains the same.

All you need to do is check the “Apply these changes to all other cells with the same settings” option from the Data Validation window, as shown below:

Selecting the “Apply these changes to all other cells with the same settings” option automatically selects every cell in the worksheet containing the specified drop-down list.

Thereafter, clicking “Clear all” and then the “OK” button will remove all those drop-down lists without you having to lose the cell values.

2. The Clear All Button

This method is helpful if you want to remove the cell’s content along with the drop-down list.

Step 1

Select a single cell or multiple cells from where you want to have the drop-down lists, as well as the cell values, removed.

Step 2

To delete drop-down lists from your worksheet in Excel using the ‘Clear All’ option, take the route established below.

Home Tab > Ribbon > Clear > Clear All

The ‘Clear All’ option clears everything from the selected cells – this includes the values, the formatting, the drop-down lists, and everything else.

3. Copy-Paste Method

Another quick way to remove drop-down lists in Excel is to copy a blank cell from your worksheet and paste it over the cell or the range of cells that have the drop-down list.

Since you’ve pasted an empty cell, the target cell will turn empty and will not contain any drop-down list or other value.

Conclusion

The drop-down list acts as the easiest data validation check when inputting large volumes of data. Adding drop-down lists to Excel is super easy. However, once added, it might be a little tricky to get rid of them.

The above techniques will help you steer your spreadsheet clear of any unwanted drop-down lists. Hope this helped you learn what you’ve been looking for.

Happy Excel Exploring!

In Excel, you might only use a single worksheet or a combination of many worksheets.

Excel allows you to add up to 255 worksheets in a single Excel workbook. Adding a worksheet is all about a click on the ‘+’ sign that sides right to the sheet tabs on the bottom of your Excel workbook.

However, once you are done working, you might find some Excel worksheets redundant and may want to delete them. The good thing is Excel allows you to remove those unnecessary worksheets from your workbook very easily.

The article below elucidates multiple methods of how you can delete unwanted worksheets from your workbook to shape them to your needs.

1. Ribbon Option

This is the most straightforward and the quickest way to delete a sheet from your workbook.

Consider the following example.

In this workbook, there are four worksheets, namely Sheet1, Sheet2, Sheet3, and Sheet4. If you want to delete Sheet1, follow the steps below.

Step 1

Select Sheet1 with a right-click.

Step 2

Select the “Home” tab.

Step 3

Select the “Delete” option from Ribbon. A drop-down list will appear. Select the “Delete Sheet” option from the drop-down list.

Step 4

A warning box will appear asking to delete the Sheet. Selecting the “Delete” button will permanently delete the selected Sheet from your workbook.

Step 5

Select the “Delete” button, and you have removed Sheet1 from your workbook.

Delete Adjacent Sheets using the Ribbon Option

You can also delete multiple sheets using the Ribbon option. To delete adjacent sheets, press and hold the Shift key and select the first Sheet and the last Sheet that you want to delete.

For instance, to delete sheets from Sheet1 to Sheet3, hold ‘Shift’ and click Sheet1. Do not release the ‘Shift’ button before you click ‘Sheet3’.

In doing so, Excel would select all adjacent sheets starting from Sheet1 to Sheet3.

Now repeat the above-mentioned steps to delete the selected sheet.

Delete Non-Adjacent Sheets using the Ribbon Option

If you want to delete non-adjacent sheets, you can do it using the Ctrl key. Press and hold the Ctrl key and select the Sheets that you want to delete one by one. Now repeat the above-explained method to delete the selected sheets.

2. Right-Click Option

Under this option, deleting sheets in Excel is all about two clicks.

Consider the example below whereby we have four sheets.

From these four sheets, let’s say you want to delete Sheet 2. Here are the simple steps that you must follow in order to delete Sheet 2 using the right-click option.

Step 1

Right-click on the sheet to be removed, which in this case is Sheet2.

Step 2

Choose the Delete option from the list of options that opens up upon right-clicking on the sheet.

Step 3

Select the Delete option from the system Prompt.

The right-click technique can also be used for non-active sheets.

How? If you are working with Sheet 2 and want to delete Sheet 3, you don’t need to go to Sheet 3 for that. Right-click on the tab for Sheet 3 and select delete from the list of options that launches.

Pro Tip:

In addition, you can delete multiple Sheets, either adjacent or non-adjacent, by using the right-click technique. Excel allows users to select multiple sheets in one go by holding the control key simultaneously while sheet selection. Once you’ve selected the desired sheets, you can release the Control key. 

After all the desired sheets are selected, simply right-click on any selected sheet's tab and choose the delete option from the menu to delete all the selected sheets. 

3. Keyboard Shortcuts

Worksheets in Excel can be deleted using keyboard shortcuts. There can be two techniques to do so i.e. a Hybrid Keyboard shortcut, and the other is a Regular keyboard shortcut.

Let us see both techniques one by one.

3.1. Using a Hybrid keyboard shortcut

The hybrid keyboard shortcut uses, both mouse and keyboard combinations to delete any Sheet from the workbook. The Hybrid keyboard shortcut is:

Right-click + D

To delete any sheet or sheets in Excel, right-click on the Sheet you want to delete and press the ‘D’ key from your keyboard. It is faster than using only right-click and selecting Delete from the menu.

3.2. Using a Regular Keyboard Shortcut

You can delete any active worksheet using only the keyboard. For this, the keyboard shortcut is:

ALT + H + D + S

In this shortcut, you do not need to press the keys simultaneously, but one after another. The only limitation is that you can delete only active worksheets by this shortcut.

3.2.1. Using Legacy Keyboard Shortcut

If you remember, before ribbon style, keyboard shortcuts were used to execute various functions in Excel. For compatibility reasons, these shortcuts are still applicable to newer versions of Excel. Such legacy shortcuts still work for deleting any sheet from the workbook. The keyboard shortcut is:

ALT + E + L

For many reasons, this shortcut is faster than many other techniques. Just press the said keys in succession, and the active sheet would be deleted.

Related Tutorial: How to Delete Columns in Excel

Conclusion

A worksheet is an area that allows you to store your data and use various functions to fetch the desired results. Excel allows you to add a fine number of worksheets to manage your data.

Likewise, you can remove unwanted sheets once you are done working in Excel. The foregoing techniques are expected to help you with deleting worksheets through normal Excel working practices.

A little practice can help you master the foregoing techniques in no time!

Pivot Table is one big reason why statisticians, data engineers, actuaries, and other professionals from data-intensive fields of work would resort to Excel.

Even if you do not know coding or programming, still you can work out huge volumes of data in Excel using the Pivot Tables.

And all you need to do for this is have a fine grasp of how to construct a Pivot Table in Excel.

Pivot tables are undoubtedly great analytical tools that help you organize and summarize your data with a few clicks. And after you’ve analyzed the data as required, you may not want to keep the Pivot Table on your worksheet forever.

This is mainly because if you have huge amounts of data populated in your pivot table, it may hamper the performance of your workbook. It takes up large file space and can slow down the performance of Excel.

Excel users, therefore, prefer deleting Pivot Tables once they have sought the results they were looking for.

However, deleting a Pivot Table may not turn out to be as easy as creating a Pivot Table.

In this article, we will show you the four possible ways how you may delete a Pivot Table from your workbook with sheer ease. To learn more details about each of these methods, continue reading the article below.

1. Remove the Pivot Table Along with the Source Data

If you want to remove the pivot table along with the data contained therein, you can go with a number of methods to do so.

Consider the following pivot table:

Method # 1

The simplest way to delete such a pivot table is to delete the entire sheet that contains the subject pivot table and you are done. However, this method is only applicable if the sheet doesn’t contain any other data that you may want to preserve.

Method # 2

Another way to delete this pivot table is to activate any cell from this pivot table and press CTRL+A. Doing so will broaden the selection to the entire pivot table.

Next, press the delete key to get rid of the pivot table.

Pro Tip: If your Pivot Table consists of any filters, you may not want to opt for this method. 

Method # 3

Select the entire pivot table using the shortcut key ‘Ctrl+A’ and select the Clear All option through the following route.

Home Tab > Editing > Clear > Clear All

Method # 4

Using The Pivot Analyze Tab

• Click any cell in the pivot table.
• Select the Pivot Analyze tab.
• Click on the Select option.
• Select the Entire Pivot table from the drop-down list. The whole of the Pivot table will be selected by Excel.
• Press the Delete key from the keyboard, and you are done with deleting the pivot table along with all data

Method # 5

Using Shortcut Keys

Let’s bring your keyboard to action. You can also delete a Pivot Table in Excel by using a combination of different shortcut keys. To do so, follow these steps:

• Click any of the headers in the pivot table.
• Press CTRL + A to select the entire pivot table.
• Press ALT + E to open the Clear option.
• Press the A key, and the pivot table will vanish along with its data.

2. Delete the Pivot Table but Keep the Source Data

It is at times that after analyzing your data you want to keep the sorted data but not the Pivot Table itself.

For instance, if you have a large data file, the pivot table might become too heavy to bloat your workbook. Resultantly, you may want to remove the pivot table to reduce the size of your Excel workbook.

Let’s take the Pivot Table in the image below as an example. To remove the pivot table in the image below but keep the data, you may take either of the methods stipulated below.

Method # 1

• Activate any cell from the pivot table.
• Select the Pivot Analyze tab.
• From the Action group, choose the Select option.
• From the drop-down list, select the “Entire Pivot table” option. This selects the entire pivot table.
• Go to the Home tab.
• From the Clipboard group, select the Copy option to copy the entire Pivot table.
• Next, click on the Paste option or use the shortcut key ‘Ctrl + V’ after activating the cell where you want the data placed.
• In the drop-down menu for Paste options, select the ‘Value’ option.

Excel will remove the pivot table but keep the data contained in the Pivot table.

Method # 2

Another simpler way of deleting the pivot table while preserving the underlying data is through shortcut keys. Follow the steps listed below.

• Click any header of the pivot table.
• Press CTRL + A. to select the entire pivot table.
• Press CTRL + C to copy the pivot table.
• Press ALT +V to launch Paste options from the Ribbon area.
• Press V to remove the pivot table and paste the data values into respective cells. And you get only the resulting data from the pivot table.

3. Delete the Source Data but Preserve the Pivot Table

In the image below, a Pivot Table is created that consists of filters and headers for data analysis.

After using the analytical data from the pivot table, if you want to delete the resulting data while keeping the pivot table to use for data analysis later, follow the steps below.

Method # 1

• Select any cell from the pivot table. Select the Pivot Analyze tab.
• From the action group, choose the ‘Select’ option.
• From the drop-down list that then opens up, select the “Entire Pivot table” option to select the entire pivot table.
• Select the Clear option from the action group.
• A drop-down list will appear. Select the “Clear All” option from the list.
• It will clear the data inside your pivot table, and the pivot table is ready to use for newer datasets.

The data inside the pivot table has been removed, and the pivot table is ready to crunch newer datasets.

Method # 2:

Another simpler and faster way to perform the steps above is to use keyboard shortcuts. To delete data from your pivot table while keeping the pivot table using shortcut keys, follow the steps below.

• Click on any of the headers in the pivot table.
• Press CTRL + A to will select the entire pivot table.
• Select the Pivot Analyze tab.
• Select the Clear option from the action group.
• A drop-down list will appear. Select the “Clear All” option from the list.
• It will delete all the data values leaving the pivot table for the next data analysis.

4. Delete All the Pivot Tables from a Workbook

The above-mentioned methods work well when you have a single pivot table for your worksheet. What if you have multiple pivot tables on your worksheet? It may get super hectic to delete them all one by one.

However, to save you undue effort, we have a short VBA code that will help you delete all the pivot tables in your worksheet in one go.

The code is stated as follows.

Sub ClearPivotTables()

For Each ws In ActiveWorkbook.Worksheets

For Each PvtTable In ws.PivotTables

PvtTable.TableRange2.Clear

Next PvtTable

Next ws

End Sub

For example, to delete the following three pivots table simultaneously, you need to take the following steps.

To make the above VBA code work, follow these steps:

• Select the Developers tab. If you don’t see any Developers tab, you can get it by customizing your Ribbon options.
• Select the ‘Visual Basic’ option from the Ribbon.

• Excel will open up the VBA window.
• Select the Insert tab from the VBA window.
• From the drop-down list select the Module option to launch a module window.
• Copy-paste the above VBA code into this window.
• Close the window, and you are done.

To delete all the pivots tables from your workbook, click the play option from the VBA window. Excel will ask for your permission to run the code. Upon running the code, Excel will delete all the Pivot Table from your workbook in a snap.

Pro Tip:

Once the VBA code is run and the Pivot tables are deleted, you’ll not be able to restore them. So be sure when to use this code, and better create a backup copy to avoid losing these.

Conclusion

There are various methods to delete a pivot table or pivot tables in Excel. Whether you want to delete the entire pivot table along with the resulting data, or only want to delete the pivot table for your workbook to perform efficiently – this article elaborates on all the methods to delete Pivot Tables from Excel.

Keep coming back for more.