Hello Excellers, and welcome back to another #Excel blog post in my 2021 series. Today I will show you how to achieve the same effect in Excel, without actually merging cells in Excel. Confused?. Don't be. Do you use merged cells in your Excel worksheets?. Have you come across issues when you try to write formulas such as XLOOKUPS and VLOOKUPS. Well, those merged cells are probably causing the issues. We can use Center Across Selection as a great alternative. Some while users love … [Read more...]
Turn Of The Double Click Drill Down In Your Pivot Table.
by Barbara

Hello, Excellers welcome back to another blog post with an Excel Pivot Table Tip. 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. Drill Down Into A Pivot Table. 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 … [Read more...]
Evil Halloween Excel Trick-A Spreadsheet That Scrolls Backwards
by Barbara

Hello, Excellers. Want a Halloween trick Let's have a bit of fun and be a bit evil?. It is Halloween after all. How about a worksheet prank?. A spreadsheet that scrolls backwards with this Evil Halloween Excel Trick. Only send this to your friends and colleagues who would take a joke now. Really. It is very frustrating. I did warn you. This workbook just does not seem correct somehow. So, it scrolls the opposite way you would expect. I have great fun with an … [Read more...]
How To Fit Longer Text Into Excel.
by Barbara

Hello Excellers. Welcome back to another Excel Tip. Today I will show you how to fit longer text into Excel. This is a simple trick. I have been asked this question recently so thought it was worthy of a short Excel blog post. Do you ever have a long line of text in Excel? It may look at bit like my screengrab below. Sometimes if you have a free text notes column or even longer names or addresses you end up with text running over multiple Excel cells. So, if you look at … [Read more...]
How To Use The Quick Analysis Tool In Excel.
by Barbara

From Excel 2013 onwards, the quick Analysis Tool makes it really easy to analyse your data quickly and easily. It contains a variety of Excel tools. The tool can be used with data from a range of cells or an Excel data table. How To Access The Quick Analysis Tool. So, it is really easy to get started with the Quick Analysis tool. Once you select a range of cells or an Excel data table, the tool appears at the bottom right of your data set. A range of analysis tools is now available to … [Read more...]
- 1
- 2
- 3
- …
- 47
- Next Page »