Excel does not scroll horizontal (can not read cells A1 thru Z1)

Does this problem only apply to a particular workbook or does it apply to all workbooks?

If only with a particular workbook then does the workbook have any macros (VBA code)? Because the scroll bar might be turned off with VBA code.

You could try the following VBA code to turn on the scroll bars. Irrespective of whether there is any existing VBA code, do this anyway. I’ll give you some guidelines to install the code in case you are not familiar with VBA.

Alt/F11 to open the VBA editor.

In the VBA Editor, Click on menu item Insert and then click Module in the drop down.

If VBA code already exists then in the Project Explorer on the left, take note of the module name you inserted. It should have light shading.

Copy the following code (between the asterisk lines only) and paste it into the white area of the editor.

'**************************************************

Sub DispScrollBars()

ActiveWindow.DisplayHorizontalScrollBar = True

End Sub

'**************************************************

Place the cursor anywhere in the sub by clicking anywhere between Sub DispScrollBars and End sub.

Press F5 to run the code.

Close the VBA editor by clicking on the cross with the red background top right of window.

Check if the scroll bar is visible.

You can delete the macro code by opening the VBA editor again with Alt/F11.

In the Project Explorer on the left, double click the module name you inserted and ensure that the code you just copied in is displayed. If any other code is displayed then it is probably code that should remain in the workbook so ensure that you have the correct module by double clicking the modules until you find the correct one.

In the Project Explorer on the left, Right click the module name that you inserted.

Select Remove ModuleX where X is the number of the module you inserted.

Answer No  to the question “Do you want to Export.........”

Close the VBA editor again by clicking the X with the red background top right of window.

If the code works and you continue to have a problem when you re-open the workbook and there is existing VBA code then the problem is probably in the code. You could open the VBA editor again and use menu item Edit -> Find and search for "DisplayHorizontalScrollBar" without the quotes. In the Find dialog box Set the search criteria to Current project

Still not getting the scroll bar.

I can right click on the file name of my active files on my screen comand line (gives restore, minimize, maximize).  Restore gives a blue title file name outline with the min, max, close symbols on the right side.  The vertical scroll bar is full (no movement).  The bottom line hase the previously mentioned "ready" line.  If I go back to the comand line file name and select "maximize", I get an added line above the "ready" line which has the control arrows on the left for "sheet 1, sheet 2, & sheet 3.  The vertical scroll bar can now move one cell.  Still no horizontal scroll bar.

I have kept experimenting with the Excel tool bar.  I have found that if I go to EDIT; GO TO; and then enter the cell number (such as "A1"); OK, that the screen will scroll all the way to the left and that conversly that by entering "AY1"; OK, that the screen will scroll to the right.  It's a work around, but it does what I need to be able to record my data.

Somehow, I should still be able to get the scroll bar.

Tools - options - has the horizontal scroll bar checked.  There are no vertical bars on the bottom of the screen.

At the bottom of my screen on the left it says "ready".  Towards the right there is a small rectangular empty box, a longer empty box, followed by 2 small empty boxs, then a box that says "NUM" (a right click gives a pull down giving "none, average, count,count nums,max, min, sum), then 3 more empty boxs.

Still no horizontal scroll bar.