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


CCI Pro

Similar Resolved Queries


loading


Unanswered Queries



CCI Pro
Meet our CAclubindia PRO Members

Follow us
add to google news


Answer Query



Company
24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
24 June 2026
Senior Account (VA Client Operations)

Karbon Business

Bengaluru

CA Inter

View Details
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details