|Jan 15, 2013, 12:06 PM||#1|
Preventing text from going past cell in Excel
I have the latest version of Excel 2011 and I was wondering how to make it so the text doesn't spill over into the next empty cell.
I searched the question and some people recommend going to Format -> Cells -> Alignment and choosing "Fill," but if I type a single character in a cell, that formatting option fills the entire cell with that character repeatedly.
Is there a way to achieve this without having to manipulate the next cell with a whitespace?
|Jan 15, 2013, 12:22 PM||#3|
|Jan 15, 2013, 12:25 PM||#4|
|Jan 15, 2013, 04:18 PM||#5|
Click on the top left hand corner of your worksheet to select the whole sheet.
Right click on the worksheet and select 'Format Cells'.
Select the 'Vertical text alignment to 'Justify' and then OK.
Select the whole of your worksheet once more.
Select 'Format' from the top tool bar and select 'Row' then 'Height'.
Set the row height to 0.53cm which is standard or anything you like.
This will contain the text within the cell without overlapping or word wrapping.
You don't have to select the whole sheet, but you will need to manually set a height for all rows that you want to fix, and Column Width and justify for all columns that you want to fix.
GGJstudios is the easiest method to use in practice, but my way is basically telling excel to used a fixed column width and row height.
Productivity Orchard Be more productive with your Mac
Last edited by James Craner; Jan 15, 2013 at 04:26 PM.
|cell, excel, formatting, office, spreadsheet|
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|Numbers/Excel File Cell Search||Benguitar||Mac Applications and Mac App Store||0||Jan 7, 2014 09:35 AM|
|Importing text editor to Excel||wilcco||Mac Basics and Help||2||Feb 26, 2013 05:11 PM|
|Excel: How to add a table into a single cell||champ01||Mac Applications and Mac App Store||3||Jan 18, 2013 02:38 PM|
|Help With Excel Cell Viewing||canuck79||Mac Applications and Mac App Store||0||Jul 19, 2012 10:59 AM|
|Resolved: dragging text from table cell to text field||straber||iPhone/iPad Programming||4||Jul 11, 2012 02:27 PM|
All times are GMT -5. The time now is 05:08 AM.