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

Information Technology Design - Purchase the Right Equipment For Graphic Designing

Information technology design is helping many businesses improve their productivity and profit margins. It is also helping numerous graphic design professionals earn a living doing what they love - creative design. Technology web design is a comparatively new and therefore poses many challenges, for the designer as well as the end user.

A graphic designer should invest in the right equipment for the job. Graphic designing is different from print design. Today, designs for printed materials such as magazines, books, brochures, pamphlets, and catalogs are created using computer tools. This is known as computer aided design technology. Whether you design for desktop publishing or print, you need to have the right tools.

To find the right tools, the designer needs to prioritize his needs. Graphic design equipment can be expensive, particularly for high end, complicated Flash graphics or animations. Technology web design today is an interface of various communication media and methods - internet, print, television, Bluetooth, animation, video, or plain web page design. The tools required are sophisticated and versatile. Often, an entire suite of tools for professional technology design services can cost quite a bit - especially if you throw in cutting edge software. Therefore, you need to be aware of what your job requires so that you can make appropriate purchase decisions.

Mac PC

Unlike other professions where a Windows system serves most IT needs, information technology design requires Mac. The reason for this is that people involved with technology graphic design feel that Mac computer offers better color imaging. The latest Mac systems work on files imported from Windows, so there should be no incompatibility between the two.

Monitor

If your work involves instructional design and technology, you should not buy a small monitor to save money. The time spent on clearing icons and additional windows and tabs from the screen to cover every part of the image will lessen productivity. A large monitor - 18 inches or more - offers more room for maneuvering. LCD monitors take up less space on the work desk, but older cathode tube monitors offer clearer image quality. An information technology design professional must keep these factors in mind while purchasing computer screens.

Data Storage

A professional designer must have adequate data backup, besides the usual hard disk storage. You can purchase cheap hard drives for external data backup if you are a one-person design business. Large organizations should have professional data backup support. Many information technology design businesses fail due to data loss triggered by malware, hacking, or a simple formatting error.

Accessories

Besides the basics, an information technology design service provider will need keyboard, mouse, scanner, digicam, and printer for their work. Another modern but important tool is a graphics board that directly inputs the pen strokes of the illustrator into the system after converting it to digital format.

Now that you know the tools that are crucial to your job as an information design technology service provider, you should choose your equipment carefully.

Clusk.com features news related to information technology design, graphics design, instructional design, web technology, online marketing, and related topics. It also provides frequent updates on the latest trends in the fields of digital designing and online marketing