Besides basic horizontal and vertical alignment, Excel has a range of advanced options for data display. In this easy Excel tutorial, we are going to show you a few more tricks to include in your professional spreadsheets. You can learn Excel the simple way and create advanced worksheets by performing complex features that are available on your Excel toolbar. Click on the Home tab and look for the box that reads Alignment:
There are four advanced options in the Alignment box, as well as a link to your Format Cell dialog box. We are going to explain in detail how each works and what it will do to the data in your cells. The first step is to highlight the cells you wish to practice with.
Represented above by a red arrow, this tab is used for rotating data inside a cell. If you click on it, you will find five rotation angles that you can use. The last one is Format Cell Alignment, which will take you to your Format Cell dialog box. Here you will be able to customize the angle and orient the data exactly how you want it. Play around with the different options and see how it appears in your spreadsheet. This is what it will look like when you click the Angle Clockwise option:
The blue arrow above shows the icon that will align your data against an unseen margin. The pattern will be repeated throughout the highlighted cells, giving a very professional and neat appearance. Each time you click on it, it will move your text to the next margin. There are two buttons, the left one will move your data left, while the right one will move it right. This is what it looks like:
- Wrap Text
This function is used to display an entire word or phrase within a cell. Excel will automatically show only what fits into the cell, which does not look neat or professional in any way. You will need to wrap the text to be able to read what you have typed into that cell. Here is an example:
- Merge & Center
Mostly used for the correct display of headings, it can be used throughout your spreadsheet if required. This option will simply take a group of highlighted cells and make them one cell. It will automatically center the data within it, which you are then able to realign left, right, up or down as desired. Look at the professionalism it offers in this example:
- Format Cells Dialog Box
The small icon for this option can be found in the far right-bottom corner of your Alignment box. It will take you to the dialog box for cell formatting. You will be able to find every formatting tool inside it and the various options they offer. Click on the Alignment tab and you will be able to shrink text to fit into the cell, as well as customize data rotation angles to your specifications. This is what it looks like and how to access it:
Now that you are able to use all the cell alignment features that Excel offers, you may create professional spreadsheets that look good. You could even use this feature to highlight certain areas with the intention of drawing the eye to specific data. Excel has so many functions available that enable you to be as creative as you wish to be.