How to merge cells in microsoft excel?

This document explains how to merge cells in Excel.

Merging cells is often used when a title is to be centered over a particular section of a spreadsheet. When a group of cells is merged, only the text in the upper-leftmost box is preserved.

To merge a group of cells:

1. Highlight or select a range of cells.
2. Right-click on the highlighted cells and select Format Cells....
3. Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells.

To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. Again, this will only preserve the text in the upper-leftmost cell.

1. Highlight or select a range of cells.

2. 

3. Click the Merge and Center button on the toolbar.

   
   

How to sort data in excel?

In this simple tutorial I will teach you on various ways to sort data in excel, so as to make your work more easy and time saving.

Sort by One Column

1. Select all the cells in the list.
This is the safest approach to sorting. In most cases, you can select one cell and Excel will correctly detect the rest of the list -- but it's not 100% certain. Some of the data may be missed.
2. Choose Data>Sort
3. From the Sort by dropdown, select the column you want to sort. Note: If the dropdown is showing Column letters instead of headings, change the setting for My list has, from No header row to Header row.
4. Select to sort in Ascending or Descending order
5. Click OK


Sort by Two or Three Columns

1. Select all the cells in the list.
2. Choose Data>Sort
3. From the Sort by dropdown, select the first column you want to sort.
4. Select to sort in Ascending or Descending order
5. From the Then by dropdown, select the second column you want to sort.
6. Select to sort in Ascending or Descending order
7. From the Then by dropdown, select the third column you want to sort.
8. Select to sort in Ascending or Descending order
9. Click OK


Using the Sort Buttons

In Excel, it's easy to sort your data by using the Sort buttons on the toolbar. But, be careful, or one column may be sorted, while others are not.

1. Select one cell in the column you want to sort.
2. Click Sort Ascending (A to Z, smallest to largest) or Sort Descending (Z to A, largest to smallest)
3. Before you do anything else, check the data, to ensure that the rows have sorted correctly. If things look wrong, click the Undo button on the toolbar.

Sort by Four or More Columns

Occasionally, you may need to sort by more than three columns. For example, in a mailing list, you may want to sort by Country, Region, City, and Name. To do this, you can sort the list multiple times, starting with the least important sort.

In the mailing list, there are four columns to sort. Name and City are the least important fields in the sorting process, so they can be sorted first.

1. Select all the cells in the list.
2. Choose Data>Sort
3. From the Sort by dropdown, select City.
4. From the Then by dropdown, select Name.
5. Click OK

Excel will retain what it can of this sort while you sort by the remaining fields.

1. With all the cells still selected, choose Data>Sort
2. From the Sort by dropdown, select Country.
3. From the Then by dropdown, select Region.
4. Click OK

What exactly is microsoft excel 2003?

Microsoft Office is considered to be one of the leading application software in the world of computers. This is a widespread application among businesses. Microsoft Office consists of applications like Word, Excel, PowerPoint, Outlook, etc. Major applications that are used are Microsoft Word and Excel. Let us see the various features available in Excel and how to learn them. Read along!

If you think that Microsoft Excel is only for business purposes, you are wrong. Many use it for various personal needs at home too. Some of the features that you should understand about Microsoft Excel to unlock the potentiality of this application are working with spreadsheets, cell formatting, various menus and toolbars, entering of data and editing the same, navigating between various spreadsheets, formula calculation, inserting various functions like date/time, mathematical functions, using of various charts that are available, inserting, editing and deleting comments on cells, etc.

Read further to understand the various options available to you to master Microsoft Excel. You can learn the tricks of Microsoft Excel through CD, CBT or videos. Let us learn about each option one after the other.

Mastering Microsoft Excel through CD:

With the help of CDs, you can learn Excel at your own pace and need not spend time in attending classes. Microsoft Excel CD would contain screenshots of various commands, how to create professional looking spreadsheets, how to insert charts, diagrams, formulas, create tables, etc. You would also get hands-on training as it would be more interactive. One of the main advantages of learning Microsoft Excel using CD is that you can read at your own convenience.

Unlocking the potential of Microsoft Excel through CBT:

Computer Based Training (CBT) is yet another way where you take your own time to master the application. With the help of CBT, you get realistic, interactive and complete training. You get to learn right from what a beginner should learn to advanced level. Once the training is over, you would have mastered Microsoft Excel. You get to see simulations of Microsoft Excel application software. Some CBT also offer review quiz questions to gauge your understanding. CBT generally offer interactive, complete and comprehensive training. As it offers practice questions, you will be able to understand better and gain confidence in using the application. According to me, this is one of the best ways to learn Microsoft Excel.

Using tutorials to learn Microsoft Excel application:

Microsoft Excel tutorials are another best way to master the application. You get to learn the application in detail as there are various simulations available that are realistic and interactive. Like CDs, videos and CBT, you can learn the application at your convenience.

Why are you waiting? Grab either a CD, video, CBT or a tutorial and start mastering Microsoft Excel and unlock the power this application has got.

In this blog we will help you understand this amazing application, with the help of simple tutorials

All the best!

Great addin for excel: filter assistant

Filter Assistant

Makes filtering data easy. You can filter multiple columns at a time. "Un-filter" capability.

Filter Assistant is an add-in for Microsoft Excel 2007, Excel 2003, Excel 2002 (XP), Excel 2000, and Excel 97.

Filter Assistant in detail

The Filter Assistant for Microsoft Excel makes filtering data easy!

And, it eliminates many of the annoying features of Excel's data filter feature. With the Filter Assistant, all you do to filter data is to select the cells containing the values you want filtered and just click on the button on the Filter Assistant toolbar. Instantly, your data is filtered so that only those matching rows are displayed!

You can filter multiple columns at a time.
Just click on the first cell whose value will be used as a filter. Then, hold the Control key down and click on other cells in other columns. When you then click on the Filter Assistant toolbar button, all the columns are filtered based on the cells you selected!

One of the nice features of the Filter Assistant is that the screen does not "jump" when you filter it.

Another very useful feature is the "Un-filter" capability of the Filter Assistant. If you select a cell in filtered column and click on the Filter Assistant button, the column will be un-filtered. And, if you select a cell in the top row of an un-filtered column and click the button, this turns off data filtering.