I would be happy to know if I could help. The table looks like before, only suddenly the filter and sort button can be used again! Select values and source formatting here. Then create a new, empty worksheet and click in the first cell.īy pressing the right mouse button and inserting content, you now get a variety of possible insert types. Then right-click in the selection and click Copy. The faster way: Select the complete table by clicking on the small triangle between the row and column names. This allows you to analyze step-by-step what exactly is responsible for the error, but it is also time-consuming. The first solution is to remove the table template: highlight the affected cells and remove any formatting, coloring and backgrounds. The cause here is usually the application of a table template to some cells, which is more or less confusing to Excel. The way via right mouse button on the cells to be sorted> Sort does not work either. In such a case, the Sort and Filter button in Excel is grayed out and cannot be selected when certain cells are selected.
It's good that there are quick solutions! Not being able to bring the cells into the required order makes your work unnecessarily difficult. When sorting or filtering is no longer possible, you often face a major problem. When you work with a table, it becomes larger and more complex over time.
The great strength of Excel is the management of an almost infinite amount of data. Link: XLS files and Office Web EXCEL DOES NOT ALLOW FILTERS OR SORTING This has to be repeated in a file for all sheets that have activated the "Break preview" view. In the existing XLS files, switch from "View"> "Break preview" to "Normal" e view. Save new files only in the new (XLSX) format (because only this can be edited in the browser via OWA). To do this: Open the XLS file and then "Save as", file type "Excel workbook (*. The possible workarounds can be seen below.Ĭonvert existing files to the new XLSX format
View> Break preview is activated in one of the data sheets.Ī solution as far as I could research on the internet has not yet been found.
The old XLS file type (the problem does not exist with the new XLSX format). The problem can be observed as soon as the following constellation occurs (note the AND links):
0 kommentar(er)
