No "Share" option on Excel 2010 File dropdown menu

Posted on 2010-11-28
Last Modified: 2012-08-13
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.
Question by:Allpurple
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +2

Expert Comment

ID: 34225354
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:

Hope it helps,
LVL 30

Accepted Solution

SiddharthRout earned 500 total points
ID: 34225393
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.


Author Comment

ID: 34225463
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?
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

LVL 37

Expert Comment

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

Expert Comment

ID: 34226414
Nevermind. Forgot they added it back in.
LVL 37

Expert Comment

ID: 34226427
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.

Author Closing Comment

ID: 34226430
Thank-you, my sanity is restored. If only I had checked all of the options???
LVL 30

Expert Comment

ID: 34226433
Glad to be of help :-)
LVL 50
ID: 34226488

>>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.
LVL 37

Expert Comment

ID: 34226517
Yeah, I remembered. (You must have missed my second post).

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question