how do you delete multiple cells in excel for mac

You can find some good information on possible solutions on this page: If these suggestioins don't work, then you'll need to continue with the trial-and-error process. Use Save As to store the workbook on a local drive, then open the new version of the workbook and do the deletions.Try opening the workbook on a different machine or in a later version of Excel.Restart your system, open Excel before anything else, and try to do the deletion.Save after the clearing and then try to delete the previously cleared columns and rows. Clear the contents of the columns and rows instead of deleting them.Delete rows and columns one row and column at a time, rather than deleting large numbers of rows and columns at once.Turn off automatic calculation before you attempt to do the deletions.(Microsoft isn't that great on providing helpful information in some of its error messages this particular message is a prime example.) There are a few things you can try that are quite easy. Tracking down and correcting this type of problem can be frustrating, as it could be caused by any number of things.

He wonders if there are any thoughts as to how he can remove the columns and rows. Harvey has Googled the problem and tried all the suggested solutions but still has the problem. He needs to delete some rows and columns, but Excel gives an error message that he does not have enough resources. In total there are about 420,000 formulas in the worksheet. It has formulas in about 600 of those columns, some of which refer to other worksheets held on the server. Thanks to comments on HowToGeek and Windows instructions on has a large Excel worksheet, cuurently 700 columns and 1000 rows. Select “Shift cells up” Select “Shift cells up” and click “OK” 8. That’s the “minus” key (to the left of the plus key on top row). Press “Control+minus” to delete the highlighted rows Select “Blanks” in the “Go To Special” dialog Select “Blanks” in the Go To Special dialog 5. Select “Special…” Select “Special” on the “Go To” dialog 4. I have not been able to find this window in Excel menus. Press “Control+G” to bring up a special “find” window This CSV from AT&T comes complete with a lot of blank rows. Select the blank rows that you want to delete.Īll the how-to’s online suggest including the row “above” and “below” the affected area.

(Think “double-space” in writing.) I want to rid the data of the blank rows without having to manually click-and-delete each row. I’m working with data from AT&T, and the CSV has a blank row between each row of data. If you haven’t upgraded Mac Office because 2008 does what you need to do … this tip may be for you: how to delete Excel blank rows.

How do you delete multiple cells in excel for mac