AUTO-COMPLETE IN GREEN CELLS
Problem: If I type one or two letters in a cell, words from other cells are automatically entered.
Fix: Disable “AutoComplete” function.
Instructions:
1. Click on “File” tab.
2. Click on “Options” (located in left column below “Help”).
3. Click on “Advanced”.
4. Under “Editing Options”, uncheck box next to “Enable AutoComplete for cell values”.
5. Click on “OK” at the bottom left of that screen.
X’s IN CELLS
Problem: If I type in large numbers, they show as x’s on my screen.
Fix: Expand view so that numbers fit into cells.
Instructions:
1. Click on “View” tab.
2. Click on “100%” icon.
CURSOR MOVES DOWN
Problem: After I enter something in a cell and hit “enter” on my keyboard, the cursor moves to the next cell down instead of to the next cell to the right.
Fix: Change default setting.
Instructions:
1. Click on “File” tab.
2. Click on “Options” (located in left column below “Help”).
3. Click on “Advanced”.
4. Under “Editing Options”, check the box next to “After pressing Enter, move selection”.
5. Below that, next to “Direction:”, select “Right” from the drop-down menu.
6. Click on “OK” at the bottom left of that screen.
CAN’T READ FORMS ON SCREEN
Problem: It’s difficult to see and read the forms on my computer screen.
Fix: Adjust view settings.
Instructions:
1. Click on “View” tab at top of screen.
2. In the “Workbook Views” section, select “Page Layout”.
3. In the “Show” section, uncheck the boxes next to “Ruler”, “Gridlines”, “Formula Bar”, and “Headings”.
4. In the “Zoom” section, select “100%”.
FORMS PRINT ON MULTIPLE PAGES
Problem:The forms print out on multiple pages.
Fix: Adjust the margin settings.
Instructions:
1. Under the “Page Layout” tab, select “Margins” from the menu.
2. Then select “Custom Margins”.
3. Reset the top, bottom, left, and right margins at .25” and the header and footer at .3” and click OK. The page should now view correctly.
“GCB USE” PAGE PRINTS ON MULTIPLE PAGES
Problem: The “GCB Use” worksheet prints on several pages when I print out the forms.
Fix: Don’t print the “GCB Use” page. This worksheet is not meant to be printed.
Instructions:
Refer to the “Filing the Monthly Reports” section for printing instructions.
DIDN’T RECEIVE CONFIRMATION EMAIL
Problem: I emailed my GCBREPORTS file, but didn’t receive a confirmation email.
Fix: :There are several reasons why this may happen. Below are three causes that have come to our attention along with instructions on how to fix each problem.
1 - Email address was entered incorrectly.
Fix: Go to your email program’s “Sent Items” folder. Double-check the accuracy of the email address entered. The address should be gcbreports@state.mn.us. If an error was made, send another email to the correct address.
2 - Your email program put the confirmation into your Spam/Junk folder.
Fix: Open your email program’s “Spam” or “Junk Email” folder. Then look through the list of emails received to determine whether you received an email from “Minnesota GCB”. If the confirmation email did go into your Spam/Junk folder, add the following email address to your email “address book” or “contacts”: minngcb+canned.response@gmail.com Future confirmations should then automatically go to your regular “Inbox”.
3 - Your email program simply won’t accept a confirmation email from the address minngcb+canned.response@gmail.com.
Fix: This problem occurs more often for those using a company or governmental entity’s email account. Those accounts may be set up to not accept any automated responses as a safeguard against someone purposely trying to overwhelm and shut down their entire email system. If so, it is recommended that you establish a new email account with a popular email provider such as Google or Yahoo. Then resend your GCBREPORTS file to gcbreports@state.mn.us. If you still don’t get a confirmation, check items #1 and #2 above.