NAKBOOK.COM – Tutorials for Software and Hardware

The alignment section of the Home Tab of the Excel ribbon contains a number of options relating to the way in which your data is position within the cell. Perhaps the most familiar and the most frequently used buttons in this section are the three relating to the horizontal position your data: left, centre and right. However you'll notice that when you click in the cells of an unformatted worksheet, none of these three icons is highlighted, which indicates that none of them is the default. The reason for this is that Excel treats data differently depending on the data type.

If you type text in a cell, your text is aligned on the left; if you type a number, the number is aligned on the right; if you type a date, it is also aligned on the right. To set the horizontal alignment, you can either select a range of cells or click on a column letter to highlight the entire column then click on one of the alignment icons.

Haven chosen one type of horizontal alignment, you can change it in two ways. You can either click on a different form of alignment or click again on the already selected alignment. For example, if your text is centred and you click on the Centre button a second time, this deactivates centre alignment and returns you to the default alignment which, for text, is left. Thus we have, effectively, four types of horizontal alignment: left, centre, right and unspecified (or default), which is the alignment that applies when none of the alignment buttons is highlighted.

Microsoft Excel also allows you to specify the vertical alignment of your text. This setting becomes apparent when you increase the height of the cell and there is a definite default; text is normally aligned at the bottom of the cell. This default vertical alignment applies to text, dates and numbers alike.

To change vertical alignment, either make a selection or click on the row number to select the entire row then click on one of the buttons to make the change: align middle, align top and so forth.

Disclosure and Disclaimer

The alignment option also includes the ability to change the orientation of text within the cell. This is particularly useful in those situations where the headings are wider than the data within the cells. To change the vertical orientation of your text, you simply select the cells in question and then choose the appropriate orientation in the Alignment dialogue.

If you rotate your column headings by 90 degrees, you can usually make the columns much narrower. Excel has a very useful way of doing this: simply select all the columns that contain data then in the Cell group of the Home Tab of the Excel Ribbon, choose Format then AutoFit Columns. This command makes each of the highlighted columns no wider than it needs to be in order to display all the data it contains.

For more information on Excel VBA training courses, visit Macresource Computer Training, a UK IT training company offering Excel VBA Classes at their central London training centre.

categories: Microsoft Excel 2007,VLookup,functions,formulas,Excel 2007 training courses,Excel 2007,Microsoft Office 2007,tutorial,training,computer software,computers,software programs

Adobe Photoshop Creative Suite 5 is a greatly improved edition brought out by Adobe. This specific edition is specialized in supporting videos, movie as well as multi-media industry experts. Having sleek capabilities as well as potent cropping and editing resources, CS5 has introduced a revolution within the area of film / picture modifying and also formatting. Highly suitable for architects, researchers, technicians, template designers, graphic designers as well as medical experts, this variation offers you the higher end, and extremely user friendly blend and also fast range resources in making ones modifying experience an enjoyable experience.

Adobe Photoshop Creative Suite 5 is actually directed to assist novice photography fans and video publishers obtain excellence in their career. Here's a list of several of its unique characteristics:

Smart modifying software: Featuring a smart modifying tool box, you are able to easily do no matter what it requires to achieve excellence within your resourceful productivity in terms of videos or picture. From adjusting hues, to blurring as well as enhancing parts of the photograph, to improving the resolution of the photograph, this particular version is certainly packed with all of the modifying tools imaginable. This modifying software should make it one of the best variations so far regarding photograph and video modifying.

Artwork and illustrating resources: Using a variety range of artistic paint brushes, drawing software, color adjustments can easily modify the elegance and excellence of the photo. With these kinds of easy to access paint brushes, you are able to create unique photos out of your ordinary images.

Edge refining and selection tools: Selecting a small piece of your respective image could not be simpler utilizing these types of resources. The advanced refining options that come with Adobe Photoshop Creative Suite 5 allow users to choose a specific portion of the particular photo with simply a click to perfect it to excellence.

Compositing features: Using this feature, you are able to easily line up layers in your photo to incorporate a special effect.

Improved printing quality: The actual superior coloring management benefits help you add life to your otherwise regular looking image. With more effective print preview windows and more features within the print option, your printed image might truly match up to the standards of a specialist ten-on-ten photo.

Apart from the above functions, the Photoshop Creative Suite 5 version is certainly full of easier to use functions including Smart Objects, Red Eye Reduction tool, InDesign, Healing Brush, ImageReady, Illustrator, AfterEffects, etc. These characteristics makes this edition totally user focused. This software program is extremely compatible with just about all the actual formats of photos, specifically, TIFF, PSD, BMP, OpenEXR, LPEG2000 and JPEG.

Did you enjoy Adobe Photoshop CS5 Tutorial? Well now you can by watching this Photoshop Sample CS5 Video Tutorial

Calibrate the screen: All the colours you can see on the display will certainly vary dependent on your computer monitor, graphic card settings, the amount of light and more, nevertheless the majority of people use the same default Windows colour profile. And that would mean a digital image you think to be splendid might look really poor to everybody else. Luckily Windows 7 now gives a Display Colour Calibration Wizard that helps you properly set up the brightness, contrast and colour configurations, and also a ClearType tuner to ensure textual content will be sharp and crisp. Click on Start, type DCCW then press Enter for you to give it a go.

Clean up Live Essentials: Installing Windows Live Essentials will get you the new versions of Mail, Movie Maker, Photo Gallery and more - good. The fact is you'll find it contains additional features that could be unnecessary, nonetheless if you want to maintain a clean system then these can be quickly taken out.

In the event you kept the default "Set your search provider" choice selected in the course of set up, for instance, Windows Live will then install Choice Guard, that is a tool to fix your browser home page and also search engine, and prevent alternative applications from altering them. If of course this causes issues later on, or you just decide you do not need them, in that case Choice Guard may be taken away just by clicking on Start, then keying msiexec /x and pressing [Enter].

Windows Live Essentials additionally gives an ActiveX Control to help you load up your files to Windows Live SkyDrive, in addition to Windows Live Sign-in Assistant, rendering it easier to regulate and move between numerous Windows Live accounts. In case you are sure you will never require either of them then simply eradicate these with the the Control Panel "Uninstall Program" applet.

Add network support: By default Windows Live MovieMaker will not allow you to import files over a network, however an easy Registry tweak will alter this. Run REGEDIT, browse to HKEY_CURRENT_USER\Software\Microsoft\Windows Live\Movie Maker, put in a DWORD value called AllowNetworkFiles and set it to 1 to incorporate network support.

Nicola moves on with her series of Windows 7 tutorials visit the site and explore her Windows 7 tips and tricks including Calibrating the Screen, Cleanup Live Essentials and Add Network Support .

categories: Windows7,Operating System,Computer Software,Tutorials