Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Microsoft Excel Help Needed.

Thread Tools
 
Search this Thread
 
Old 07 September 2006, 10:34 PM
  #1  
Jap Imports
Scooby Regular
Thread Starter
 
Jap Imports's Avatar
 
Join Date: Sep 2003
Location: Maidstone
Posts: 846
Likes: 0
Received 0 Likes on 0 Posts
Default Microsoft Excel Help Needed.

Hi,

Trying to freeze the top row so when i scroll down it stays at the top visible.

(ROW A)

Thanks
Old 07 September 2006, 11:22 PM
  #2  
Pete The Biker
Scooby Regular
 
Pete The Biker's Avatar
 
Join Date: Jul 2003
Posts: 348
Likes: 0
Received 0 Likes on 0 Posts
Default

To keep row and column labels visible as you scroll:-----------

To freeze the top horizontal pane, select the row below where you want the split to appear.

To freeze the left vertical pane, select the column to the right of where you want the split to appear.

To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.

On the Window menu, click Freeze Panes.


Pete
Old 07 September 2006, 11:24 PM
  #3  
jpor
Scooby Regular
iTrader: (1)
 
jpor's Avatar
 
Join Date: Sep 2003
Posts: 3,109
Likes: 0
Received 0 Likes on 0 Posts
Default

Click below and select the whole of Row B then do the following:
Click on Windows then choose 'Freeze Pane'

Whala!
Old 08 September 2006, 03:00 AM
  #4  
Dracoro
Scooby Regular
 
Dracoro's Avatar
 
Join Date: Sep 2001
Location: A powerslide near you
Posts: 10,261
Likes: 0
Received 0 Likes on 0 Posts
Default

No need to select whole row, as Pete says, just select a cell and the panes will freeze above and to the left of that cell.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
has-scooby
Subaru Parts
4
06 October 2015 03:47 PM
Phil3822
ICE
3
26 September 2015 07:12 PM



Quick Reply: Microsoft Excel Help Needed.



All times are GMT +1. The time now is 08:56 PM.