View only one page in excel mac

Changing Excel:Mac 2008 and 2011 Default View Options

When you open workbooks in Excel:Mac and , you are presented with a default screen setup. This default configuration includes a view wherein you see multiple worksheets.

Never miss out

Perhaps you have data on only the first page or you want to focus on only one page at a time. If you want to change the view to see only one worksheet at a time, there are two simple ways to configure it. These instructions work for both Excel: Mac and Step 1.

How Do You Limit Information to Just One Page in Excel 2007? : Using Excel & Spreadsheets

Locate the Standard Toolbar at the very top of your Excel file, or workbook. Commands on the toolbars will appear as icons only, or they may have text under the icons. Step 2. Find the Zoom command on the Standard Toolbar. If your toolbars have only icons, you can identify the Zoom command as a rectangular field with a percentage number in it and a dropdown arrow on the right side of it.

Print a sheet on just one page in Excel for Mac

Step 3. Click the dropdown arrow on this rectangle to see a selection of page sizes and other options.

  • Most read this week.
  • How to Disable Excel Read Only on Mac?
  • Search form;
  • optiarc dvd rw ad-5630a firmware update mac.

Now only one sheet shows up at a time from your workbook. Sign in.

Excel Export To Pdf Fit To Page

United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:.

How to Print Worksheets on One Page in Excel

Microsoft Office. Office for Mac.

Sign in to vote. Monday, December 7, AM. If you have feedback for TechNet Support, contact tnmff microsoft.

Tuesday, December 8, AM. All replies. Same problem.

I cannot get reid of the ghost pages and just view the single active page for a one page document. This was easy to do in earlier versions.