Skip to content
Learning the Fretbo...
Clear all

Learning the Fretboard

8 Posts
8 Users
Reputable Member
Joined: 18 years ago
Posts: 371
Topic starter  

I made a spreadsheet for myself to help me memorize my fretboard and I thought I would share it with all of you. There is one for 4-string bass and another for 6-string guitar. Let me know what you think.

You can download them here:

You will need to have Microsoft Excel installed on your computer.

Trusted Member
Joined: 20 years ago
Posts: 68

It seems like a nice tool to save on my laptop. It's good to have something entertaining to do when you could be doing WORK.

Thank you.

New Member
Joined: 17 years ago
Posts: 1

Thanks for posting this. I surely will make use of it.

Estimable Member
Joined: 16 years ago
Posts: 121

Nice work.
If you like this kind of thing (indeed, its good to hunch over the laptop screen and appear to be working :twisted: ) you should also check out the free software at: Its called fretpro.

“Poetry and Hums aren't things which you get, they're things which get you. And all you can do is go where they can find you.” - Winnie the Pooh

Reputable Member
Joined: 19 years ago
Posts: 375

Thanks there RIFF RAFF! For BARRE Chords I try to remember the notes (well chords) at the 3'rd , 5'th, 7'th and 9'th frets for
E and A.

Bob Jessie

Reputable Member
Joined: 16 years ago
Posts: 270

Very nice, just downloaded it in college and it took me 5 minutes to do, if i do that every day ill know the fret board in no time :lol:

David Watts
Takamine G-Series - £229
Fender STD American Telecaster (Cola Red) - £849
Vox 15watt AMP (Valve pre amp) - £129
Acoustic/Electric Rhythm and Lead (Occasionally) Southport Elim Youth Band
Former Aftershock 24/7 Rhythm Guitarist (Band split)

Reputable Member
Joined: 19 years ago
Posts: 267

I really like this. Thanks riff raff. Using Excel for such a cool purpose, really seems like "sticking it to the man".

Ghost Rider 8)

"Colour made the grass less green..." 3000 miles, Tracy Chapman

Noble Member
Joined: 19 years ago
Posts: 1024

Once you get the 5th and 6th strings memorized (ie for barre chords and power chords).

Here's a cool way to find notes on the 4th and 3rd string.

I call it the 2x2 rule. Take the note on either the 5th or 6th strings.

Say... root 6 3rd fret....... a "G" right?
Now, go down two strings and up(toward the body) two frets....2x2 = 4th string 5th fret...right? Guess what..its a "G".

Root 5, 5th fret...quick.... its a "D" 2x2 3rd string 7th fret.... also a "D"

This only works where the root is on the 5th or 6th strings and only with "Standard Tuning" far as I can tell. :)

Research is what I'm doing when I don't know what I'm doing. - Wernher Von Braun (1912-1977)