Solved

In excel while numbering dont get the drap option.

Posted on 2010-11-30
6
369 Views
Last Modified: 2012-05-10
Hi,

In excel while numbering dont get the drap option.

Excel 2007. When i select 1 & 2 and try to drap to populate more numbers i dont get the option.

Any ideas.

Regards
Raja
0
Comment
Question by:bsharath
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 12

Expert Comment

by:sstampf
ID: 34237416
If you are saying that your "Fill Handle" has disappreared then see this:
http://office.microsoft.com/en-us/excel-help/display-or-hide-the-fill-handle-HP001216376.aspx

0
 
LVL 33

Expert Comment

by:jppinto
ID: 34237421
"Drap" or "Drop" or "Drag"?
0
 
LVL 12

Assisted Solution

by:sstampf
sstampf earned 250 total points
ID: 34237424
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 23

Accepted Solution

by:
Michael Fowler earned 250 total points
ID: 34237459
Can you see the autofill box in the bottom right corner of the selected cell

If you cannot see this square go to
Excel Options/advanced and ensure "Enable fill handle and drag and drop is selected
excel.bmp
0
 
LVL 50
ID: 34237487
Drap. I like that. I think it's a really nice way of shortening "drag and drop", which is kind of what you do with the fill handle.

I think I shall call it that from now on. The "drap" handle!

Raja, I think you've coined a new term!

To contribute something useful: when you drag the fill handle, look at the little pop ups that show how the current cell would be populated if you released the mouse there. You can toggle between the auto-increment and a straight-forward copy by holding down the CTRL key while dragging. Try it, drag the fill handle, don't release it yet and hit CTRL, then release CTRL and see the difference.

cheers, teylyn
0
 
LVL 11

Author Closing Comment

by:bsharath
ID: 34237513
Thank you all
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question