how to undo scrolling tied to a single cell

T

Tom

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if function error 3
Varying cell ranges in formulas according to number of cells with certain value 1
Transfer data from a cell to another workbook if certain criteria 14
Recorded macro selection widened 4
COUNTIF NON DUPLICATED ROWS 2
Is a Nested Formula what I need? 1
Fill down formula (but changing cell value by two) 2
Excel Formula Formatting - How to Add a STOP Statement 4

Top