WHERE IS TOOLS MENU EXCEL 2007

In Excel 2007, how do I change the direction my cell selector moves upon pressing Enter?

I believe it used to be under Tools, Options… There was a drop-down menu where I could select Left, Right, Up, or Down and that’s where the selector would move when I pressed Enter. Now, in Excel 2007, the selector is moving to the Right but I can’t figure out how to switch it to move Down instead.

Click on the circle in top left corner with the office logo on it.

At the bottom of the pop up window click excel options and then advanced. Its the first thing on that list

Excel 2007: Working with What-If Analysis

Spreadsheet Tools for Engineers Using Excel 2007 $65.59 Spreadsheet Tools for Engineers Using Excel 2007

Spreadsheet Tools for Engineers Using Excel 2007 $65.58 Spreadsheet Tools for Engineers Using Excel 2007

Excel 2007 $28.98 Many experienced users may initially find Excel 2007 rather disorientating. But Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions. Youll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools. The book includes practical examples to illustrate advanced features. It also covers new features of Excel 2007 along with ways to access old features. Youll even gain timesaving tips and shortcuts.

Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook $40.09 Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook

Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook $54.99 Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook

---