Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,203
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Every 4th column in a range tied to a control cell [email protected] Excel Worksheet Functions 4 August 19th 08 03:41 PM
From single cell variables to a single column serie noyau New Users to Excel 1 December 22nd 06 06:43 AM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 [email protected] Excel Discussion (Misc queries) 0 May 12th 06 03:15 AM
How do I choose a cell colour, without it being tied to the data? Matt-e-gee Excel Discussion (Misc queries) 3 November 18th 05 08:22 PM
Why is my undo function in Excel only can undo the last 1 or 2 ch. 1111111111111111111111111111111111111111 Excel Worksheet Functions 1 November 24th 04 11:13 AM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"