Use A Macro To Highlight The Active Cell

June 14, 2021 - by Bill Jelen

Use A Macro To Highlight The Active Cell

Challenge: Microsoft changed the selection highlighting in Excel 2007. If you select 20 cells, Excel highlights those cells in super-ultra-light blue. Imagine if you had 5 gallons of white paint and dropped in one drop of blue paint. That paint would have more color than the new selection color in Excel 2007. You want to highlight the active cell so it’s easier to spot.

Solution: There is a cool event macro that can add a splash of color to the selection and draw crosshairs to help you locate the row and column where the active cell is located. In Figure 141, bright yellow highlight indicates the active cell in D16. Lighter yellow is used to mark column D and Row 16. As you move the cell pointer, the highlights change. Figure 142 shows the crosshairs pattern for B20.

continue reading »

More Reading

Add Filter To Selection Functionality

Add Filter To Selection Functionality »

June 11, 2021 - by Bill Jelen

Access offers a cool feature called Filter to Selection. If you are looking at a data sheet in Access, click the value XYZ in Field22 and click Filter to Selection, Access shows you only the records where Field22 is equal to XYZ. Excel does not offer this feature. Instead, you have to turn on the Filter (known as AutoFilter in Excel 2003 and before) and choose the desired value from the Filter dropdown.

Copy The Personal Macro Workbook To Another Computer

Copy The Personal Macro Workbook To Another Computer »

June 9, 2021 - by Bill Jelen

You have a bunch of cool macros in your Personal Macro Workbook. You would like to get them in a co-worker’s Personal Macro Workbook.

Create Worksheet Names By Using The Fill Handle

Create Worksheet Names By Using The Fill Handle »

June 7, 2021 - by Bill Jelen

You type Jan into a cell, grab the fill handle, and drag down five cells. Excel types Marcia, Cindy, Bobby, Greg, and Peter. No, sorry. Excel types Feb, Mar, Apr, May, Jun. The fill handle can do all sorts of amazing fills, handling months, quarters, weekdays, dates, and so on. If you set up a custom list, Excel can even extend your list of departments, products, or Brady Bunch kids.

read more articles »

Featured Products

Continuing Financial Modelling

November 2020

You wait for one decent Financial Modelling book to come out and then two come along at once. This edition is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business / decision analyses, forecasting, and valuations.

Excel 2019 Business Basics & Beyond

September 2019

Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.

MrExcel 2021 – Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

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.

see more products »