Question about Microsoft Windows XP Professional With Servise Pack 2 (e8503040) for PC

I have feeded addresses of my clients in excel sheet. First column contains Name, second columon contains firms name, third contains house No., fourth contains street name, fifts contains area, sixth contains city, seventh contains State Name. I want to print address on envelops. My problem is that how I creat lables or say address in such form so that I can print on the envelp

Ad

Sir u just have to write all info row wise then ur issue will be resolved good luck

Posted on Oct 22, 2007

Ad

Sounds like your issue can be solved readily with a pivot table.

If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.

Insert the Pivot table into a new worksheet.

A new sheet will open with a strange-looking control panel on the right of the window.

Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.

Insert the Pivot table into a new worksheet.

A new sheet will open with a strange-looking control panel on the right of the window.

Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

Use data filter option in Excel to get data filtered as per your requirement & copy and paste into you access database

Aug 12, 2017 | Microsoft Access 2002 for PC

The easiest way to do this is to use Excel spreadsheet.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

Parts of the Excel 2007 Screen

Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

Merging Columns In Excel
Now that we've clarified what merging columns actually means, we can explore how to do it. The first step is to perform the merge for the first cells. Let's go back to our first example and suppose that we are merging column A that contains first names with column B that contains second names. We'll put the merged columns into column C. To merge cell A1 with cell B1 we woul type the following into cell C1:=A1&" "&B1

paste this into C1 (or where needed)

=A1&" "&B1

paste this into C1 (or where needed)

=A1&" "&B1

Jun 15, 2010 | Microsoft Office Excel 2007

More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. **First Name** in Cell A1 **Last Name** in Cell B1 **Address** in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.

It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.

Save your document as an Excel document where you can find it to import it into Word.

Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.

Select Envelope and next. Select envelope options to change envelope size, font and print options.

Click on Next Select recipients.

Click on browse under select an existing list.

Select the Excel file with your address information.

From the Select Table check the First row of data contains column headers.

Click on the OK buton.

Arrange your envelope then Preview it and your good to go.

If you have an older version of word selects Tools and click on Mail Merge.

Select Get Data.

Pull down Excel for document type.

Select entire Spread Sheet.

Layout your document and complete the merge.

On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.

I hope this helps since I did not have enough information from your question.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.

It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.

Save your document as an Excel document where you can find it to import it into Word.

Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.

Select Envelope and next. Select envelope options to change envelope size, font and print options.

Click on Next Select recipients.

Click on browse under select an existing list.

Select the Excel file with your address information.

From the Select Table check the First row of data contains column headers.

Click on the OK buton.

Arrange your envelope then Preview it and your good to go.

If you have an older version of word selects Tools and click on Mail Merge.

Select Get Data.

Pull down Excel for document type.

Select entire Spread Sheet.

Layout your document and complete the merge.

On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.

I hope this helps since I did not have enough information from your question.

Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

Jul 15, 2008 | Microsoft Excel for PC

If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Dec 19, 2007 | Computers & Internet

110 people viewed this question

Usually answered in minutes!

×