how to add the sharp flat and natural symbol in excel

You don't mix sharps and flats within one song. Similarly, in a sharp key (like G or D), you use only sharp names. This is what forces some keys, like F to be designated as 'flat' (if you tried to express it using sharp names, a letter of the alphabet would be used twice, and that makes reading notation confusing).Īnd once you're in a key that's designated as flat, you use flat names for all notes, both notes that are in the scale and those that you need that fall outside the scale.

That's how you get away with having the letter 'D' used twice, by writing in an exception to the normal rule.īut back to the basic major scale of the key - you can't use a letter twice.

but would have to add a natural symbol next to that note to 'wave off' the D# that this line normally indicates.

In written notation, you would write it as a D. You could just use the simplest name (D instead of C#). And you don't have to express those by adding an extra sharp to the basic scale note. On the other hand, in the key of Eb, it is the root and properly called Eb. But if one was playing in the key of E, the correct name is D#, which is the seventh major scale degree in the key of E. I'm not going to get my shorts in a knot if someone calls open string 2 of an E9 tuning Eb instead of D#. If you're talking about just naming the notes of a tuning, I don't think it matters what you call it. Notes off the diatonic major scale are then accidentals in that key signature. This minimizes the number of sharps/flats in that key signature's diatonic major scale. If you're playing in a sharped key: G, D, A, E, B, F# - then it's a sharp. If you're playing in a flatted key signature where the diatonic major scale contains the note: F, Bb, Eb, Ab, Db, Gb - then that note is the flatted version of the enharmonic pair. So what you name a black-key note depends on what key you're playing in relative to C. Guitars music is generally read in Concert C like a piano - i.e., non-transposing, unlike your horn.

How to add the sharp flat and natural symbol in excel