Possible to Save a Filter Pattern??

[thewiseguy]

**Edit - subject should read: Possible to Save a SORT pattern.

Hello all. Here is my active sheet:

Catalog.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
2
3		MaskedPartNumber	PartNumber	Indoor_Outdoor	Product_Type	Product_Subgroup	Application_Subgroup	Size	Brand	CCT	DLC/EnergyStarID	Emergency Backup	LampBase	Lamps Per Fixture	Lumens	RatedLife_for_Proposal	Voltage	Warranty Yrs	Watts_for_Incentive	Watts_for_Proposal	DLC_Category	DLC_Measure
4		EIKO 1L 24W LED 4ft T5 Lamp [5K]	LED24WT5HO/46/850-G9D	Indoor	Lamp	Linear_Lamp	T5_Linear	4ft	EIKO	5000K			G13	1	3500lm	50000	120-277V	5	24	24	DLC Linear Repl. Lamps	4’ HO Replacement Lamp
5		EIKO 2L 24W LED 4ft T5 Lamp [5K]	LED24WT5HO/46/850-G9D	Indoor	Lamp	Linear_Lamp	T5_Linear	4ft	EIKO	5000K			G13	2	3500lm	50000	120-277V	5	24	48	DLC Linear Repl. Lamps	4’ HO Replacement Lamp
6		EIKO 3L 24W LED 4ft T5 Lamp [5K]	LED24WT5HO/46/850-G9D	Indoor	Lamp	Linear_Lamp	T5_Linear	4ft	EIKO	5000K			G13	3	3500lm	50000	120-277V	5	24	72	DLC Linear Repl. Lamps	4’ HO Replacement Lamp
7		EIKO 4L 24W LED 4ft T5 Lamp [5K]	LED24WT5HO/46/850-G9D	Indoor	Lamp	Linear_Lamp	T5_Linear	4ft	EIKO	5000K			G13	4	3500lm	50000	120-277V	5	24	96	DLC Linear Repl. Lamps	4’ HO Replacement Lamp
Linear Lamp

The sorting pattern I have used is the following:

application subgroup

size

brand

CCT

Watts for proposal

lamps per fixture

Is it possible to save this pattern so that anytime i make a change to the worksheet, I have this pattern to select and re-sort?

I have many sheets in this workbook and some have different sort patterns.

Any help is appreciated!!

 

[Anfinsen]

Hello!
All you need to do is select a cell in the data and press Ctrl+T or display the Insert tab of the ribbon and click the Table tool. Once the data table is set up and you sort it, Excel stores the sorting criteria with the workbook so it is available when you later work with the table

 

[Fluff]

Excel stores the sorting criteria with the workbook so it is available when you later work with the table

It does that on a normal range. No need to convert to a table.

 

[thewiseguy]

thank you guys