Microsoft Excel measures row height in points, the same units used to measure font size. When creating reports this makes it easy to relate the height of rows to the required line spacing. This means that you can increase the line spacing simply by increasing the height of your rows.

The methods used for changing column widths (something that Excel users do far more frequently) can also be used to change row height. Firstly. we can make a selection and. in the Cells section of the Home Tab of the Excel Ribbon, choose Format then Row Height. If you double Excel's default row height, you will obtain an approximation of double line spacing. If you multiple the default by a factor of 1.5, you will obtain approximately 1 1/2 line spacing, and so forth.

Excel's AutoFit facility can also be used to automatically resize row heights to accommodate the largest font size contained in a given selection. To use the AutoFit command on a single row, position the cursor at the bottom of the row heading and simply double-click. To AutoFit a range of rows, first make a selection and then double-click at the bottom of any of the selected row headings. The same result can also be achieved by using Format - AutoFit Row Height in the Cells section of the Home Tab of the Excel Ribbon.

In a lot of circumstances, row height can be completely ignored since Excel will automatically adjust the height of rows to accommodate the largest font size found on each row. For example, suppose we insert a header row at the top of a worksheet centred across all the columns containing data. If we then increase the font size of this heading, Excel will automatically increase the row height to accommodate the new font size, pushing the rest of the data down.

Another technique is to increase the row height interactively. This is done by positioning the cursor on the line below the row heading and dragging up or down. As you drag, Excel displays a tooltip containing the row height in points and in pixels.

When you increase the height of a row, the vertical alignment of your data becomes more apparent. By default, Excel aligns text at the bottom of the cell. When you have increased the row height, as you will often do with headings, changing the vertical alignment to centred is usually more visually appealing.

About the Author:
by Andrew Whiteman

Microsoft Excel offers us a number of different ways of changing the width of columns and the height of rows. The width of columns is expressed as the number of characters the cell can hold. By default, Excel gives each column a width of just over eight characters. This means, for example, that if you're using a spreadsheet primarily for numerical data, you can enter eight digits in each column using the default width.

If you plan to modify the default width, it makes sense to do so before you start entering data into your worksheet. For example, if you know that you'll be entering fairly short pieces of data in each column, you might want to reduce the default width. To customise the default width, go to the Cells section of the Home Tab of the Excel Ribbon. Click the Format button and choose Default Width from the drop-down. In the window which appears, you will see Excel's standard column width of approximately 8 characters. Simply input a new entry and click OK.

As long as you haven't changed the width of a column using any other technique, you can change the default width at any time and any cells that have been left at the default width will automatically change to reflect the new setting.

The second method of changing column widths is to use Excel's AutoFit feature. This technique automatically adjusts the width of a column to ensure that the contents of the selected cells are completely visible. To AutoFit a range columns, highlight the cells that you want Excel to take into account or simply highlight the entire column. Next, position the cursor on the right hand edge of the column and, when the cursor changes to a double arrow, double-click.

You can also AutoFit data in a range of columns by selecting a range of data across several columns or highlight several entire columns and then choosing Format then AutoFit Column Width in the Cells group of the Home Tab of the Excel Ribbon.

When using the AutoFit feature, it's inevitable that you'll end up with columns that have different widths. If you would like a range of columns to have exactly the same width then simply select the range and choose Format then Column Widths and enter a global width.

Excel also allows you to adjust the width of columns interactively. To do this, position the cursor on the right hand edge of the column and, when the cursor changes to a double arrow, click, hold and drag. As you drag, you will see the width of the column displayed both in characters and in pixels. This same technique can be used either to adjust the width of a single column or a range of columns.

About the Author:
by Charlie Taylor

WOW! How could you choose? The long awaited release of the Apple iPhone 3G, with its open support for third party applications, showered us with hundreds of new choices in iPhone software and iPhone apps. The iTunes App Shop opened with over five hundred authorized applications. They ran the gamut from merely fun stuff to business to travel to the weather to highly scientific apps and everything else in 'tween. And that was just the opening day! New iphone apps are being developed and released as we speak. So picking the top 4 iPhone software and apps is a challenging call. But we'll give it a go, simply so you will be in the know about the newest!

Our Top Pick is a whole set of iPhone software and iPhone apps all on one DVD. It's the supreme entertainment package from TheiPhoneDVD.com. How anyone ever got this much stuff into 1 DVD is a feat in itself, but it works! And you get to relish the results of their tough work. Check it out:

You get the greatest software on the market today to convert your DVD movies to your iPhone. Converting your movies is prompt and easy with their 1 touch graphical interface. It merely cant get any easier than this. You can convert your whole library of DVD movies to iPhone movies in record time. Need a break? Watch your favorite movies right on your iPhone.

Some other software on The iPhone DVD solves your dilemma regarding how to unlock your iPhone safely, legally, and with out having to utilize AT&T for your carrier if you dont want to. Utilising this iPhone software, you can connect to any mobile carrier service you want.

The iPhone DVD also carries the broadest collection on the planet of iPhone wallpapers, ringtones, graphics, animations, sound effects, and video clips. With this package, your days of being exhausted even for a minute are in the past.

Put several pizazz into your life with The iPhone DVD!

Our next 3 Top Picks are a few of the new iPhone applications from the iTunes Application Store.

One of the hottest rages on the Net is Twitter. People around the world are succeeding each other on Twitter, and getting a big kick out of it. Hence, Twitterific is our top pick from the iTunes App Shop. With this iPhone app you could continue your twittering right from your iPhone!

Other fun iPhone app from the iTunes Application Shop is PhoneSaber. This cool application turns your iPhone into a light saber. You even get sound effects! Savour the fun and excitement of Star Wars wherever you may roam with PhoneSaber.

Our final pick unites the memories of past times with today's high tech lifestyle. Its the Rotary Dialer iPhone app from the iTunes App Shop. This application turns your iPhone into a rotary dialer. Dial your calls the old-fashioned way, and bring back the good times, with the Rotary Dialer.

So thats your Top four iPhone software and applications. Be sure to visit TheiPhoneDVD.com to see how the supreme entertainment package could bring you total customisation of your iPhone and nonstop entertainment all in one.

About the Author:
by Andrew Scott

Backing up your data on almost any electronic device is crucial to keep things intact. No computer or other electronic device is crash proof, and problems can occur at any time, normally resulting in the loss of all data that was stored on the hard drive. Data backup is the best and only way to ensure that your files, music, photos, and more remain safe and secure. Make sure that you backup your data regularly.

When it comes to backing up your data using software, there are five different basic methods that you can use: Full backup - A full backup will create a mirror of your hard drive, every file and folder that you currently have on your computer.

When you decide to get a software program to assist you with backing up your files, you should always get a program that best fits your needs. Price is also an important factor, although ease of use and overall reliability should always be the most important factors when it comes to your data. Most programs are easy to use, so even if you have never backed up your data before, youll be able to do it without any problems. All you will need to do is load the software then follow the instructions that come up on the screen.

Differential backup - A differential backup creates the backup only for files that have been changed or upgraded. Disk image - This will give you the choice of backing up your entire hard drive or just the files that you select.

Differential backup - A differential backup creates the backup only for files that have been changed or upgraded. Disk image - This will give you the choice of backing up your entire hard drive or just the files that you select. Unattended backup - Using this method, you can set the software that will create the backup to do all of the work, even if you aren't around. Snapshot backup - A snapshot backup will mirror your hard drive, backing up the images of your files.

About the Author:
by Carol Alexander

When formatting text within an Excel worksheet, you have the choice of working at the cell level or at the text level. If you wish to work at the cell level you simply highlight one or more cells and choose your format settings. Any formatting that you choose will then apply to all text within the cell or cells.

For example, if you wish to change the font size of your data in Microsoft Excel, you can use the drop-down menu next to the font name and choose one of the preset sizes. You can also use the Grow Fond and Shrink Font buttons located on the right of the font size. These two buttons simply cycle through the same preset sizes available on the preset size drop-down. You can also use the up and down arrows on your keyboard to move through different sizes. Yet another option is to enter a specific size then press the enter key. When doing so, you are permitted to enter decimals, such as 10.5.

In a similar way, when you want to choose a font, you can highlight the current name and start to type the name of font you have in mind, for example Times new Roman. Once you have typed enough to let Excel know which font you mean, the font name will be displayed and you simply press the Enter key.

Colour can be similarly be applied in two ways in your worksheets either as a background to the cell or to the text inside the cell. Because background colour applies to the cell it cannot be applied at the text level. With the creation of Themes in Excel 2007, Microsoft have made it very easy to come up with colour combinations which look good together.

To work at the text level, you need to be in Edit mode. You can enter Edit mode in two ways: the first is to double-click on any cell; the second is to click once on the cell and then click anywhere in the formula bar. You can tell when you're in Edit mode by the presence of the Cancel and Enter buttons on the left of the formula bar.

When working in Edit mode, it becomes possible to highlight individual characters and change their attributes. For example, say a cell contains the text "Google"; you could highlight each letter individually and change it to the colour used in the Google logo.

The facility of having different formats within the same cell is very useful for headings. It is less useful for the rest of the data in your worksheets since it slows down data entry and makes editing difficult.

About the Author:
 Page 3 of 13 « 1  2  3  4  5 » ...  Last »