This maybe an Excel limitation ?? but I just want to confirm:
If I filter my data and then try to use the 'Fill Series" for my column named 'Serial #', the context menu displays the 'Fill Series' option in a disbaled/dimmed mode. Is there are workaround so that I can use the feature even if my data is filtered?
Thanks in advance.