how to use the fill function (serial no)while we are in filtered field

S

sreenoo dhanpal

we are unable to give or fill the column with serial
numbers by using the fill option while we are in filter
mode means selected one of the filter option of the drop
down list of filter.
 
B

Bernie Deitrick

sreenoo ,

That's right, you can't do that in filter mode.

Instead, you can sort your data based on your filter criteria, then do the
fill.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
MS Project Center-Autolink column fields 0
How to make repeating drop-down lists? 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Finding the right style field in VBA 0
Publisher is filling blank lines with data 2
A couple questions BEFORE using Office 365 0
Resource graph/total for a filtered set of tasks 0

Top