From the course: Excel: Macros in Depth (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding when to use absolute or relative references
From the course: Excel: Macros in Depth (Microsoft 365)
Understanding when to use absolute or relative references
- [Instructor] We're looking at workbook called mailing list. It's got three sheets in it, the first one is a short list, it's about 45 rows or so, and the other two lists are much longer. What we'd like to be able to do is something relatively straightforward. We want the first three rows for each person's set of information here to be bold, then the next three to be italic. Then moving down to the next name, first three rows bold, next three italic, nothing too heavy duty. With only 45 rows or so here, we could certainly do this manually, wouldn't take that long, But we need to introduce the concept of two words you might not have heard yet in the macro environment, absolute and relative. On the view tab in the ribbon, if you click the arrow under macros, you will see a choice called use relative references. Slide over it and you get quite a lot of information popping up with some ideas about what we're about to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.