ExcelBanter - how to undo scrolling tied to a single cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to undo scrolling tied to a single cell (https://www.excelbanter.com/excel-worksheet-functions/257140-how-undo-scrolling-tied-single-cell.html)

tom

how to undo scrolling tied to a single cell

when I click on any cell in my spreadsheet I pick up all the surronding cells
no matter where I am on the spreadsheet. For example, if the "frozen' cell
is G6 and I click on D4 the spreadsheet shows D4-D6, E4-E6, F4-F6 and G4-G6.
I don't know how this occurred or how to make it go away. Any suggestions?

JLatham

how to undo scrolling tied to a single cell

Press [F8] ... it's a toggle, so if that doesn't cure the problem, press it
again.

"Tom" wrote:

when I click on any cell in my spreadsheet I pick up all the surronding cells
no matter where I am on the spreadsheet. For example, if the "frozen' cell
is G6 and I click on D4 the spreadsheet shows D4-D6, E4-E6, F4-F6 and G4-G6.
I don't know how this occurred or how to make it go away. Any suggestions?

All times are GMT +1. The time now is 09:47 PM.