Setting Desired Options?

[g_b]

I am having difficulty with excel 2007. In the excel options, I click a checkmark for vertical and horizontal scroll bars. No scroll bars appear. I'd like to be able to set the scroll bars as well as the scroll buttons at top,bottom, left and right PERMANTLY, not "just for this workbook."

Additionally, I do NOT see any workbook sheet names. I've looked over the screen and in the options to determine how to make the names appear to no avail.

How do I set options or preferences to get scroll bars, their associated buttons, and be able to select workbook sheets?

 

[Jimmypop]

Hi there

To permanently set the scroll bars and buttons in Excel 2007, you can follow these steps:

1. Click the Office button in the top left corner of the Excel window.
2. Click on the Excel Options button located at the bottom right of the popup window.
3. In the Excel Options dialog box, click on the Advanced tab.
4. Scroll down to the Display options for this workbook section and make sure the Show horizontal scroll bar and Show vertical scroll bar options are checked.
5. Under the Display options for this workbook section, you will also find an option for Show sheet tabs. Make sure that is checked as well.
6. Click on the OK button to apply the changes.

If the above steps don't work, you can try resetting Excel's settings to the default. To do this, follow these steps:

1. Close Excel.
2. Click the Start button and type "Run" in the search box.
3. In the Run dialog box, type "excel.exe /resetuserdata" (without the quotes) and press Enter.
4. Excel will start up with its default settings. Try checking the options for the scroll bars and sheet tabs again.

If you still don't see the scroll bars or sheet tabs after trying the above steps, it may be a problem with your installation of Excel. You may need to repair or reinstall Excel to fix the issue.

 

[g_b]

Hi there

To permanently set the scroll bars and buttons in Excel 2007, you can follow these steps:

1. Click the Office button in the top left corner of the Excel window.
2. Click on the Excel Options button located at the bottom right of the popup window.
3. In the Excel Options dialog box, click on the Advanced tab.
4. Scroll down to the Display options for this workbook section and make sure the Show horizontal scroll bar and Show vertical scroll bar options are checked.
5. Under the Display options for this workbook section, you will also find an option for Show sheet tabs. Make sure that is checked as well.
6. Click on the OK button to apply the changes.

If the above steps don't work, you can try resetting Excel's settings to the default. To do this, follow these steps:

1. Close Excel.
2. Click the Start button and type "Run" in the search box.
3. In the Run dialog box, type "excel.exe /resetuserdata" (without the quotes) and press Enter.
4. Excel will start up with its default settings. Try checking the options for the scroll bars and sheet tabs again.

If you still don't see the scroll bars or sheet tabs after trying the above steps, it may be a problem with your installation of Excel. You may need to repair or reinstall Excel to fix the issue.

Jimmypop
Thank you very much for the correct response. The options you stated to set were set accordingly. The reason I could not see the scroll bars was because the window within the window had been positioned so that the scroll bars were not visible. Because the interface on a Mac does not allow this situation to occur, and I'm not an effective user of Windows, I did not notice this. - Thank you!