EXCEL FOR MAC FILTER ERROR PASSWORD

STEP 4- Click on Find all button in the find and replace the window. STEP 3- Head over to the Alignment tab and select merge cells. STEP 2- Click on the Format button, it will open up another window. STEP 1- Press Ctrl + F keys to open find and replace menu, Click on the options> button to enlarge the popup.

Follow this process to unmerge the cells in your document. If you have merged cells in your document, the filter option would not work so you have to unmerge the cells.

EXCEL FOR MAC FILTER ERROR PASSWORD

STEP 3- Type in the password of the sheet and hit Enter. STEP 2- Click on the Unprotect Sheet, it will open a password pop-up. STEP 1- Go to the Review tab from the main menu of the Excel. You will also need the password of the file Follow these steps to unprotect your file.

So, to filter data from the protected document first you have to remove the protection from the file. Password protected spreadsheets are restricted to edit and therefore it can not be filtered. You will find your Data tab is enabled now. Select all the sheets by holding down Ctrl key and left-clicking on sheets, right-click on one of the sheets and select ungroup sheets option. As annoying, this problem is, the solution is very easy. This is an annoying issue because you can’t figure out what’s wrong with the excel and why the data tab is disabled. NOTE: Double-check the row before deleting anything because if you delete anything important it will be hard to recover.įilter options are disabled when you have grouped sheets in your document, all the options of the data tab would be greyed out if the document has grouped sheets. If you have multiple blank cells, first select all of them by holding Ctrl key and left-clicking on the row number and then delete all rows simultaneously. Right Click on the same row number and select the delete option. To delete blank cell rows, left-click on the row number which has a blank cell, it will highlight the entire row. To delete unwanted cells from the column you will have to delete the rows in which the blank cell is present. Method 2 – Delete blank cells from the tableīlank cells hinder the filtering process in MS Excel so before you filter a column make sure that you don’t have any blank cells in between the data which would cause issues during the filtering data. STEP 4- Apply the filters you want to apply on the column and then click Ok to save your settings. Scroll down to the last until last number and uncheck blanks to disable the filtering of blank cells. In the same pop up you can see all the numbers from your column are selected by default. It will open up the filtering options pop-up. STEP 3- You will find an inverted triangle on right to the first number of your selected column, left-click on it.

Excel for mac filter error