Photo: Mike B

What does Shift F8 do?

So, SHIFT + F8 allows us to select non-adjacent cells. As in our previous example, make sure you see the text in the status bar only this time it should read “Add or Remove Selection”. And how does it work with the SUM function?

excelolympics.com - Selecting Cells in Excel using the F8 key

How many chord shapes are there?

Practicing the five shapes in various positions along the fretboard will develop your vocabulary of sounds and give you more room to...

Last updated Dec 4, 2020

What level is Fur Elise?

grade 5 The full version of Fur Elise is considered reasonably difficult, broadly an intermediate piece around grade 5, but a shorter arrangement...

Last updated Mar 4, 2020

Join almost HALF A MILLION Happy Students Worldwide

Promotion

This blog post also features a YouTube twin that you can watch here or if you scroll down to the end of this post.

F8 – Extend selection

We always want to make sure, that proper ranges are selected in Excel. A wrong selection, as we already know, can lead to costly mistakes. To avoid this kind of unpleasant situation, it is paramount that we can make precise and quick selections in Excel. Microsoft Excel team came up with a key that helps you with selections. That key is F8. What does it do? Let’s take a look at an example. Suppose we want to sum up the Apples column. With help from the good old CTRL + SHIFT + Arrow key, we select data all the way until the next empty cell, but that won’t do. Anyway, let’s start our formula inside cell E8 =SUM(

Let’s focus our attention on the Apples column. Click on Cell B2.

Once selected, press F8. In the bottom left corner (in the status bar), you should see something like this. Check if you see the Extend Selection sign. If you do, just click on the last cell with data (B10). Excel literally extended the selection for us, so we made sure that all the data is being summed up. You should think of this as if you were holding the Shift key while clicking on the last cell. Now all you need in your formula is a closing bracket and a satisfying press of the Enter key. This shortcut is meant for selecting non-adjacent cells (cells that do not touch each other). Let’s dive directly into it. Suppose we would like to sum up data occurring on dates from 1st to 3rd and from 9th to 12th of May. SUMIFS could do the job but it would be like taking an airplane for a 2-mile trip. A simple SUM function could solve it if you could only make the right selection of data. Let’s look at how we select data using the SHIFT + F8 key combination. So, SHIFT + F8 allows us to select non-adjacent cells. As in our previous example, make sure you see the text in the status bar only this time it should read “Add or Remove Selection”. And how does it work with the SUM function? Let’s take a look. Note: Good practice is to select the first part of the range you want to sum up, and press SHIFT + F8 afterward. As in other Excel operations, you can cancel this one by pressing the ESC key or just simply by scrolling down.

Brilliant, right? Now it’s YOUR TURN TO EXCEL.

Do thicker picks sound better?

Thick guitar picks will provide mellower/darker tones. The common rounded edges that can be manufactured with thicknesses over 1 mm – combined with...

Last updated May 18, 2019

What is the key signature for 12-bar blues?

The term "12-bar" refers to the number of measures, or musical bars, used to express the theme of a typical blues song. Nearly all blues music is...

Last updated Jan 10, 2020

Promotion

What does Control E do?

Ctrl+E in an Internet browser In Chrome, Edge, Firefox, Opera, and Internet Explorer, Ctrl + E focuses on the address bar, search bar, or omnibox. Using this shortcut can be helpful when you're done browsing the current page and want to type in a new address or search for something else without using the mouse.

computerhope.com - What Does Ctrl+E Do? - Computer Hope

Ctrl+E

Alternatively written as Control+E, ^e, and C-e, Ctrl+E is a keyboard shortcut that varies depending on the program. For example, in most Internet browsers, Ctrl+E is used to focus on the address or search bar.

How to use the Ctrl+E keyboard shortcut

To use this keyboard shortcut, press and hold either Ctrl key, and while continuing to hold, press E .

Ctrl+E in an Internet browser

In Chrome, Edge, Firefox, Opera, and Internet Explorer, Ctrl + E focuses on the address bar, search bar, or omnibox. Using this shortcut can be helpful when you're done browsing the current page and want to type in a new address or search for something else without using the mouse.

Ctrl+E in Microsoft PowerPoint

In Microsoft PowerPoint, Ctrl + E aligns an object with the center of the slide.

Ctrl+E in Microsoft Word

In Microsoft Word, pressing Ctrl + E changes the alignment of a line or selected text so that it is centered on the page.

Ctrl+E in Google Sheets

In Google Sheets, pressing Ctrl + E collapses an expanded array formula.

Using Ctrl+E with Skype

In Skype, pressing Ctrl + E hangs up the current call.

Related keyboard shortcuts and keys

Below are links to related keyboard shortcuts and individual key pages.

Address bar, Ctrl, E, Keyboard shortcut, Keyboard terms

Are musicians highly sensitive?

Most of the musicians were highly sensitive people (HSPs). Despite their exuberant antics onstage, the bright lights and loud noise of the concert,...

Last updated Feb 20, 2020