How To Control When Excel Warns You About Large Scale Cell Changes. Excel Tip
Picture this. You are about to make changes to a lot of cells on your Excel worksheet. Maybe you have updated a lot of formulas, or pasted a lot of new cell contents?. Excel sometimes warns...
How To Write A Macro Which Saves A Daily Copy Of your Excel File- Macro Mondays.
Welcome back to another #macromondays post. Today I want to share with you how to write a small piece of VBA code which creates a macro to save a copy of your Excel file on daily basis. Each of...
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...
How To Convert Date Formats In Get And Transform/Power Query – Excel Power Tip
Hello Power Excellers. In this blog post, I want to share with you two ways to convert dates in Excel Power Query. Why are there multiple ways?. Well one of them uses and Menus available on...
How To Write An Excel Macro To Log Changes To An Excel Workbook – Macro Mondays
Do you like a bit of Big Brother?. Or do you just want to know if someone has changed something on your Excel worksheet? Either way, here is how to track and document changes to an Excel workbook...
Hi Excellers. Today it is time for some more formula fun. Here is one way to display percentages and numbers together in one column that are currently stored in separate columns on a worksheet,...