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:

Tip

Copy PDF tables to excel?


"I have a national statistics book in PDF, it has a number of tables I want to work with in excel. So I paste all the colums and copy in Excel. However, the format is wrong, all colums in a single excel colum. How can i deal with it, any suggestion?"<br /><br />Are you also be troubled with the problem? Here share you an easy solution to solve it.<br /><br />The PDF to Excel Converter can convert PDF to Excel, convert PDF eBooks to Excel on Mac with more accurate-looking and highly-editable XLS files. There will be no need to reformat the converted Spreadsheets. PDF to Excel Converter for Mac makes it a clinch to re-use tables and spreadsheets from PDF files in Microsoft Excel.<br /><br />Get a <a href="http://www.doremisoft.com/pdf/pdf-to-excel-xls-converter-mac.html"><span style="font-weight: bold;">PDF to Excel Converter for Mac </span></a>users or <a href="http://www.doremisoft.com/pdf/pdf-to-excel-converter.html"><span style="font-weight: bold;">PDF to Excel Converter</span></a> on Windows OS<br /><br />Free download it and get a free try!<br />

on Nov 23, 2010 | Computers & Internet

2 Answers

Have a excel password protected file. have forget my password. help me in opening my file


How to Crack Excel Spreadsheet Passwords by Petri IT Knowledgebase Team - January 8, 2009 Often when an employee departs, they take important Excel passwords with them. This guide outlines how to use a simple Excel password recovery application to crack lost or forgotten passwords, allowing you to unlock password-encrypted Microsoft Excel documents quickly as possible.
Step 1: Download and Install the Office Password Recovery Utility To perform the following recovery steps, you'll need to grab the download of Office Password Recovery Pro, available directly here. (2.1Mb)
Once you've downloaded the program, run the install with the default options.
Step 2: Navigate to the Protected File and Begin the Recovery Process Click the Open button on the top left, navigate to the protected spreadsheet file:

May 09, 2009 | Computers & Internet

4 Answers

Excel files couldnot opened


It is because your excel file is get corrupted. There are several reasons of excel file corruption; virus attack is main reason of corruption. You can fix this problem with the use of "open and repair" utility of MS excel or you can use Excel repair tool http://www.stellarinfo.com/excel-recovery.htm .

May 05, 2009 | Computers & Internet

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

Countifs solution for excel 2000


=SUMPRODUCT(--(List!$O$2:$O$328<>"YES"),--(List!$G$2:$G$328<>"Y"),--(List!$E$2:$E$328<>"DONE"),--(List!$E$2:$E$328<>"FIN"),--(List!$F$2:$F$328<>"AOL"),--(List!$F$2:$F$328<>"NO"),--(List!$F$2:$F$328<>"ON"),--(List!$T$2:$T$328<>"YES"))

Apr 27, 2009 | Computers & Internet

1 Answer

How do I Print Address Mailing Labels from Avery 300-Easy Peel White Mailing Labels, on Windows XP,CP?


You'll need the actual Avery code for this, or at least the correct measurements.
Open up Microsoft Word. Go to 'Tools' and find 'Letters and Mailings' in the list. Then off of that is 'Envelopes and Labels'. Click on that one and a box will pop up. If you click on 'Options'. From here you can find the correct label settings by the code which will be on the Avery pack. If you haven't got the code, you can scroll through the lists and highlight options to see the measurements but this will take you a while.
Once you chosen your labels, click on ok. Now you can enter your address in the box and print a whole page of the same address or click on 'New Document' and that will give you a page set out correctly for that label sheet.

Nov 19, 2008 | Computers & Internet

2 Answers

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet


This error message occurs if the following conditions are true:
  • The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
  • You create an object, such as a cell comment, in any cell in a column.
  • You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
  1. In the upper-left corner of the Excel window, click the Microsoft Office button.
  2. At the bottom of the menu, click Excel Options.
  3. Click Advanced from list of options on the left.
  4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6. 
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
  1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
  2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
  3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
  4. In the Format dialog box, click the Properties tab.
  5. Click Move and size with cells, and then click OK.
  6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
  7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.
For more information, visit the Microsoft Knowledge Base article: http://support.microsoft.com/kb/211769

Nov 06, 2008 | Computers & Internet

5 Answers

Microsoft office excel encountered error


This problem may occur if a noncontiguous selection is included in any one of the following: • Sheet selection • AutoFilter • Publishing Excel data to a Web page • Conditional formatting • Pivot Table reference • Pivot Table area • Pivot Table location • Unknown XML

it that does not work then goto control panel and reinstall office

Jun 23, 2008 | Computers & Internet

1 Answer

I have just taken delivery of a new laptop. The product key number (25 characters) on the base of the when typed into the microsort software in order to activate word,excel etc, states that it is...


The product key is for the operating system not MS Office products

You know Office costs extra, there is a trial software you get

I would suggest downloading Star Open Office, it's free and recognizes word, access, excel, power point etc.

Apr 03, 2008 | Computers & Internet

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

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

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

Answer questions

Manuals & User Guides

Loading...