Excel - The Corner of My Selection Isn't Selected!: Episode 1563

2,207 views · Published 22 June 2012 · 2:51 · Indexed 6 November 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial: The corner of my selection in Excel is not selected!

Welcome to another episode of the “Don’t fear the spreadsheet” podcast, where we tackle all your Excel woes and fears. I am your host, Bill Jelen, also known as MrExcel. In today's episode, we will be addressing a common issue that many Excel users face - the corner of their selection not being highlighted. This can be frustrating and confusing, but fear not, we have some tricks up our sleeves to help you out.

Our viewer, Tyler Nash, reached out to us with this question and we are here to provide the solution. When you select a range in Excel, the cell that you started in may not be highlighted like the rest of the cells. This is because that cell is the active cell, meaning it is the one that will receive any data you enter. But don't worry, there are some handy tricks to make your selection process smoother.

One trick is to use the Control key along with the Enter key to quickly fill the entire range with the same value. This is especially useful when dealing with large ranges of data. Another useful shortcut is the Control + Period keys, which will move you to another corner of your selection. This is great for navigating between the top and bottom of a selection without having to unselect and reselect. These shortcuts may seem small, but they can save you a lot of time and frustration in the long run.

I also want to take this opportunity to recommend my book, “Don't fear the spreadsheet”, which is a comprehensive guide to mastering Excel. It's perfect for beginners and even advanced users can learn a thing or two. So don't be intimidated by Excel, let us help you conquer your fears and become an Excel pro. Thank you for tuning in and don't forget to subscribe to our channel for more helpful tips and tricks. See you in the next episode!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Question: How to select a range with the starting cell highlighted?
(00:45) Explanation of the active cell and its purpose
(01:28) Tricks for quickly filling a range with the same value and navigating within a selection
(02:35) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
Active cell selection
Control key and Enter shortcut
Control period shortcut
Corner of My Selection
Don't fear the spreadsheet
Episode number 2
Excel book recommendation
Excel for dummies
Excel tips and tricks
Filling a range with the same value
Highlighted range in Excel
Moving quickly within a selection

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153373/



When selecting a Range of Data, the Cell in the corner I start at is never selected; why? In Episode #1563, Bill explains that the cell is actually selected as part of your Range and why that particular Cell differs in color from the rest of the Cells that you've selected. From that point, Bill shows a variety of Excel Tricks to use when you have a Range of Cells selected.

"Don't Fear The Spreadsheet:A Beginner's Guide To Overcoming Excel's Frustrations" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen http://www.mrexcel.com/dftss_home.html

Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel - 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner - Tyler Nash - with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up - Kevin Jones, Tom Urtis and Bill Jelen

"This Book Makes Excel For Dummies™ Look Like It Was Written For Rocket Scientists!" http://www.mrexcel.com/dftss_home.html

More from this channel