Category: Excel

Automatically Highlight Active Row in Excel

I use Excel… a LOT, and for a very long time! With that comes the inevitable… my eyes aren’t as young as they used to be… plus, we tend to have a TON of data in our Excel file, sometimes making it harder to know which data is on the row that I am looking at.

I know, you can use themes, or highlight the row manually, but I want something dynamic. I want to highlight the active row (the row where my cursor is)… and I am greedy, I want it to change every time I change rows.

I personally think this should be a feature built into Excel, but I cannot find it anywhere – if you know of a different way, please post a comment below.

I’ve put together a few steps to automatically highlight my active row. Read on to see these steps and maybe put it to use for you!

Continue reading “Automatically Highlight Active Row in Excel”

Come See Me at Summit 2019: Excel Shootout

About My Session: Excel Shootout (GPUG)

One of my sessions, sponsored by the GP User Group, will be a fun and interactive competition on Excel functionality! My friends, Belinda Allen and Mark Polino, and I compete to show off our best Excel skills!

Track: Extracurriculars

Thursday, October 17, 2019 | 1:30 PM – 2:30 PM

Excel Shootout!

Continue reading “Come See Me at Summit 2019: Excel Shootout”

Come See Me at Summit 2019: Excel Life Hacks

About My Session: Excel Life Hacks (GPUG)

One of my sessions, sponsored by the GP User Group, will focus on an Excel Tips and Tricks – Life Hacks. We will cover overlooked functions, cool ways of handling certain situations, new functionality and MUCH MORE!

Track: Extracurriculars

Thursday, October 17, 2019 | 8:00 AM – 9:00 AM

Excel Life Hacks: Tips & Tricks to Save you Time!

Continue reading “Come See Me at Summit 2019: Excel Life Hacks”

Come See Me at Summit 2019: Getting Started with Power Query

About My Session: Getting Started with Power BI and Power Query (GPUG)

One of my sessions, sponsored by the GP User Group, will focus on Power Query – the background engine for Power BI!

Track: BI/Reporting

Wednesday, October 16, 2019 | 12:45 PM – 1:45 PM

Getting Started with Power BI and Power Query

Continue reading “Come See Me at Summit 2019: Getting Started with Power Query”

Come See Me at Summit 2019: Excel Life Hacks #BCUG

About My Session: Excel Life Hacks (BCUG)

One of my sessions, sponsored by the BC User Group, will focus on an Excel Tips and Tricks – Life Hacks. We will cover overlooked functions, cool ways of handling certain situations, new functionality and MUCH MORE!

Track: BC/NAV

Friday, October 18, 2019 | 9:45 AM – 10:45 AM

Excel Life Hacks – Tips and Tricks for Excel Users

Continue reading “Come See Me at Summit 2019: Excel Life Hacks #BCUG”