Page breaks

Resolved · High Priority · Version 2007

Thu 8 Jan 2009, 15:27 Delegate Matt said...

Matt has attended:
Excel Intermediate course

Page breaks

How do you make the page break lines disappear from an excel work sheet

Thu 8 Jan 2009, 19:00 Trainer Susan said...

RE: Page breaks

Hi Matt

Thanks for your question. To remove page break lines from an excel work sheet, click on the MS Button (top left of screen), choose Excel Options, then click on the 'Advanced' option and scroll to the lower part of the screen. Under the heading 'Display Options for this Worksheet' deselect 'Show Page Breaks' if already selected.

Regards

Thu 15 Jan 2009: Automatically marked as resolved.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Page breaks

Page breaks

RE: Page breaks

Excel articles

Excel tip:

Display pictures on Chart Data Point