Hi Excellers, welcome back to another #Excel tip. Today I want to show you how to set up a data drop-down list that is automatically updated when we add new items or options to the list. Dropdown or data validation lists are really useful when you want to control data entry into your Excel workbook. By giving the user limited options, you control the quality of the data that the user enters. You can follow these simple steps to make your drop-down lists dynamic, so they update … [Read more...]
Turn Of The Double Click Drill Down In Your Pivot Table.
Hello, Excellers welcome back to another blog post with an Excel tip I wanted to share with you. In today's blog post let'stake a look at how to turn OFF the option of a user Double Clicking in your Excel Pivot Table to drill down into the data. By double-clicking on the data in the Values Area of your Pivot Table you can extract the underlying records These are the records that make up that data. See the screencast below for an example. (You can also Rick- Click and … [Read more...]
Excel Tutorial- Add Your Own Macros To The Excel Ribbon Tab
IHello Excellers, welcome back to today's #excel #macromonday blog post in this 2019 series. Today I will show you how to add your own Excel macros you have written to the ribbon. With Excel 2010 onwards you can create your own Ribbon Tabs. You can also add your own Macros to them! Let's learn how really easy this is to do. It is really useful to have a set of commands you use on a regular basis. I like to keep them on a totally separate tab. In my example in this tutorial let's create a … [Read more...]
Excel Shortcut -Quickly Box Off Cells
Hello Excellers, it has been a short while since I shared some simple Excel tips. So today I want to share an Excel shortcut with you. So, today let's look at how to quickly box off cells in your Excel range. We all love a shortcut, don't we?. I use this every week on my reports. The Ctrl+Shift+& shortcut. This will put an outside standard cell border to your selected cells. you can see how easy and quick this is in the screencast below. Similarly, if you … [Read more...]
MS Excel Tutorial- How To Show Formulas In Excel With A User Defined Function – Formula Friday
It sometimes it is really useful to show your Excel formulas on your worksheets. This gives an insight into the logic of the worksheet. It also is a great way to check your formulas to ensure they look correct. Excel has a built-in option for this already if you want to toggle between a normal view of your worksheet as well as show your formulas. Follow the instructions below. Formula Tab Formula Auditing Show Formulas You can also quickly … [Read more...]
- 1
- 2
- 3
- …
- 7
- Next Page »
Recommended Excel Resources
