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.

Excel Question

Thread Tools
 
Search this Thread
 
Old 09 September 2003, 03:03 PM
  #1  
Andy Hall
Scooby Regular
Thread Starter
 
Andy Hall's Avatar
 
Join Date: Jul 1999
Posts: 615
Likes: 0
Received 0 Likes on 0 Posts
Post

We are putting our monthly work schedule onto Excel, the paper one is costing us a fortune in Tipex

Basically it is a list of Staff in a column on the left with their wherabouts displayed on the right. The problem is that once you get half way through week 2 of the month, you cant get the staff name and the wherabouts on the screen at the same time.
I need to be able to scroll the month behind the column of names, I'm sure its very simple, but that little paper clip chappy is just no help whatsoever

Regards,
Andy
Old 09 September 2003, 03:05 PM
  #2  
Figment
Scooby Regular
 
Figment's Avatar
 
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes on 0 Posts
Post

Assuming you want to keep column A and Row 1 visible:


Click into cell B2, click Window > Freeze Panes.



Old 09 September 2003, 03:21 PM
  #3  
Andy Hall
Scooby Regular
Thread Starter
 
Andy Hall's Avatar
 
Join Date: Jul 1999
Posts: 615
Likes: 0
Received 0 Likes on 0 Posts
Cool

Wow, problem solved, Cheers Figment.
Old 09 September 2003, 03:31 PM
  #4  
Figment
Scooby Regular
 
Figment's Avatar
 
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes on 0 Posts
Post

Sorry it took so long to reply

There is at least one other way you can do the same, but that is probably the quickest.

(Try Click B2, Window > Split - does the same but with thicker dividing lines)



[Edited by Figment - 9/9/2003 3:31:46 PM]
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
KAS35RSTI
Subaru
27
04 November 2021 07:12 PM
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
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM



Quick Reply: Excel Question



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