I cannot extend cells using Shift+arrow keys; I cannot Autosum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Essentially, I cannot use the worksheet cell functionality.
I cannot extend cells to Cut & Paste/Copy & Paste data onto another worksheet
I cannot Autosum because I appear to be locked into an individual cell; the
Shift+Arrow function does not work.

Your (collective contribution) to a solution is eagerly awaited.

Frank
 
Not sure whether there could be a restricted scoll macro in the book ?

Try this quick check/action on a spare copy:

Right-click on the Excel icon just to the left
of "File" on the menu > Choose "View Code"
(This will bring you direct into the "ThisWorkbook" module)

In the whitespace on the right, do you see something like:

Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "b2:b2"
Worksheets("Sheet2").ScrollArea = "c2:c2"
End Sub

If so, delete the lines

Worksheets("Sheet1").ScrollArea = "b2:b2"
Worksheets("Sheet2").ScrollArea = "c2:c2"

then save and exit.

Re-open the book and test it out ..
 
Your (collective contribution) to a solution is eagerly awaited ..

... and your feedback (did it work ?) is also eagerly awaited <g> ..
 
Back
Top