|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
01-24-2007, 05:52 PM
|
#1 |
|
Member (10 bit)
Join Date: Aug 2005
Location: Vancouver, BC, Canada
Posts: 976
|
MS Excel help
how do i control workbook scrolling so only part of the cells scroll (allowing me to keep the important data visible while i scroll and adjust distant cells)?
here's an example of what i mean.
__________________
If you remind me of my dog... we'll probably get along. |
|
|
|
01-25-2007, 12:15 AM
|
#2 |
|
Member (10 bit)
Join Date: Jul 2002
Location: Trivandrum, India
Posts: 800
 |
Menu WINDOW>SPLIT.
This will give you a horizontal and a vertical bar across the worksheet. Drag each bar so that the area you want not to scroll is included. Select that area and then select WINDOW>FREEZE PANES.
__________________
[FONT=Arial][SIZE=1][COLOR=Navy][CENTER]Intel Core2Quad Q9550; EP45-UD3R (rev 1.1); 4x2GB DDR2 800MHz; eVGA e-GeForce 9600GT KO 512MB DDR3; Seagate ST31000528AS 1T, Seagate ST3500320AS 500GB SATA II, Seagate ST3500418AS 500GB SATA II; LG GH22-NS50 DVD-RAM x 2; DELL SP2208WFP; Windows 7 Ultimate 64-Bit Palm LifeDrive Mobile Manager |
|
|
|
|
01-25-2007, 12:51 AM
|
#3 |
|
Member (10 bit)
Join Date: Aug 2005
Location: Vancouver, BC, Canada
Posts: 976
|
thanks.
|
|
|
|
|
01-25-2007, 07:11 PM
|
#4 |
|
Member (7 bit)
Join Date: Apr 2006
Posts: 109
|
Actually, you can just click cell C14 and go to Window---freeze panes.
__________________
AMD Athlon 64 3200+ Venice 2000MHz CORSAIR ValueSelect 1GB (2 x 512MB) MSI NX7600GS-T2D256E GeForce 7600GS Foxconn NF4SK8AA-8KRS Socket 939 NVIDIA nForce4 SLI ATX COOLER MASTER Centurion 5 CAC-T05-UW Aluminum Bezel BenQ FP91G+ 19"LCD Monitor NEC 16x DVD +/- DVD Burner SONY DVD-ROM 48x/16x SEAGATE Barracuda 7200rpm 250g HD BELKIN Wireless Keyboard / Optical Mouse ANTEC TruePower II 430w Dual ATX12v Power Supply |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Connects, but NO internet -Serious | lani | Networking & Online Security | 41 | 04-26-2005 09:53 AM |
| Acceptable pings. | theyosh | Networking & Online Security | 4 | 01-24-2005 03:44 PM |
| Why only me with IE? | rockabilly | Internet, Web Applications, & The Cloud | 13 | 09-29-2004 09:55 AM |
| "One hop away" | BearEater | Networking & Online Security | 7 | 04-08-2003 06:45 PM |
Linear Mode
