- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel help - filtering certain columns
Posted on 8/18/18 at 2:32 am
Posted on 8/18/18 at 2:32 am
So my first row is a banner with images and my header row is the 2nd row. I have tried everywhich way to have filters on only certain headers but it puts filters on all of the headers. I even removed the banner and made the headers in the 1st row and it still doesn't work. Now I am working off of the Projet Tracker template that I am modifying. Could that be causing the issue? Tia
3
Posted on 8/18/18 at 8:08 am to GREENHEAD22
quote:
Excel help
frick Excel
Posted on 8/18/18 at 10:03 am to GREENHEAD22
No filters are all, single or nothing. If you select just your header row and all data rows under and format as a table you get filters on all columns. Otherwise if you don't format as a table you can apply a filter to one column at a time.
Posted on 8/18/18 at 10:30 am to GREENHEAD22
You need a pivot table. Watch a few videos.
Posted on 8/18/18 at 6:52 pm to AUCE05
Also how can I add additional columns to the setup tab so that I can add and modify info in my drop downs. There is already two columns in the setup tab however for the rest I am having to go through the Data Validation tab to add options to drop downs. TIA.
Posted on 8/18/18 at 8:20 pm to GREENHEAD22
In a pivot table, you can dictate rows and columns.
Posted on 8/18/18 at 8:32 pm to AUCE05
Got it, thanks.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News