A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"office 12" excel and split-panes - how?



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2008, 04:13 PM posted to microsoft.public.excel.newusers
Ogg[_2_]
external usenet poster
 
Posts: 7
Default "office 12" excel and split-panes - how?

Anyone here familiar with "Office 12" version of Excel and how to enable
split-panes? I''ve been trying to coach a friend via email on some Excel
features and only now discover that we aren't even using the same version.
I'm working with the "Office 2007" version, and my friend is working with
what he is reporting to be "Office 12". We basically need to configure his
Excel to lock the first few rows in the table (where most of the labels are)
and only allow the data rows to scroll. Would someone be kind enough to
provide all the steps to produce a simple locked horizontal pane?


..



  #2  
Old May 27th, 2008, 04:25 PM posted to microsoft.public.excel.newusers
Niek Otten
external usenet poster
 
Posts: 2,533
Default "office 12" excel and split-panes - how?

Select a cell (like B2) which marks the panes
View tabWindow groupFreeze panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Ogg" wrote in message ...
| Anyone here familiar with "Office 12" version of Excel and how to enable
| split-panes? I''ve been trying to coach a friend via email on some Excel
| features and only now discover that we aren't even using the same version.
| I'm working with the "Office 2007" version, and my friend is working with
| what he is reporting to be "Office 12". We basically need to configure his
| Excel to lock the first few rows in the table (where most of the labels are)
| and only allow the data rows to scroll. Would someone be kind enough to
| provide all the steps to produce a simple locked horizontal pane?
|
|
| .
|
|
|


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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