close

i have being tasked to create a spreadsheet for a member of the family,
however as there are so many headings i feel that as they don't under
stand computers well i need to make it as simple as possible.
i would like the page to brake after a selected section of the
spreadsheet, for example:

the 1st section is monthly income, the 2nd is monthly outgoings,3rd is
company addresses.

i would like a brake between the different sections, that when draged
up and closed it shows the information and has a heading that stop the
section getting lost.

is this possible as i can seem to get it to work but don't see why it
would't.

thanks either way--
johnny.exe
------------------------------------------------------------------------
johnny.exe's Profile: www.excelforum.com/member.php...oamp;userid=30775
View this thread: www.excelforum.com/showthread...hreadid=509284
Perhaps it would be better to put the different secions on separate
worksheets?--
millsy
------------------------------------------------------------------------
millsy's Profile: www.excelforum.com/member.php...foamp;userid=5122
View this thread: www.excelforum.com/showthread...hreadid=509284Click on the cell where you want the break to occur

gt;From the main menu select Insert--gt;Page Break.

If you click on a cell that contains a page break, to remove it select
Insert--gt;Remove Page Break.

You can check the print view by selecting (from the main menu)
View--gt;Page Break Preview.

This view shows the print area divided into pages as they would be
printed. You can grab the blue separator lines and drag them to
wherever you want the breaks to occur (vertically and horizontally).

Hans
thanks, i have a front page, calendar page, not apge and all 12 month
pages so a section perpage would mean having 40 sheets in total. but
thanks for the help to both of you.
johnny--
johnny.exe
------------------------------------------------------------------------
johnny.exe's Profile: www.excelforum.com/member.php...oamp;userid=30775
View this thread: www.excelforum.com/showthread...hreadid=509284

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()