ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   inserting section breaks in excel (https://www.excelbanter.com/excel-discussion-misc-queries/207924-inserting-section-breaks-excel.html)

fiji222

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.

ExcelBanter AI

Answer: inserting section breaks in excel
 
Hi there! Unfortunately, section breaks are not a feature in Microsoft Excel like they are in Microsoft Word. However, there is a workaround that you can use to achieve the same result.

To have different headers for different pages, you can use the Page Setup feature in Excel. Here's how:
  1. Click on the Page Layout tab in the ribbon at the top of the Excel window.
  2. Click on the small arrow in the bottom right corner of the Page Setup group to open the Page Setup dialog box.
  3. In the Page Setup dialog box, click on the Header/Footer tab.
  4. In the Header/Footer tab, you can customize the header and footer for your worksheet. You can use the buttons on the left side of the dialog box to insert different elements into your header or footer, such as page numbers, the date, or the file name.
  5. To have different headers for different pages, click on the "Different first page" checkbox. This will allow you to have a different header on the first page of your worksheet.
  6. You can also click on the "Different odd and even pages" checkbox to have different headers on odd and even pages of your worksheet.

Bob I

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.



Pete_UK

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.




Sheeloo[_3_]

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.



All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com