Hello, Excellers. Time for another Excel tip. I want to share with you a question from a subscriber. How to copy a worksheet It is going back to basics. They needed to take one worksheet from a sales workbook and create another workbook with just that one worksheet. They previously had been making a copy of the workbook and then deleting the extra unnecessary worksheets they did not need. Copy Your Excel Worksheet. There is a quick and easy way to do … [Read more...]
Get Quick Statistics About Your Excel Workbook.
Hello, Excellers. I think this next #Excel tip will come as a relief, especially if you have inherited a workbook. Yes, quick statistics about your Excel workbook are now available.!. You may need to know how many Pivot Tables, Macros, formulas and tables you have in a workbook. This new feature was made available in April 2020. It is now available in the following versions. Watch The YouTube Video. https://youtu.be/j9yinn3cJAw Excel for Microsoft 365 Mac Excel … [Read more...]
Macro Mondays – Running An Excel Macro From The Immediate Window
Hello Excellers welcome to another #MacroMonday #Excel blog post in my 2020 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 areas and has many uses as well as debugging code. If you cannot see the Immediate Window, you just need to enable it. It really simple. Open the Visual Basic Editor View Immediate Window Or if you are mad for shortcuts, then you can do the … [Read more...]
A Super Quick Way To Unprotect Multiple Excel Worksheets
Hello Excellers, welcome back to another #Excel tip in my 2020 series. Today I will show you how to unprotect multiple Excel worksheets really quickly. Have you created an Excel workbook with multiple Excel worksheets that are protected and then at a later date have to unprotect each worksheet individually?. Maybe you need to update your formulas?. For example, I have a number of reports that have 15+ worksheets. All of those worksheets are protected. Do I need to manually go into each of … [Read more...]
How Find and Replace Exactly In Excel
Hey Excellers. Today I will show you how to use the Find and Replace in Excel. Specifically to replace exactly only the values you need to. This blog post is in response to a question a colleague asked last week. They needed to find all cells that contained zero and replace them with a blank without affecting the zeros appearing in other cells. For example 100, or 1000. Only the cells that contained ONLY 0 needed to be replaced. The solution is really simple, as long as you know which … [Read more...]
- 1
- 2
- 3
- …
- 9
- Next Page »
Recommended Excel Resources
