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...]
How To Prevent Users Printing An Excel Workbook
by Barbara

Welcome back Excellers to another #MacroMonday in my Excel 2020 series. Today, I will show you how to prevent users from printing an Excel workbook. This blog post is in response to a request for this Excel solution from a subscriber. The solution to this was to write a very basic and simple Excel VBA Macro. I thought it would be a useful share with you all. Don't get scared off, its a little Visual Basic (VB) for Excel. It is straightforward. Why not give it a go?. The request was to … [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...]
IF Statement For Last Day Of The Month.
by Barbara

Hello, Excellers and welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today I want to answer a question that a subscriber sent to me. If you want to ask any questions or comment feel free to leave a comment below. The question was, how to use the IF Function in Excel to identify if a cell contained the last day of the month. So, why did they want to know this?. Well, on the last day of the month, They Wanted to automatically insert … [Read more...]
Excel Tip. Automatically Add New Items To Drop Down Lists
by Barbara

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...]
- 1
- 2
- 3
- …
- 7
- Next Page »