Question about Microsoft Excel for PC

1 Answer

Excel I have a very large excel document (almost 90000 rows) and i need to autofill within this document. is there a faster way as i cannot imagine using the drag fill throughout

Posted by on

  • Tim Babcock
    Tim Babcock May 11, 2010

    How are you autofilling it?

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Contributor
  • 51 Answers

Egad. Well, first off, I'd suggest splitting the document up if you can. The chances Excel will crash on all those records is pretty good.

Next, you'll need to use VBA I think. Do you know any VBA? I am guessing you probably don't. Anyway, I can't go into it all here, but I'd suggest you snag a local with some VBA skills and then point him or her to this:

http://www.automateexcel.com/index.php/2004/08/14/excel_vba_macro_to_autofill

Posted on Jun 12, 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

How to convert older Office documents to Office 2007 format


<span> <p><span>The Office 2007 applications such as Word and Excel can open a spreadsheet or a document which is in an older edition of Office. They can open such older version documents in Compatibility Mode. However, if you need to make use of various newer features available in Office 2007, you will have to convert older Office documents to Office 2007 format. The feature to covert older Office documents to Office 2007 format is very useful. For example, you can now utilize 1.1 million rows in the 2007 version of Excel. In the older versions you could only use sixty-five thousand rows. The method to convert older Office documents to Office 2007 format is the same for all applications. Here we are using the example of a Word document of previous version. If you open a Word or Excel document of an older version, you see [Compatibility Mode] as part of the title.</span><br /> <p><img src="compatibility-model-excel.jpg" /> <span>Follow these steps to convert older Office documents to Office 2007 format:</span><br /> <span>Open the Word document which you want to convert into Word 2007 format</span><br /> <span></span> <br /> <span></span> <br /> <br /> <span>Click on the Microsoft Office button on the top left.</span><br /> <span>Click on Convert on the left hand side of the menu.</span><br /> <img src="convert-excel.jpg" /> <p><span>Click on the OK button on the Microsoft Word Office dialog box which appears. </span><br /> <p><img src="corverting-documents.jpg" /> <p><span>By clicking on the OK button, the document will be automatically converted into the Word 2007 format. You will notice that now the window does not show [Compatibility Mode] as part of the title bar any longer.</span><span> </span><br /> <p><img src="show-compatibility.jpg" /></span> <p><span><span> google_protectAndRun("ads_core.google_render_ad", google_handleError, google_render_ad); </span></span><br /> <p><b> </b><br />

on Dec 12, 2010 | Computers & Internet

Tip

How to convert older Office documents to Office 2007 format


The Office 2007 applications such as Word and Excel can open a spreadsheet or a document which is in an older edition of Office. They can open such older version documents in Compatibility Mode. However, if you need to make use of various newer features available in Office 2007, you will have to convert older Office documents to Office 2007 format. The feature to covert older Office documents to Office 2007 format is very useful. For example, you can now utilize 1.1 million rows in the 2007 version of Excel. In the older versions you could only use sixty-five thousand rows. The method to convert older Office documents to Office 2007 format is the same for all applications. Here we are using the example of a Word document of previous version. If you open a Word or Excel document of an older version, you see [Compatibility Mode] as part of the title.
google_protectAndRun("render_ads.js::google_render_ad", google_handleError, google_render_ad);
compatibility-model-excel.jpg Follow these steps to convert older Office documents to Office 2007 format:
Open the Word document which you want to convert into Word 2007 format.
Click on the Microsoft Office button on the top left.
Click on Convert on the left hand side of the menu.
convert-excel.jpg Click on the OK button on the Microsoft Word Office dialog box which appears.
corverting-documents.jpg By clicking on the OK button, the document will be automatically converted into the Word 2007 format. You will notice that now the window does not show [Compatibility Mode] as part of the title bar any longer.
show-compatibility.jpg

on Sep 03, 2010 | Computers & Internet

2 Answers

How do you copy and paste one excel spreadsheet to another making sure the headers are lined up correctly.


right-click the sheet you want to copy, select "copy to", then either select the position within the current document, select annother document (needs to be open in the same excel instance) or select "new document". check the box "copy" to copy, leave unchecked to move.

Jan 01, 2016 | Microsoft Excel Computers & Internet

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    I"m trying to import a addresses using a csv Excel


    The problem occurs, only when the CSV file was edited and saved by MS Excel. The solution: use only Notepad, Excel never!

    Feb 18, 2011 | Xerox WorkCentre Pro 123/128 Printer

    3 Answers

    How can I launch without recover.c


    Look for the answer here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/653-i-get-a-message-that-the-file-is-damaged-or-corrupted

    Or:
    XLSX Repair Kit. The latest corrupt XLSX file repair software featuring a powerful data recovery core and a convenient step-by-step wizard for extra convenience.
    For more information: http://www.xlsx.repair/

    Dec 31, 2009 | Microsoft EXCEL 2004 for Mac

    1 Answer

    How do you print envelopes?


    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.

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

    1 Answer

    How to copy Excel worksheet in a word document?


    go to Insert > File >select file and insert.
    you have to select all documents when you when insert box opens.

    Mar 15, 2009 | Microsoft Excel for PC

    Not finding what you are looking for?
    Microsoft Excel for PC Logo

    Related Topics:

    190 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2644 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18381 Answers

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...