Format Menu Commands Move to the Home tab in Excel 2007

October 8th, 2008 Posted in Menu

In part 5 of the menu series, we cover the Format menu equivalent commands in Excel 2007. The bulk of these commands are now located under the Format command in the Cells group in the Home tab.

Format Menu

Excel 2003 Commands	Equivalent Excel 2007 Commands
Cells	Home tab > Cells group > Format button > Format Cells
Rows > Height	Home tab > Cells group > Format button > Row Height
Rows > AutoFit	Home tab > Cells group > Format button > AutoFit Row Height
Rows > Hide	Home tab > Cells group > Format button > Hide & Unhide > Hide Rows
Rows > Unhide	Home tab > Cells group > Format button > Hide & Unhide > Unhide Rows
Columns > Width	Home tab > Cells group > Format button > Column Width
Columns > AutoFit Selection	Home tab > Cells group > Format button > AutoFit Column Width
Columns > Hide	Columns > Hide
Columns > Unhide	Home tab > Cells group > Format button > Hide & Unhide > Unhide Columns
Columns > Standard Width	Home tab > Cells group > Format button > Default Width
Sheets > Rename	Home tab > Cells group > Format button > Rename Sheet
Sheets > Hide	Home tab > Cells group > Format button > Hide & Unhide > Hide Sheet
Sheets > Unhide	Home tab > Cells group > Format button > Hide & Unhide > Unhide Sheet
Sheets > Background	Page Layout tab > Page Setup group > Background
Sheets > Tab Color	Home tab > Cells group > Format button > Tab Color
Auto Format	Home tab > Styles group > Format as Table
Conditional Formatting	Home tab > Styles group > Conditional Formatting
Style	Home tab > Styles group > Cell Styles