Question about Computers & Internet

1 Answer

How to make labels from EXCEL list? - Computers & Internet

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,447 Answers

Hi-

Im not really familiar how to make label on Excel but you can try this steps that works on words:

Please follow the steps below to print Business Cards or Labels in Microsoft Word.

1) Click on TOOLS.
2) Click on ENVELOPES AND LABELS.
3) Click on the LABELS tab.
4) Click on OPTIONS.
5) Under PRINTER INFORMATION select LASER AND INKJET.
6) Under product number select the label type that you are using. If you are using Avery labels, select the number that coincides with the number on the Avery package.
7) Click on OK.
8) Click on NEW DOCUMENT.
9) This will give you the layout of the document format on your screen.
10) Type in all the information you need on one label.
11) Once the label is completed, highlight that whole label.
12) Click on EDIT, COPY.
13) Click on the next label.
14) Click on EDIT, PASTE.
15) Paste the information on all labels until page is completed.
16) Print your labels.

With this procedure, you do not need to modify the page setup or printer driver properties.

Hope this help, pls rate as fixya if this helps. Thanks!


Posted on Jun 26, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do I use Excel to pring labels with the Zebra LP2844?


I'm going to assume you can already print from the computer to the Zebra. I am also going to assume that since you have Excel, you also have Word. The first thing you need to do is layout the labels in Word. I cannot be more specific because I have no idea what size labels you are using.
Create and print labels

Next you need to merge the values from Excel into Word
Mail merge using an Excel spreadsheet

Here are some videos that might help
Mail merge Word

Feb 16, 2017 | Zebra Office Equipment & Supplies

1 Answer

HOW DO I CREATE A DATA BASE FOR FILE LABELS USING AVERY LABELS 6646? THANK YOU, BARB KOWALSKI


you can do it in excel
then mail merge excel file with
word https://support.office.com/en-us/article/Mail-merge-using-an-Excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

and use avery template in word
http://www.averyproducts.com.au/avery/en_au/Templates-%26-Software/Templates

Jan 27, 2017 | Avery Office Equipment & Supplies

1 Answer

Can i export easy-mark label information into excel


On the File tab there is an Export/Import choice. Give it a try

May 14, 2014 | Panduit Easy-Mark Labeling Software...

1 Answer

When importing data from Excel 2010 spreadsheet Easy Mark says you must install Excel


If you selected an Excel spreadsheet from the Data Import dialog, you will need to select which worksheet within the spreadsheet contains the label data you wish to import. If you don't have Excel installed you'll need at least Excel Viewer as Easy Mark relies on the users system to view the worksheet.

Oct 17, 2013 | Panduit Easy-Mark Labeling Software...

5 Answers

Excel sheet has been lost how to recover


Lost Excel file can be recovered from:
  1. Recycle Bin - If you have deleted the file with normal delete.
  2. Backup - If have maintained the backup of file.
  3. Email - It may possible that you have mailed the file to someone.
  4. 3rd Party Recovery Software - Recuva, Stellar Data Recovery ...

Oct 29, 2012 | Microsoft Office Excel (License Only)...

1 Answer

Create labels on Word 7 with Avery 8250 labels


I am assuming that you want to do a mail merge from a list.

If you list is in Excel, you should be able to click mailings in Word. It will take you through the steps to create your set of labels. [It will help with other places for your lists besides Excel, too.

May 24, 2010 | Computers & Internet

1 Answer

I have several address stored in Excel. Now I


You don't need to print labels in Excel. You can use the mail merge feature in Word to do so. Use the Excel file as the data.

Nov 06, 2009 | Microsoft Excel for PC

1 Answer

I am having problems with a mail merge for tent card 5302 - can someone tell me how to merge an exisiting excel document into word?


In Word 2003:
Open the Tools Menu >> Letters and Mailings >> Mail Merge.
Select Labels and click Next
Click on Label Options and select your tent card and click OK and then Next
Select Use Existing List and click Browse to find your Excel document. Click Next.
Add in the fields you want on your cards to the first and then click Update All Labels.
Finish Mail Merge Wizard.
-- Word 2003 doesn't come with the 5302 label template. You'll need to download that from http://support.microsoft.com

In Word 2007
Select Mailings from the menu list at the top,
Click on Start Mail Merge and select Labels
Select Label vendor Avery US Letter
Select your product number 5302 and click OK
Click on Select Recipients from the top and select Use Existing List to browse to your Excel document
Using the buttons on the top for Address Block/Greeting/etc add in the fields you want to the first label.
Click on Update Labels
Click on Finish and Merge

Apr 28, 2009 | Computers & Internet

1 Answer

If function in exel


For Current Date - you can use the =Now() function in your cell where you want the date.

For Contract #, I don't know what you're using, but you can link to a database of contract #s (see below), or you can name a range like current contract #, which gets updated by 1 each time you add another contract, which then is automatically posted on your EXCEL



DGET(database,field,criteria)
Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Jul 15, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

145 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...