Use End Mode In Excel For Fast Selection

Most Excel users will know about the Fill command, which can be used to rapidly copy data and formulas into a group of cells. But there’s also a related option that can make it easy to add selected data: end mode.

Microsoft’s Excel blog details the intricacies of the feature, but the short version is this: hit the End key on your keyboard to switch End mode on, then use shift plus an arrow key to select all the cells containing content in a given row or column. After selecting, you can also use Control+Enter to copy the text in the active cell into all selected cells. It’s not necessarily a shortcut you’ll use every day, but it’s good to have in your Excel arsenal.

Speed up data-entry tasks by using End Mode [Excel Blog]

The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.


3 responses to “Use End Mode In Excel For Fast Selection”

Leave a Reply