Using a Text Field and a CR within a Cell

I'm using a particular cell in a WS to put in notes about a particular record. Here's the problem, when I try to add a Carriage Return, it moves my cursor to another cell. I tried changing the cell type to "Text" but still, I can't do regular typing notation within the cell. Is there a way to make that particular Column (Text Cells) behave properly so that I can add text and notate correctly (instead of a single continuous stream of notes with no CRs)?

Featured Post

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Intro
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…