Home > Document > Excel > Where is Cell Padding in Excel 2007, 2010 and 2013
 

Where is Cell Padding in Microsoft Excel 2007, 2010 and 2013?

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office 2010 and 2013 (365)
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 set Cell Padding if you have Classic Menu for Office

If you have installed Classic Menu for Office, you can go back the familiar classic menus and toolbar interface of Excel 2003/XP(2002)/2000 on the ribbon of Excel 2007/2010/2013. There are two methods to set cell padding if you have Classic Menu for Office installed:

Method A: Set Cell Padding with Increase/Decrease Indent button in classic toolbar

Under the Menus tab, just click the Increase Indent button, or Decrease Indent button to set the selected cells padding.

shot-setting cells padding with increase/decrease indent buttons in toolbar

Figure 1: setting cells padding with increase/decrease indent buttons in toolbar

Method B: Set Cell Padding with format Cells if you have Classic Menu for Office

  • Click the Menus tab;
  • Click the Format menu;
  • Click the Format Cells item.
  • Select the Alignment tab;
  • Go to the Text alignment pane;
  • Modify the parameters to set cells padding.

Reset cells padding with modifying the options of Text Alignment under Alignment tab in Format Cells dialog box

Figure 3: Format Cells dialog box

More Classic Menu for Office



Get Cell Padding command in Ribbon if you do not have Classic Menu for Office

There are also two methods to find out Cell Padding commands on the Ribbon of Excel 2007/2010/2013:

Method C: Setting cell padding with Increase/Decrease Indent buttons from Ribbon
  • Click the Home tab;
  • Go to the Alignment group;
  • Click the Decrease Indent button or Increase Indent button to set selected cells padding.

setting cells padding with increase/decrease indent buttons in Ribbon

Figure 4: setting cells padding with increase/decrease indent buttons in Ribbon

Method D: Setting cell padding with format cells in Ribbon
  • Click the Home tab;
  • Go to the Cells group;
  • Click the Format button;
  • In the Format drop down list, click the Format Cells item.

Format Cells in Ribbon

Figure 5: Format Cells in Ribbon

After clicking the Format Cells item, you will enter the Format Cells dialog box. Reset the cells padding by modifying the parameters of Text Alignment under Alignment tab, just as the figure 3 shows.


Classic Menu for Office

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

 

Classic Menu for Office 2010 and 2013

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

 
 

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.