The workaround is to indent the content from the right side of the cell. The arrows cover the rightmost characters in the headings, and there is no obvious way to fix the problem. The filter arrows in an Excel table’s column headings look downright ugly when those headings are right-justified. Click Yes when Excel prompts you with ‘Do you want to convert the table to a normal range?’ and the table will revert to being a regular range-but with its attractive formatting intact. Next, click inside the table and then click Table Tools > Design > Convert to Range. To borrow a table style for any worksheet, first create the data as a table, making sure to choose your preferred table style for formatting it. But while this limitation is technically true, you don’t have to keep the table features if you don’t want them. The only potential problem is that it may seem that you can’t get the formatting without getting all the unwanted table features as well.
Take the Format but Ditch the Tableįormatting data as an Excel table is the quickest way to achieve a neatly formatted range of cells in Excel. The shortcut keystroke combination Shift-Ctrl-L accomplishes the same thing. Now you can toggle between hiding the arrows with one click and revealing them with the next.
To do this, click somewhere inside the table and then click Data > Sort & Filter > Filter. When you want to use some features of an Excel table, but you don’t plan to filter or sort your data, you can hide the filter arrows. Click the Filter option to toggle the display of the filter arrows on or off.
0 kommentar(er)
