Hi,

I'm not clear on the question. Are you in Page Layout View? and what do
you mean by when filling data into cells it goes to next page?

If you press the Tab key or Right Arrow key the cursor moves to the right
and if you are in the last column of a sheet this means that the cursor is in
the next page to the right. If you want this behavior when hitting Enter
then choose Office Button, Excel Options, Advanced tab, and change the
Direction to Right (the first option on this tab).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Herb" wrote:

Excel 2007
How to change view so that when filling data into cells and it goes to next
page that new page is shown horizontally (side by side) not vertically under
the last page. Same applies when you open a multipage worksheet, the pages
are viewed side by side.
--
herb