Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I cannot extend cells using Shift+arrow keys; I cannot Autosum
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 |
#2
|
|||
|
|||
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 .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "KangaFrank" wrote in message ... 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 |
#3
|
|||
|
|||
Your (collective contribution) to a solution is eagerly awaited ..
... and your feedback (did it work ?) is also eagerly awaited <g .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow Keys no Longer Work | Excel Discussion (Misc queries) | |||
How can I fix the function of the arrow keys? | Excel Discussion (Misc queries) | |||
arrow keys in excel | Excel Discussion (Misc queries) | |||
In Excel keyboard arrow keys no longer work | Setting up and Configuration of Excel | |||
instead of moving cells my arrow keys scroll the page | Excel Discussion (Misc queries) |