Protecting cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1943196%22%20slang%3D%22en-US%22%3EProtecting%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943196%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20you%20keep%20the%20contents%20of%20one%20cell%20from%20bleeding%20over%20onto%20the%20cell%20to%20the%20right%20if%20you%20don't%20have%20any%20text%20in%20it%3F%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1943196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1943255%22%20slang%3D%22en-US%22%3ERe%3A%20Protecting%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1943255%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F881974%22%20target%3D%22_blank%22%3E%40Morgan1350%3C%2FA%3E%26nbsp%3BYou%20can%20select%20Home%20-%26gt%3B%20Wrap%20Text%20(in%20the%20Alignment%20group).%26nbsp%3B%20And%20if%20you%20don't%20like%20the%20row%20height%20changing%20lock%20the%20row%20height%20Home%20-%26gt%3B%20Format%20-%26gt%3B%20Row%20Height.%26nbsp%3B%20If%20you%20aren't%20sure%20what%20height%20you%20place%20the%20cursor%20between%202%20row%20headings%20and%20when%20it%20changes%20you%20can%20click%20and%20see%20the%20present%20row%20height%20and%20then%20set%20it%20to%20that%20height%20or%20after%20you%20choose%20Wrap%20Text%20you%20can%20highlight%20all%20the%20rows%20and%20drag%20them%20to%20the%20height%20you%20want%20them%20set%20to.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How do you keep the contents of one cell from bleeding over onto the cell to the right if you don't have any text in it? Thanks. 

1 Reply

@Morgan1350 You can select Home -> Wrap Text (in the Alignment group).  And if you don't like the row height changing lock the row height Home -> Format -> Row Height.  If you aren't sure what height you place the cursor between 2 row headings and when it changes you can click and see the present row height and then set it to that height or after you choose Wrap Text you can highlight all the rows and drag them to the height you want them set to.