I need to delete rows and Ive tried everything - unlocked format, removed filter.

It may be real basic but Im lost Ive attached part of the spreadsheet.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star add reputation.

Edit: found a way to delete (although still in xl2003): There is a list toolbar appearing when you select a cell on the left.

In Excel 2003 you can do that by selecting a cell in the list -- data -- list -- convert to range -- OK.

Click home -- Find Select (on the right side) -- Go To.

Select Table1 You will see that a column of data is selected.

Right click on it -- Table -- Convert to Range -- OK Repeat that for all tables and youre done.

Press W8K R and and type following into Run dialog box, press Enter: appdataMicrosoftExcel 2.

Next, in the Excel folder so opened, youll find that there is an Excel15.xlb file along with XLSTART folder.

All you need to do here is to rename Excel15.xlb file to Excel15.old file.

Reboot the machine now and you must be now able to manipulate sheet rows and columns with Insert and Delete options.

FIX 2: Cant Insert Or Delete Sheet Rows And Columns In Excel 2013 NOTE: Making mistakes while manipulating registry could affect your system adversely.

So be careful while editing registry entries, also its better to create a System Restore point before proceeding.

Press W8K R and put regedit in Run dialog box to open Registry Editor (if youre not familiar with Registry Editor, then click here).

Click OK. RegistryEditor 2.

In the left pane of Registry Editor window, navigate here: HKEYLOCALMACHINESOFTWAREMicrosoftOffice15.0ExcelOptions 3.

After rebooting the system, launch a new instance of Excel and youll observe that you can use Insert and Delete options without any problem.

In the event Code provided resolves your issue, please mark your Thread as SOLVED.

Why Can'T I Delete In Excel For Mac