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

Transfer data from a cell to another workbook if certain criteria 14
Loan Payments P/Yr. 2
Recorded macro selection widened 4
COUNTIF NON DUPLICATED ROWS 2
Can't change the cell back to blank when there is a date in it. 0
Complex Question on Filtering on a merged column 1
How do I skip over null cells? 4
Fill down formula (but changing cell value by two) 1

Top