Quick tips on how to use your fantasy baseball cheatsheet

This post is specifically for anybody who has downloaded one of my fantasy baseball cheatsheets but found that it did not work as expected, or if the cheatsheet left you confused. I’ll walk through some solutions to the most common issues that I’ve heard about and some tips on how to best use the sheet.

There are a lot of features packed into the cheatsheets and some features go unnoticed despite them being super helpful, so I’ll make sure to highlight a few things to try out when playing around in these spreadsheets.

First Things First

Open the spreadsheet in Excel

As far as I know, you can only use this spreadsheet in a desktop version of Microsoft Excel on a Mac or a PC. There is custom code built into the spreadsheet that does not work in Google Sheets or Excel Online or any other spreadsheet software that may exist as of the time of this post.

Notice the pop-ups after you open the spreadsheet

Once you do open the sheet in Excel, there are a couple of hurdles to overcome. You may first get a pop-up that has an “Enable Editing” button that you need to press. That’s easy enough.

Then, you may get a second pop-up, as you see below, that says macros are disabled because you downloaded the file from the internet. Read more about this from Microsoft or just try one of the solutions below:

  • Solution 1: Go to the file, right-click on it and choose Properties and then check Unblock at the bottom.
  • Solution 2: For a long-term solution, search Internet Options on Windows, then choose the Security tab, then select Trusted Sites and add https://mrcheatsheet.com to the sites there. Uncheck the box at the bottom then save those settings. This will ensure all files downloaded from this site work in the future.
  • Or, check out the replies to this tweet to see if anybody has other ideas.

Getting Your Sheet Set Up

The DH/UT spot

When customizing the sheet to fit your league, one setting that trips people up is the DH/UT spot within the starting lineups. That’s because Yahoo calls it a Utility spot and other sites call it a DH spot. But, the idea with the cheatsheet’s DH roster spot is that any hitter could occupy that spot regardless of position.

Finding your league’s stat categories

Another potential issue is that some people download the wrong sheet. If you open up the sheet but can’t find your league’s scoring categories on the Settings tab, you may be in a Points spreadsheet when you should be in a Roto spreadsheet. Try downloading the other style of cheatsheet and see if that resolves your issue.

Check out the ‘Player Notes’ tab

I have a feeling that the Player Notes tab is an underlooked feature of the sheets so I do encourage you to check it out. There are three things I want to point out about this tab:

  • When you write a note for a player, that note will appear as a shortcut on the main draft page next to the player. On the main draft page, if you click on a player’s note then a pop-up will appear that will show the note that you wrote. This allows a quick way to give yourself more info about a player.
  • You can use the highlight feature on the Player Notes tab to make it so certain players stand out more on your main draft page. If you choose a red highlight for a player then their row will be highlighted in red on the main page. This is a great way to draw attention to sleepers or players that you want to avoid.
  • When a player is suddenly injured and out for the season prior to your draft, you can remove their data from the sheet by putting “Yes” in the Remove Player Data column on this page. The player will still be in the sheet but their stats will be removed so everything calculates more accurately.
How to handle keepers

There’s not one set way of dealing with keepers because every league is different. So, here are your options:

  • If you’re in an auction, go to the Auction Log or your main draft tab and enter the keepers in as if they were auctioned-off players.
  • If you’re in a draft and your keepers take the place of certain draft picks then enter the keepers on the Draft Log tab in the draft spot that they were kept.
  • Most commonly, if you’re in a draft and keepers don’t affect the draft order then enter the keepers on the Keepers tab.
Traded draft picks

If you’re in a draft and the league allows draft picks to be traded, you can makes changes to the draft order on the Draft Log tab.

How to solve a player like Ohtani

As a baseball fan, I love Shohei Ohtani. As a cheatsheet creator, I feared Shohei Ohtani because I knew he was going to change the game of fantasy baseball when he arrived.

I tried out a lot of different solutions to address the idea that some teams may draft Ohtani and choose whether to start him as a hitter or a pitcher each time they set their lineup. Ultimately, I decided that the best way to handle it in the sheets would be to make it so you choose whether the team gets his hitting or pitching stats for those leagues.

I’m only commenting on the Ohtani options because I’m open to feedback on this in the future. If you feel the cheatsheet isn’t using Ohtani in the best way for your league, leave a comment below.

It’s Draft Time

Conducting your draft

Clicking on a player’s name on the main draft page will automatically move the player to the box at the top. Then, if you’re in a draft, you just need to click the Make Pick button for the draft to move to the next team in the draft order.

Oops, I messed up the picks

If you picked the wrong player to be drafted, the easiest solution is to go to the Draft Log and clear out that pick. When you go back to the main draft tab then you can put in the correct pick.

Projected standings

Don’t forget to check the projected standings frequently during the draft so you can alter your strategy if needed.

I also recommend looking at the standings and then going to the Settings page and changing the projections to something else and looking at the standings again. Sometimes, one set of projections can give you too biased of a look so it helps to see how you’re doing across a few projections.

That’s It!

If you end up reading through this and still have issues using the cheatsheet, drop a reply in the comments with your issue. I’ll try to keep this updated by adding in any other issues that do get brought up.

You Might Also Like

  • Harrison
    03/13/2023 at 8:02 AM

    Luke, the tool was fantastic for my auction draft last night. Quick question on the rosters. Is there a way to move a guy into the starting lineup from the bench so the projected standings are more accurate? For instance, my Vlad Guerrero was moved to the Bench. Thanks

    • Luke
      03/13/2023 at 10:32 AM

      Crap, it looks like that was an issue with that one version of the cheatsheet… I put in a fix and Roto Auction v1.08 is on the site now and it should assign Vlad (and a few other players) properly but there was a bug in that last version of the sheet. If you transfer that data (using Save & Load) to the latest sheet, it should display correctly.

  • Loyal MrCheatSheet User
    03/13/2023 at 2:33 PM

    Thanks Luke! Did you ever get to look into the “don’t change team names after the draft starts” message you have? This may be difficult as my leaguemates may change their team names after I’ve entered their keepers into my spreadsheet (pre-actual draft, but the spreadsheet may think my draft started because of the keepers I entered)

    • Luke
      03/13/2023 at 4:43 PM

      If you change your team name after a draft starts, the Draft Log will display an error on all past picks for that team saying that the team name no longer exists since the picks would have been made by a team name that no longer exists. If you are worried about teams changing names then perhaps put the owners’ names in for the team name since I doubt they’ll change their legal names prior to the draft.

      • Loyal MrCheatSheet User
        03/13/2023 at 5:13 PM

        That is true, they likely will not change their legal names! Although, now that you explained that, couldn’t I theoretically change their team name on the Settings page and also their team name associated to any “draft pick” (in this case a keeper) they made in the Auction log?

        My use case doesn’t care about a team changing their team name after the actual Yahoo draft has started, just prep work entering keepers leading up to my draft.

  • Tom Kelso
    03/14/2023 at 3:12 PM

    Hi Luke,

    Quick question about Ohtani. It looks like you provide the ability to count his pitching “or” hitting stats. My crazy league allows Ohtani to count as one player and get both his hitting and pitching stats. Obviously, he is the number 1 target in our league. Is it possible to add the “and” case on the sheet so that standings reflect correctly?


    • Luke
      03/14/2023 at 5:14 PM

      In the one drop-down that says “Ohtani’s hitting stats only”, there should be an option that says “All of Ohtani’s stats” in that list. If you choose that then it should work as you expect!

  • Ryan Burnett
    03/15/2023 at 11:21 AM

    Hi Luke,

    Quick question regarding QS stat category for the points draft spreadsheet. We imported our own projections from Fangraphs and I noticed there wasn’t a QS column for imported projections tab and our league gives out points for QS but not W. In the league settings, I’ve updated the points as such where it should calculate points for QS and 0pts for wins. Does the sheet calculate QS even though there is not a column for QS for imported projections?

  • KT
    03/20/2023 at 12:07 PM

    Is it possible to make the cheatsheet sort by the Werth value instead of ADP?

    • Luke
      03/20/2023 at 12:08 PM

      Yup! At the top right on the main draft tab, there are a few different drop-downs that allow you to filter or sort that list in different ways.

    • KT
      03/20/2023 at 12:09 PM

      Oh, I am referring to the ‘Positions’ view

      • Luke
        03/20/2023 at 12:11 PM

        That’s not how it is currently programmed. Sorry if that doesn’t work for your needs!

  • KT
    03/20/2023 at 12:13 PM

    I’m not complaining :D. That positions page is just my favorite view of your great stuff!

  • AN
    03/20/2023 at 1:19 PM

    For Roto should I be focused on ADP or WERTH value more (or weighted between the two?

    • Luke
      03/20/2023 at 1:23 PM

      You know your league best. ADP gives you an idea of when guys are being drafted in a normal league based on the ADP source you choose in the Settings. WERTH shows you how valuable a player is based on your league settings. If the 20th ranked WERTH player is being drafted at 120 ADP on average then there’s no reason to draft him with your 2nd round pick as you know you can wait. But you know your league and whether they reach for players or not.

  • Greg
    03/20/2023 at 7:13 PM

    Hey man, love this beautiful piece of work every year. I’m having an issue where I usually don’t and it’s that I can’t color in cells on the positions page. Excel said i would need unprotect the sheet but that requires a password. What’s the best way to go about this? Thanks!

  • Kevin Quick
    03/22/2023 at 9:47 PM

    Is there a way to delete a draft pick? We use keepers by dollar amount, so some people may keep 5 players while others keep 9 or so. This translates into some people filling their roster earlier in the draft than others, so they fall out. Ive played around with it, but cant make it do this. Otherwise, love your spreadsheet!!!

    • Luke
      03/22/2023 at 10:13 PM

      It sounds like this would happen in the last rounds of a draft? If so, it may be easiest to just enter those picks directly into the Draft Log.

        03/23/2023 at 9:00 AM

        yeah, we carry a 23 man roster, so some teams go into the draft needing to draft more than others. Ill try doing it that way. Thanks!

        • Luke
          03/23/2023 at 9:04 AM

          For me, I’ll also say that I personally stop tracking every draft detail in the sheets once we get the starting lineups filled as there’s less to worry about at that point and it’s more about just grabbing the best guys for your bench as opposed to being worried how every pick may affect the standings. Everyone uses the sheets differently but you’ll find the way that works for you. Just don’t stress about getting every single pick represented if it ends up being too cumbersome with your draft style.

  • Luke Fisher
    03/23/2023 at 1:34 PM

    When I click on a player it says I need to unprotect the sheet, and asks for a password to do so. Any suggestions?

    • Luke
      03/23/2023 at 5:13 PM

      Hmm, that seems like odd behavior. You’re clicking on a player on the Draft tab, I assume? If not, which tab? Also, which version of Excel are you using?

  • Doug
    03/24/2023 at 2:14 PM

    Is there a way to assign late signing players to their correct teams (i.e., Jurickson Profar)? I play in an NL only league.

    • Luke
      03/24/2023 at 2:25 PM

      Ah, I can see the need for that… Unfortunately, I hadn’t built in a way to change player teams at the moment. Certainly, something I can consider for the future though. Sorry that it’s not in there currently.

  • Steve
    03/28/2023 at 5:28 PM

    Hi There, After reading your tip about using player notes and highlighted players I went to give it a try but received an error indicating that the sheet was protected. when I tried to unprotect, I was prompted for a password. Just to let you know…Thanks for all the work you’ve put into these sheets each year!

    • Luke
      03/28/2023 at 6:16 PM

      Thanks. That’s on the Player Notes tab where you enter the notes and highlight information? It’s not letting you change that info? Which sheet are you seeing that in?

  • Daniel Foote
    08/02/2023 at 10:51 AM

    Hello, I am making a 30 team league is there a way to up to do 30?

  • auction sheet
    11/14/2023 at 5:23 AM

    thank you for sharing information on this topic. Auction sheet verification is crucial to prevent fraud and ensure the vehicle hasn’t been in an accident or damaged. please visit our website auction sheet verification