MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Make A Personal Macro Workbook


May 5, 2021 - by Bill Jelen

Make A Personal Macro Workbook

Challenge: Macros stored in the Personal Macro Workbook are always at your disposal. You can run the macros on any workbook that you open on the computer. Also, you do not have to jump through security hoops to run macros stored in the Personal Macro Workbook.

If you have never used the Personal Macro Workbook, it does not exist on your computer. You need to create one.

Solution:

For Excel 2003 and Earlier

In Excel 2003 or an earlier version of Excel, open any workbook. Choose Tools, Macro, Record New Macro.

continue reading »

More Reading


Adjust Xy Chart Scaling For Correct Aspect Ratio

Adjust Xy Chart Scaling For Correct Aspect Ratio »

May 3, 2021 - by Bill Jelen


You want to adjust an XY (scatter) chart so that both axes have the same scale per unit axis value. You want to adjust an XY (scatter) chart so that both axes have the same scale per unit axis value.

Determine The Height And Width Of The Datalabel Object

Determine The Height And Width Of The Datalabel Object »

April 30, 2021 - by Bill Jelen


The DataLabel object does not have either a height or width property, and Excel does not permit the user to resize a data label. In some situations, you may need to determine these properties. A case in point is a series with long, wrapping label text or labels of points that are very close to each other, where it is intended to programmatically adjust label position to get rid of any overlaps.

read more articles »

Featured Products


MrExcel 2020 - Seeing Excel Clearly

January 2020

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.


Excel Dynamic Arrays Straight to the Point 2nd Edition

January 2020

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.


Power Excel With MrExcel - 2019 Edition

December 2019

This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.


Introduction to Financial Modelling

October 2019

With over 50 examples and an extended case study that creates a simple financial model from scratch to highlight the key concepts, this is a "hands on" book, focused on working with Excel more efficiently and effectively.


see more products »