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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920