Hello, Excellers welcome back to another #Exceltips blog post in my 2021 series. Today let's look at using the Paste Special Function in Excel. Have you a worksheet with the % (percentage) formatting missing?. If you ever have tried to correct this then you know you could try to adjust the formatting of the cell. But, that just ends up looking like the screenshot below right?. Who wants to edit each cell with %?. Well, by using Paste Special we can … [Read more...]
Quick Way To Remove Blanks -Excel Data Tidy Up.

Hello, Excellers. Welcome to another Excel Tips post in my 2021 series. In this blog post, I will share with you how to quickly remove blanks or spaces from your data set. This super quick method in Excel is great for data tidy up. The Paste Special function is used. So, let's get some data tidy up done. Here is a sample data set to use. Some blanks still remain from a previous data tidy up step. These probably have been left from a previous step in the process of data tidy … [Read more...]
Formula Friday – Applying Names To Your Existing Excel Formulas.
by Barbara

Hi Excellers, #formulafriday time again. Welcome back to another blog post in my 2021 series. Today is a bit different, I want to share with you how to rename or apply names to formulas that you may already have in your Excel worksheet. Let's take a look at an example. So, for example, you have inherited a worksheet that calculates the Sales Tax applicable to your monthly sales. Currently the value for Sales Tax sits in cell G1. Now, I like to use named ranges in my formulas, (if … [Read more...]
Macro Mondays – Running An Excel Macro From The Immediate Window
by Barbara

Hello, Excellers welcome to another #MacroMonday #Excel blog post in my 2021 Excel Macro series. Today let's take a look at using the Immediate Window in the Excel VBA debugging environment. This environment can be used as a type of scratchpad or sandbox area and has many uses as well as debugging code. You will need to first Enable The Developer Tab if it is not already enabled. You can watch my YouTube Video for instructions. https://youtu.be/CYcyoBMTZ44 If you … [Read more...]
Drill Down Option In Excel Pivot Table.
by Barbara

Hello, Excellers. Welcome back to another #Excel Tip blog post. This Pivot Table blog will take you through the Drill Down feature in Excel Pivot Tables. When you create a Pivot Table in Excel, each of the values represents one line of data or record in that data set. The Pivot Table creates a summary of your data set. Let's use an example in this blog post. You can download the sample data set and Pivot Table, by clicking the download button below. I have a very simple data set and … [Read more...]
- 1
- 2
- 3
- …
- 10
- Next Page »