Drag and drop option?

We know if we write

1

2

3

in one column and after selecting it if we place the cursor at "bottm-right" then appears + sign and if we drag below then automatically comes

4

5

6

7

8

9

etc.........

 

But in my systerm + sign is not appearing how can i enable it? 

Replies (4)

Hi Ravi,

Let me tell you another way of doing it.

You type 1 in the cell

Now go to the below cell

Type=

Then again go back to the cell in which you have typed 1

Type +1

Then type Control C in the cell in which you have typed the formula i.e the second cell

Press Control down arrow

You will go to the last cell

From the last cell

Press control+shift+up arrow together

Press

Enter

You get the series

Thanks ravi for you tips

But my motive is not to write down 1, 2, 3, 4, 5.......... etc in series.

I want to search the option where appears + sign when i place cursor at bottm down. because it will help so many like- copying the formula.

which version of excel u r using 2003 or 2007?

if 2003 go to Tool menu - Other option sub menu then select edit and ative ALLOW DRAG & DROP

2007 I tell u later.

In Excel 2007, Click the office button, at the right side down corner u can find EXCEL OPTIONS, click on it, a dialog box appears in it click on ADVANCED option then select the 3rd one i.e., ENABLE FILL HANDLE AND CELL DRAG-AND-DROP.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details