How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask namstech Your Own Question
namstech
namstech, Electrical Engineer
Category: Microsoft Office
Satisfied Customers: 2126
Experience:  Expert in Microsoft Word, Excel, Powerpoint, Visio
31303650
Type Your Microsoft Office Question Here...
namstech is online now
A new question is answered every 9 seconds

If I want to compy line 2-10000 on excel how would I do that

Resolved Question:

If I want to compy line 2-10000 on excel how would I do that without scrolling down the whole page.
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  namstech replied 5 years ago.

engr.najeeb :

Hello, and welcome to JustAnswer!

engr.najeeb :

You can do that as follows:

engr.najeeb :

Select cell 2.

engr.najeeb :

Use the scroll bar on the left to locate cell 10000.

engr.najeeb :

Press and hold CTRL key and then click on cell 10000.

engr.najeeb :

This will select lines 2-10000.

engr.najeeb :

and there is even a simpler method that that.

engr.najeeb :

If you type the following in the Name Box the following, it will automatically select A2:A10000

engr.najeeb :

If you have more than one columns in lines 2-10000 that you want to select, say 4 columns, you can type the following in the name box:

engr.najeeb :

A2:D10000

engr.najeeb :

Here is an illustration from Excel 2010.

engr.najeeb :

Full Size Image

engr.najeeb :

Let me know if you have any questions. Thanks :)

namstech and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions