I'm working on a "data collection" exercise where I have 6 columns and am trying to determine if I use simple Cell Formatting or create a Table. What I need is control over the text formatting. This may include highlighting the input data in that column or row, or adding numbers or bullets for each item statement. Also, by wrapping the text, I need the spreadsheet to auto adjust to the row height. A further example; if I have a column where the text that will be entered needs to be "bulleted" I can't seem to locate how to do that for that particular column each time new text is entered and a CR is created. Any insight or help or advice on this would be appreciated.
1.) Better off with cell formatting or creating a Table with certain characteristics?
2.) How do I select auto adjusting for the row height when I have "wrap text" on?
3.) How do I get auto bullet points as I add a carriage return within a cell?