explain me some excel 2007 advance options..!

This query is : Resolved 

30 July 2009 while i use filter option in my excel sheets, i can't able to give serial numbers by clicking and dragging simply using the mouse. it was really difficult to give numbers manually to whole sheets..
pls anyone clarify me this doubt..
this would be more helpfull tm me..
thanks in advance..

kumar

14 March 2012 Click on the home button. Click on excel options. Go to Advanced. Check the 'Enable fill handle and cell drag-and-drop' option.

Now it will work.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro

Follow us
add to google news


Answer Query



Company
ARTICLESHIP 30 June 2026
2 posts Article assistant and Articleship completed students

Chirag N Shah & Associates

Mumbai

CA Inter

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
14 July 2026
Senior Executive/ Manager

H S SHARMA AND CO

Pune

CA Final

View Details
Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
20 June 2026
Chartered Accountant

ANV & Company

New Delhi

CA

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
06 July 2026
Accountant

Agarwal Anoop and Associates

Noida

CA Final

View Details
Company
06 July 2026
Senior Accountant

Arvindkumar Maniar & Co.

Rajkot

CA

View Details