Excel 2007 Worksheet Appear like Powerpoint Slide

jay-excel

New Member
Joined
Aug 20, 2009
Messages
34
Hello,

I am trying to have an excel worksheet appear like a powerpoint slide. I have seen it done, but have not been able to replicate it.
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,790
Office Version
365
Platform
Windows
What exactly do you mean appear like a powerpoint slide?
Perhaps you mean Page Break Preview on the View tab...
 

jay-excel

New Member
Joined
Aug 20, 2009
Messages
34
Hi,

Sorry I should have explained myself a little more.

In Excel 2007 I received a document where one sheet looked exactly like a powerpoint slide. In that, only one page was viewable, there weren't any scrollbars and nothing in the View tab was able to be selected.
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,790
Office Version
365
Platform
Windows
1 page viewable:
- You can hide all but the one sheet. On the Home tab, in the Cells group click Format. Under Visibility click Hide & Unhide and then Hide Sheet.
- Another option may be to hide the tabs. Click on the Home tab then Excel Options. Open the Advanced tab in the dialog and uncheck Show sheet tabs.

Hide scroll bars:
Click on the Home tab, Excel Options, Advanced tab and uncheck Show horizontal scroll bar and Show vertical scroll bar.

Nothing to be selected in View tab:
Hmmmm, I suspect this was coded...
 

jay-excel

New Member
Joined
Aug 20, 2009
Messages
34
HI,

Thanks for the reply! I think it was coded too. It was difficult to search for it because everything relates to adding excel into powerpoint.

Cheers
 

Forum statistics

Threads
1,085,329
Messages
5,382,986
Members
401,812
Latest member
emelyan1379

Some videos you may like

This Week's Hot Topics

Top