Microsoft Excel 2010 - Working on a Wide Worksheet? Make ENTER Move to the Right

SUMMARY: If you're editing a wide worksheet with the 10-key, you might find it more convenient to have the ENTER key move the cursor to the cell to the right.

By default, when editing a worksheet in Microsoft Excel 2010, you can press the Tab key to move the selection cursor to the cell to the right, and Enter moves to the below cell.

If you're editing a wide worksheet with a 10-key, you might find it more convenient to have the Enter key move to the cell to the right, just like the Tab key. The following shows you how to make this change. In fact, you can have Enter move up or to the left, if desired:

1. Select the "File" tab in the Ribbon.

2. The Microsoft Office Backstage View appears. Click the "Options" button.

(Or instead of steps 1 and 2, press Alt + T, then the letter O.)

3. The "Excel Options" dialog box appears. Click "Advanced" in the left pane.

4. In the right pane, underneath "Editing Options", make sure "After pressing Enter, move selection" is checked.

5. Underneath, click the pull-down next to "Direction" and choose the desired direction the cell selection should move after pressing Enter.

Changing the cell selection direction when pressing the Enter key

6. Click "OK" on the bottom-right of the dialog box to close it.

Everyone is invited to submit comments. Registered users also receive their own visitor profile page with a summary of recent posts.
Register | Login

Print This Tip

Get E-Mail When New Tips are Online

Return to the Microsoft Excel 2010 page.

View the original article here

Microsoft Excel 2010 - Hide Recent Documents or Show More

SUMMARY: Configure Excel 2010 to hide the list of recent documents for privacy, or show more of them.

As with other Office 2010 applications, Microsoft Excel 2010 keeps a list of recent workbooks, allowing you to directly access frequently-edited documents without having to navigate your computer or network drives. If you have workbooks located in a variety of locations, this Recent list may prove very useful.

While Excel 2010 by default displays the last 25 documents, if you work on many workbooks you may want to increase this number up to 50. On the other hand, if you are worried about privacy you may wish to disable this list altogether.

1. Select the "File" tab in the Ribbon.

2. The Microsoft Office Backstage View appears. Click the "Options" button.

(Or instead of steps 1 and 2, press Alt + T, then the letter O.)

3. The "Excel Options" dialog box appears. Click "Advanced" in the left pane.

4. Underneath "Display" (you may have to scroll down), next to "Show this number of Recent Documents" enter a number from 0 to 50, 0 to disable this list.

Configuring Excel 2010 not to show any recent documents

5. Click "OK" on the bottom-right of the dialog box to close it.

Everyone is invited to submit comments. Registered users also receive their own visitor profile page with a summary of recent posts.
Register | Login

Print This Tip

Get E-Mail When New Tips are Online

Return to the Microsoft Excel 2010 page.

View the original article here

Microsoft Excel 2010 - Rotate Text for Effect

SUMMARY: Make header cells in an Excel 2010 worksheet stand out by rotating text.

To draw attention to certain text inside a Microsoft Excel 2010 worksheet, such as the headers of a table, you might consider rotating the text. You can rotate text any degree or display text vertically.

1. Select a cell that you would like to rotate.

2. Click the "Home" tab in the Ribbon.

3. In the "Alignment" section, click the "Orientation" button - it looks like the letters "ab" rotated and an arrow underneath them. See the below screenshot:

Rotating text inside a cell in an Excel 2010 worksheet

4. A pop-up menu appears; choose from the following choices:

* Angle Counterclockwise (45 degrees)
* Angle Clockwise (45 degrees)
* Vertical Text (Stackes the characters of a cell on top of each other)
* Rotate Text Up (90 degrees)
* Rotate Text Down (90 degrees)

If you want more control over the degree of rotation, click the "Format Cell Alignment" option. This opens the "Format Cells" dialog box to the "Alignment" tab.

You can either enter the number of degrees to rotate in the box next to "Degrees", or click on anywhere in the half-circle underneath "Orientation" to visually choose your angle. Or, if you decide you want to stack the text vertically, click the box labeled "Text" with stacked letters next to the semi-circle.

When done, click "OK" to close the dialog box.

Rotating text inside a cell in an Excel 2010 worksheet by 65 degrees

Everyone is invited to submit comments. Registered users also receive their own visitor profile page with a summary of recent posts.
Register | Login

Print This Tip

Get E-Mail When New Tips are Online

Return to the Microsoft Excel 2010 page.

View the original article here

Microsoft Excel 2010 - Choose Where Saved and AutoRecover Files Go

SUMMARY: If you need to store workbooks and AutoRecover files elsewhere, configure Excel 2010 as to where they should be placed.

Do you have multiple hard drives or partitions and want to save Microsoft Excel 2010 workbooks and AutoRecover files on a location reserved for data? Or do you just want to organize your files differently on your one hard drive / partition?

By default, Excel 2010 saves AutoRecover files in your user's "AppData" folder (for Windows 7 users, this is C:\ Users\ [YOUR_USER_NAME]\ AppData\ Roaming\ Microsoft\ Excel\). While workbooks can be saved anywhere, the default location is your Documents folder (for Windows 7 users, this is by default C:\ Users\ [YOUR_USER_NAME]\ Documents). Here's how to change these locations:

1. Select the "File" tab in the Ribbon.

2. The Microsoft Office Backstage View appears. Click the "Options" button.

(Or instead of steps 1 and 2, press Alt + T, then the letter O.)

3. The "Excel Options" dialog box appears. Click "Save" in the left pane.

4. In the right pane, underneath "Save workbooks", you will find two text boxes. One is next to "AutoRecover file location", the other next to "Default file location". Click on a box and enter a new path to change the respective file location. Note that you must enter path names exact as there are no "Browse" buttons.

Configuring Excel 2010 where to save AutoRecover files and workbooks

5. Click "OK" on the bottom-right of the dialog box to close it.

Everyone is invited to submit comments. Registered users also receive their own visitor profile page with a summary of recent posts.
Register | Login

Print This Tip

Get E-Mail When New Tips are Online

Return to the Microsoft Excel 2010 page.

View the original article here