LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
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 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
Print "freeze panes" on succeeding pages? kdhelm Excel Discussion (Misc queries) 8 October 10th 08 12:38 AM
I want to lock row 1 in Excel. Why is "Freeze Panes" grayed out? Fran Z Excel Discussion (Misc queries) 2 January 15th 08 05:46 PM
Can you make a "split" or broken y-axis on a graph in Excel? question Charts and Charting in Excel 2 August 30th 07 11:46 PM
"freeze panes" in excel '97? Jolanda van Tuijl New Users to Excel 1 November 10th 06 12:02 PM
Excel loses "Freeze Panes" setting Eric Excel Discussion (Misc queries) 1 November 3rd 06 12:21 AM


All times are GMT +1. The time now is 06:59 AM.

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"