Ravi kumar (CA Student) (35 Points)
10 November 2011We 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?
cma ravi tanwar
(ca final)
(106 Points)
Replied 10 November 2011
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
Ravi kumar
(CA Student)
(35 Points)
Replied 10 November 2011
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.
CA Vikas Guduru
(Audit Manager)
(41 Points)
Replied 26 February 2013
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.
Excel Mastery Program
CAclubindia
