Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

I want work, and view,a single sheet in Mac Excel ... like I did in PC Excel

1,199 views
Skip to first unread message

EDB...@officeformac.com

unread,
Apr 1, 2010, 4:40:03 PM4/1/10
to
Operating System: Mac OS X 10.6 (Snow Leopard) How do you setup MAC Excel to be able to work in a single sheet format ... the Mac Excel comes up showing several sheets.

Michel Bintener

unread,
Apr 1, 2010, 5:24:07 PM4/1/10
to
There are two different views in Excel for Mac, Normal view and Page
Layout view. You can switch between them by clicking on View (in the
menu bar) and selecting the appropriate option, or by clicking on their
corresponding icons in the bottom left corner of the document window. If
you want Normal view as your default view, click on Excel>Preferences,
View section, and select Normal as your preferred view for new sheets.

--
Michel Bintener
Microsoft MVP (Macintosh)

*** Please always reply to the newsgroup. ***

CyberTaz

unread,
Apr 1, 2010, 5:23:24 PM4/1/10
to
It isn't showing "several sheets", it's using the newly introduced Page
Layout View by default. You're only viewing the one sheet but it's
'separated' into pages as it would be if you were to print the sheet.

You can click the Normal View button in the lower left corner of the
document window or go to View> Normal to change the view of any given sheet
at any time you wish ‹ Normal being the view you're most familiar with. A
workbook reopens in the same view it was in when last saved.

You can also change the Default View for new worksheets in Excel>
Preferences> View.

HTH |:>)
Bob Jones
[MVP] Office:Mac


On 4/1/10 4:40 PM, in article 59bb6...@webcrossing.JaKIaxP2ac0,

Phillip Jones, C.E.T.

unread,
Apr 1, 2010, 8:42:19 PM4/1/10
to
I prefer to to work in page layout view to show on one page at a time, I
just magnify it until just the one highlighted (white , active) page is
shown who want to using a Magnifying glass with glass to see the page at
normal 100% view to see what you have entered. ;-)

Michel Bintener wrote:
> There are two different views in Excel for Mac, Normal view and Page
> Layout view. You can switch between them by clicking on View (in the
> menu bar) and selecting the appropriate option, or by clicking on their
> corresponding icons in the bottom left corner of the document window. If
> you want Normal view as your default view, click on Excel>Preferences,
> View section, and select Normal as your preferred view for new sheets.
>
> On 01/04/2010 22:40, EDB...@officeformac.com wrote:
>> Operating System: Mac OS X 10.6 (Snow Leopard) How do you setup MAC
>> Excel to be able to work in a single sheet format ... the Mac Excel
>> comes up showing several sheets.
>

--
Phillip M. Jones, C.E.T. "If it's Fixed, Don't Break it"
http://www.phillipmjones.net http://www.vpea.org
mailto:pjo...@kimbanet.com

0 new messages