Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 870
  • Last Modified:

No "Share" option on Excel 2010 File dropdown menu

I can convert an Excel 2010 worksheet to a PDF with the Save As option or the Print menu, choose PDF, select Printer Properties etc, but I understand there is another method involving the Share option on the File dropdown menu, except I have no Share option. Can anyone tell me how to enable the Share option? Ultimately, I want a single click option to print my worksheet as a PDF in the smallest size. Thanks for any help.
0
Bob Barnes
Asked:
Bob Barnes
  • 4
  • 2
  • 2
  • +2
1 Solution
 
PabilioCommented:
Hi Allpurple,

I think you need to edit your Ribbon option in order that the SHARE option is displayed in your Ribbon under the File Tab

See it here: http://www.addictivetips.com/windows-tips/microsoft-office-excel-2010-whats-new/

Hope it helps,
Roberto.
0
 
SiddharthRoutCommented:
If I am not wrong then the "Share" option in Office 2010's file menu has been renamed to "Save and Send," because apparently, no one knew quite what was meant by share.

Sid
0
 
Bob BarnesAuthor Commented:
I must be dim, but I cant see how to customize the File dropdown menu. Customize Ribbon doesn't include the File dropdown for me to customize. Am I completely mad?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
TommySzalapskiCommented:
There is no File dropdown in Excel 2010. Are you talking about the Office Button? (The big round one in the top left corner).
0
 
TommySzalapskiCommented:
Nevermind. Forgot they added it back in.
0
 
TommySzalapskiCommented:
You can't edit the file dropdown very easily, but since you want to do it in fewer clicks, just do this.
Right click on the ribbon
Hit 'customize ribbon'
On the right hit 'new group' (add it to the Home tab which is default)
Name the group if you like
On the left, select 'All commands' from the dropdown
Scroll down to 'Publish as PDF or XPS' and add it to your custom group.
Now you have a real single-click option to save as PDF. You don't even have to click the file menu first.
0
 
Bob BarnesAuthor Commented:
Thank-you, my sanity is restored. If only I had checked all of the options???
0
 
SiddharthRoutCommented:
Glad to be of help :-)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
@Tommy

>>There is no File dropdown in Excel 2010. Are you talking about the Office Button? (The big round one in the top left corner).

There is no Office button in 2010 anymore. It's been replaced with the File tab and opens what is now called the "Backstage" view.
0
 
TommySzalapskiCommented:
Yeah, I remembered. (You must have missed my second post).
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now