Deprecated: Return type of WP_Theme::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 554

Deprecated: Return type of WP_Theme::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 595

Deprecated: Return type of WP_Theme::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 535

Deprecated: Return type of WP_Theme::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-theme.php on line 544

Deprecated: Return type of WP_REST_Request::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 952

Deprecated: Return type of WP_REST_Request::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 972

Deprecated: Return type of WP_REST_Request::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 984

Deprecated: Return type of WP_REST_Request::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-request.php on line 995

Deprecated: Return type of WP_Block_List::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 151

Deprecated: Return type of WP_Block_List::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 175

Deprecated: Return type of WP_Block_List::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 164

Deprecated: Return type of WP_Block_List::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 186

Deprecated: Return type of WP_Block_List::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 138

Deprecated: Return type of WP_Block_List::offsetExists($index) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 75

Deprecated: Return type of WP_Block_List::offsetGet($index) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 89

Deprecated: Return type of WP_Block_List::offsetSet($index, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 110

Deprecated: Return type of WP_Block_List::offsetUnset($index) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 127

Deprecated: Return type of WP_Block_List::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php on line 199

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp.php on line 173

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631

Deprecated: ltrim(): Passing null to parameter #1 ($string) of type string is deprecated in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/wp-db.php on line 3031

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631

Warning: Cannot modify header information - headers already sent by (output started at /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/class-wp-block-list.php:14) in /www/webvol35/u7/1kcaq2fpenszeq2/excelshortcuts.info/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1631
{"id":325,"date":"2021-02-13T17:40:46","date_gmt":"2021-02-13T15:40:46","guid":{"rendered":"http:\/\/excelshortcuts.info\/?p=325"},"modified":"2021-02-21T13:20:16","modified_gmt":"2021-02-21T11:20:16","slug":"excel-shortcut-add-filter","status":"publish","type":"post","link":"https:\/\/excelshortcuts.info\/excel-shortcut-add-filter\/","title":{"rendered":"Excel Shortcut: Add Filter"},"content":{"rendered":"\n

If you want to add filters to your headers in a table in Excel, you can go to Data > Filter, or simply use this shortcut:<\/p>\n\n\n\n

Ctrl + Shift + L<\/h2>\n\n\n\n
\"\"<\/a>
Add Filter to tables in Excel: Ctrl + Shift + L<\/figcaption><\/figure>\n\n\n\n\n\n\n\n