Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 27th 08, 05:37 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1
Default inserting section breaks in excel

I'm trying to figure out how to insert section breaks in my excel spreadsheet
so that I can have different headers for different pages. Everywhere I've
looked says go to insert and click section break. But I don't see this
anywhere on the toolbar. Others also suggest clicking the "link to" button
to allow to have different headers.

  #2   Report Post  
Old October 27th 08, 05:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2,819
Default inserting section breaks in excel

That's because Section breaks are in Word. If you want "different"
headers in a single worksheet, you will need to do a single print job
for each different header desired.

fiji222 wrote:

I'm trying to figure out how to insert section breaks in my excel spreadsheet
so that I can have different headers for different pages. Everywhere I've
looked says go to insert and click section break. But I don't see this
anywhere on the toolbar. Others also suggest clicking the "link to" button
to allow to have different headers.


  #3   Report Post  
Old October 27th 08, 05:53 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default inserting section breaks in excel

Excel does not have section breaks in the way that Word does. Each sheet can
have its own header/footer, so you may need to put your data in different
sheets if you want to change the header/footer mid way through a printed
document.

Hope this helps.

Pete

"fiji222" wrote in message
...
I'm trying to figure out how to insert section breaks in my excel
spreadsheet
so that I can have different headers for different pages. Everywhere I've
looked says go to insert and click section break. But I don't see this
anywhere on the toolbar. Others also suggest clicking the "link to"
button
to allow to have different headers.



  #4   Report Post  
Old October 27th 08, 06:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1,805
Default inserting section breaks in excel

I don't think Excel provides this facility. You can not have section breaks...

Where are your different headers? You need to have a macro which will insert
the appropriate headers at the time of printing...
How will you identify a section break?

For example following macro will insert page breaks when the value in first
column changes...

Sub PageBreak()
Dim CellRange As Range
Dim TestCell As Range

Set CellRange = Selection
For Each TestCell In CellRange
ActiveSheet.Rows(TestCell.Row).PageBreak = xlPageBreakNone
If TestCell.Value < TestCell.Offset(-1, 0).Value Then
ActiveSheet.Rows(TestCell.Row).PageBreak = xlPageBreakManual
End If
Next TestCell
End Sub

To use the macro, simply select the cells you want to use as your key for
doing the splits, minus the top cell. For instance, if the departments are in
column A, rows 2 through 37, you would select the range in A3 through A37.
Run the macro, and any old page breaks are removed and new ones added.
"fiji222" wrote:

I'm trying to figure out how to insert section breaks in my excel spreadsheet
so that I can have different headers for different pages. Everywhere I've
looked says go to insert and click section break. But I don't see this
anywhere on the toolbar. Others also suggest clicking the "link to" button
to allow to have different headers.



Reply
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
Inserting Page Breaks blasds78 Excel Discussion (Misc queries) 3 May 22nd 07 03:57 PM
How do I use section breaks in excel? Cheeseman Excel Worksheet Functions 1 June 1st 06 10:20 PM
Inserting Page Breaks chrisnelsonusa1 Excel Discussion (Misc queries) 3 December 9th 05 09:34 PM
isolating different aspects of worksheets...as objects? through section breaks? JLC Excel Worksheet Functions 2 November 7th 05 09:41 AM
Section Breaks smokemyocom Excel Worksheet Functions 1 October 27th 05 09:14 PM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017