microsoft excel courses in - Page breaks

The UK's most regular instructor-led training courses.
Training information: microsoft excel courses in · Advanced.excel · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Page breaks

Sonia has attended:
Excel Introduction course

by - delegate Sonia [1 post] (2006 Nov 22 Wed, 14:35) Reply

How do you make a new page exactly where you require it?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: page breaks

by - trainer Orok bronze contributer [29 posts] (2006 Nov 22 Wed, 14:52) Reply

Hi Sonia,

To insert a manual Excel page break, place your cursor where you want the page
break to occur, and select the Insert menu and choose Page Break

Note the Page Break will occur at the top left corner of the cursor position.

To remove an existing Page Break, place your cursor in that cell select the Insert > Remove Page Break menu option

Accessing the View> Page Break Preview menu options allows you to again add, but also drag Page Breaks to a new location.

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Tap the Power of Recorded Macros with MS Excel Courses
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips