#1   Report Post  
Posted to microsoft.public.excel.misc
DKS DKS is offline
external usenet poster
 
Posts: 103
Default View settings

I have a spreadsheet with 1100 rows and 60 columns. I had set a freeze pane
at row 6 and column 5 intersection.

This allowed me to scroll down and keeping the first 5 rows visible at all
times.

Recently a colleague of mine changed the spreadsheet settings. This had an
effect that when I scroll down, even though the cursor goes down, but on the
screen I do not see any movement, ie the top 20 rows that are visible by
default remain. If I unfreeze panes then it goes down where I need.

any idea what setting is changed by my colleague and how do I reset it?

Thanks in anticipation.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default View settings

Hi,
Maybe you are spitting the worksheet instead of freezing panes, or
vice versa
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
How to turn off Page Layout View as default view Colin Halliday New Users to Excel 3 October 12th 07 02:37 AM
column is hidden in normal view but not print view Bianca Excel Worksheet Functions 2 June 23rd 06 08:38 AM
settings not saved w/custom view DR support Excel Worksheet Functions 0 February 20th 06 05:15 PM
some view settings could not be applied AlanMagpie Excel Discussion (Misc queries) 0 October 14th 05 01:28 PM
Default View Settings Gina Setting up and Configuration of Excel 0 January 25th 05 05:35 PM


All times are GMT +1. The time now is 03:53 PM.

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

About Us

"It's about Microsoft Excel"