Home > Document > Excel > Where is AutoFit in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365
 

Where is AutoFit in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365?

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office
Kutools for Excel: 120 Powerful New Features for Excel.
Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.


Familiar way to apply AutoFit feature if you have Classic Menu for Office

Classic Menu for Office is designed to bring you back the user interface of Microsoft Excel 2003/XP(2002)/2000. It will enable you to work in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365 quickly with your habit for Excel 2003. If you have installed Classic Menu for Office on your computer, you can easily apply the AutoFit feature:

  • First of all select the cells that you need to apply AutoFit feature to:
  • Click the Format drop down menu in main menus;
  • Then you will view the AutoFit Row Height is under Row item, and the AutoFit Column Width is under Column item.

Apply AutoFit in Classic Menu

Figure 1: Apply AutoFit in Classic Menu

More Classic Menu…


Back to Top

Apply AutoFit in Ribbon if you do not have Classic Menu for Office

It may be a little puzzled on the Ribbon of Microsoft Excel 2007/2010/2013/2016/2019 at the beginning. Here we will guild you to apply AutoFit feature in Ribbon:

  • First of all select the cells that you need to apply AutoFit feature to;
  • Click the Home tab;
  • Go to the Cells group;
  • Click the Format button;
  • Then you will view the AutoFit Row Height item and AutoFit Column Width item.

Apply AutoFit in Excel 2007/2010 Ribbon

Figure 2: Apply AutoFit in Excel 2007/2010 Ribbon


Back to Top

More Tips for Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365

 

 

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010, 2013, 2016, 2019 and 365. You can use Office 2007/2010/2013/2016 immediately without any training. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface.

 

Classic Menu for Office

It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365.

 
 

Classic Menu for Office 2007

It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Classic Menu for Excel 2010

Screen Shot of Classic Menu for Excel

 

 

 
 

2001- Addintools. All rights reserved.  Privacy Policy  |  Contact Us
If you have any questions or suggestions about our products or web site, please feel free to submit them to us. Thank you very much.