Unfortunately I am unable to get easyfilter to work in Excel 2007. I had come to rely on this handy tool and unfortunately the upgraded us at work.
Is there a workaround or a new version?
Thanks!
Unfortunately I am unable to get easyfilter to work in Excel 2007. I had come to rely on this handy tool and unfortunately the upgraded us at work.
Is there a workaround or a new version?
Thanks!
Tables have auto filters built in, create a row of headers then goto insert table and select that row and check that it has headers. Now you can click on the header drop downs and sort or filter easily, to modify table colors, banding, or add a total bar simply click inside the table or a header and you we see a table UI appear on your ribbon up top.. Click it and play around, to add a new row to your table select the bottom right cell in the table and press tab, or right click in the table and click insert row above.
hope this helps!!
Excel 2007 SP1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks