When using word or office spreadsheet how do you rename the columns?
348716
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
525741
You probably took some action that made the column width change (there are any number of ways this can happen).\n\nThe solution is (assuming you're using Excel or a similar spreadsheet) is to select the columns that have changed (click on the column letter and hold down the mouse button and drag across the top until all the columns you want to change have been highlighted).  Next, right click, select column width, then enter a vaule less than that shown (you can experiment with values until you get the width you want).  Finally, hit enter.
709965
Yes, but it is MUCH easier to copy and paste the entire spreadsheet to Word (highlight all the cells, Edit Copy, then open Word and go to Edit, Paste).  Now, if the information isn't already selected, do so and go to the Format menu and choose Change Case.  Make your selection.  You should be able to copy and paste back into Excel- without using complicated formulas.  I have used this technique with extremely large spreadsheets with ease.  Good luck!
672913
If I were you, I would do a mail merge from Word.  First of all, you must do 2 things in Excel:\n\n1) Make sure your data is stored in the FIRST tab in the workbook.\n2) Highlight the data that you want to print to labels, and give it a range name, by typing a name in the range name box in the upper left hand corner of the Excel screen.  (Make sure you include the header row that has "Name", "Address", and "Telephone" in your defined range.)\n\nThen save your Excel file and go to Microsoft Word. In Word 2003 go to the menu under Tools > Letters & Mailing > Mail Merge.  Then indicate that you are producing Labels, press Next to get to step 2, click on Label Options and pick you type of Avery Label, click Next to step 3, browse for your recipients and find the Excel file you saved, select the named range you provided, click Next to go to step 4, click More Items and select the fields you want in each label.  \n\nYou will need to copy and paste each of these fields around the page to each label box, and make sure they are positioned appropriately.  You are setting up the first page.\n\nThen click Next and select Complete the Merge.  Each record of data should be positioned in a box perfectly fit to the Avery labels that you are using.  You can just print the pages with the label paper in the printer.
840236
If have the same problem importanting my data.\nIn fact there are two problems, one is the separation between data columns, the other is the fact that in American notation for dates and numbers is different from the European one.\n\nIf you open a csv file  OpenOffice shows you a Text Import window.\nFirst you change the Separator options. In my case the Comma field is set, so I change it to semi-colon ; as my data are separated like that, but it might be that space or tab is the correct choice for your data.\n\nNow you have your data in correct columns.\n\nGo to the Fields lower on the pages. Each column is labelled Standard. Right clicking on the word Standard gives you various other options including several ones for the date, as well as the difference between American and European number format.\n\nIf you don't get OpenOffice to understand you, there is no other choice than to change the input file by hand or macro first.\n\nPS If a date does not contain the year, OpenOffice *always* assumes it is the present year. Therefore you have to change the date columns either by including the year explicitly, or in OpenOffice after import.\n\nPS2 I have everything automated with macros. After all it is an exercise one has to repeat often.
605076
This is a quirk that happens all the time in mail merge between Excel and Word.  One way to fix this is convert the Excel field you are merging to text.  \n\nSo instead of merging in a column containing 9.8, you would merge in a column containing text representation of the number column.  Use the TEXT() function in Excel to convert the numbers to text, then use that column in your merge field instead.  This way you can insure that everything you bring over to Word is text, rather than a number.
234098
NO! Not technically.\n\nA database has to have fixed number of named columns. Spreadsheet has a open stucture.
317360
If for example your older data is on Sheet1, then in the column next to the 'New company name type this formula in cell B1\n\nHere is the formula\n\n=IF(ISNA(VLOOKUP (A1,Sheet1!$A$1:$A$2310,1)), "New Data","Existing Data")\n\nCopy this formula next to each of the new addresses.\n\nIf it finds an existing entry the Word "Existing Data" will appear, and if it's a brand new entry then the word "New Data" will appear!\n\nYou can then simply use an AutoFilter to sort out the new and existing data (You will need headings over your data)\n\nHope this helps.
475445
Use as the one above told you\n\n\nOR\n\njust copy and paste it\n\nXLMan
135188
1. Open Microsoft Word \n2. Click "Table". \n3. Click "Formula". \n4. In the formula box, type the following: \n=X97:S1587 \n5. Change the number format to 0.00%. \n6. Change the paste function to SUM. \n7. Press OK. \n8. "!Syntax Error, :" will appear. \n9. Highlight "!Syntax Error, :". \n10. Go format, font and change the color to \nGray-25% \n11. Click OK. \n12. Highlight "!Syntax Error, :". \n13. Go format, font and change the font effects to Double strikethrough and Embossed. \n14. Press OK. \n15. Go to the line beneath "!Syntax Error, :", and type "MotoMad" in Rockwell, size 29. \n16. Press Enter twice. \n17. Press File, Save As, and save it as "MotoMad". Then press "Options". \n18. Change "Save Word Files As", to "Rich Text Format". \n19. Click OK and Save the file in any folder. \n20. Close Word and open the file from the folder you saved it to. \n21. This should open Motocross Madness V.1.1. \n22. Use the arrow keys to steer the bike and space for extra turbo\n\nHave fun!!!
102604
I am assuming that you are using Excel.  Highlight your cells and click Format->Cells on menu bar.  Change from text to Number.
626042
The best way to do this is to first save the Works spreadsheet to a .csv file.  Saving the file in this format will keep all the data and allow Dreamweaver to import it, where it should keep the columns and rows aligned.\n\nAfter you've saved the file in csv format, open Dreamweaver and go to File > Import > Import Tabular Data.  When the options box appears, browse for the csv file, and then change the delimiter to comma.  Then hit Ok.
618625
It's not clear whether you want to do this manually or via a 'macro' (i.e., in Visual Basic), but anyway, here's the Visual Basic.\n\nTurn off gridlines and column and row headings:\n\nActiveSheet .PageSetup .PrintGridlines = False\nActiveSheet .PageSetup .PrintHeadings = False\n\nFormat headings using some text formatting:\n\nWith ActiveSheet .Range("A1:A5")\n  .RowHeight = 20\n  .Font.Bold = True\n  .Font.Size = 12\nEnd With\n\nSet borders around an area (e.g., summary):\n\nWith Worksheets("Sheet1") .Range("D3:F7") .Borders\n  .LineStyle = xlContinuous\n  .Weight = xlDouble\nEnd With
895660
you just for a appending of the datas ...\nThe dept name should be taken the add the last two didits of year then add the numbering... have each in seperate column and append them
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
794734
no.\n\ngoogel irfanview.  it does renaming in batches.
1005550
Use excel, somewhat easy and really organized