How exactly did you protect the table and column. Can you provide those steps. The best way to do is to protect the sheet with access to insert table. Do not have other protection enabled. When you create a table all the columns are actually protected by default, but to enable this protection you need to protect the sheet.

This tutorial shows how to wrap text in a cell automatically and how to insert a line break manually. You will also learn the most common reasons for Excel wrap text not working and how to fix it. Primarily, Microsoft Excel is designed to calculate and manipulate numbers. The bottom line is that if the Normal style is formatted to have a box around it, then there is a good chance that all your paragraphs will have boxes around them. Check the style formatting and remove any boxes that may be associated with the style, and your problem may be immediately fixed. The following screenshot shows how wrapped text looks like in Excel: How to wrap text in Excel automatically. To force a lengthy text string to appear on multiple lines, select the cell(s) that you want to format, and turn on the Excel text wrap feature by using one of the following methods. The weird spacing is always in the last line of the paragraph. After the period at the end of that last sentence, hold the space bar down until the spacing looks normal. Then make another period.

Reinstall Office. I had the same problem - only visible with MS Excel and no other programs. Areas that are blacked out would shift on scrolling but never go away unless window was reduced in size and zoomed in.

This made it impossible to work on large spreadsheets. My hardware includes Dell XPS15 9550 with TB15 thunderbolt 3 dock and 34' dell 4k monitor. Right from first install the problem occurred (see screenshot below) and Microsoft help was no help at all - no suggestions after an hour on chat with remote desktop access with the help dept. Very frustrating! I updated all Dell drivers and video card drivers with no improvement. Tried reinstalling Office 365 twice with no improvement.

Then I reinstalled Office 2016 Professional Plus and the problem disappeared. Subsequently worked with Office 365 Std as well.

I can only conclude it must have been some form of corrupted file during the download/install process? Very odd and took a lot of time to find the solution.

Free graphic software for mac. Find the best graphic design apps, whether you're a designer, a beginner using drawing apps, or just looking for a PDF editor or converter. The Best Free Graphic Design Software app downloads for Mac: SketchUp Adobe Illustrator CS6 Microspot DWG Viewer Sweet Home 3D Paintbrush Sketch Corel. The best free software for graphic designers 2018. These free graphic design programs are ideal. Mac and Linux, and is a great cornerstone of any amateur graphic designer’s toolkit.

Have a Lenovo 910 512GB with 16GB, 4K monitor We have tried everything to correct this issue, 2 IT guys and MS Tech Support. We believe that MS Excel doesn't play nice with 4K monitors. When running Excel in Safe Mode, we found that the issue resolved. It is our understanding that Safe Mode disables add-ons and runs in VGA mode. Disabling Add-Ons helped a little. However, running the entire system in VGA (Safe Mode) corrected the issue.

Obviously, we are not going to run in Safe Mode. I have decided to live with this announce until MS updates their software to work with 4K monitors properly. How to repair damaged mp4 video files for mac. I hope that this helps.

I asked this question on Microsoft Answers, they referred me to TechNet, hopefully you can help me with this. I hope I posted in the right subforum, if not, feel free to move this post. I am using Excel on a Windows Server 2012 via Remote Desktop. When I enter something into a cell, cell borders appear around the whole (horizontal) row. When I select multiple cells and press delete, borders appear around this selection.