Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 15, 2013, 11:06 AM   #1
jent
macrumors 6502a
 
Join Date: Mar 2010
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?
jent is offline   0 Reply With Quote
Old Jan 15, 2013, 11:10 AM   #2
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Format > Cells > Alignment > Wrap text
GGJstudios is offline   0 Reply With Quote
Old Jan 15, 2013, 11:22 AM   #3
jent
Thread Starter
macrumors 6502a
 
Join Date: Mar 2010
Quote:
Originally Posted by GGJstudios View Post
Format > Cells > Alignment > Wrap text
What about if I don't want to push the cell downwards either? I want it to remain the same height and width regardless of whatever text I input and however long that text is.
jent is offline   0 Reply With Quote
Old Jan 15, 2013, 11:25 AM   #4
GGJstudios
macrumors Westmere
 
Join Date: May 2008
Quote:
Originally Posted by jent View Post
What about if I don't want to push the cell downwards either? I want it to remain the same height and width regardless of whatever text I input and however long that text is.
The text has to go somewhere. If you don't want it visible in the next cell, put something in that cell, even a non-visible character.
GGJstudios is offline   0 Reply With Quote
Old Jan 15, 2013, 03:18 PM   #5
James Craner
macrumors 68000
 
James Craner's Avatar
 
Join Date: Sep 2002
Location: Bristol, UK
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 03:26 PM.
James Craner is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Tags
cell, excel, formatting, office, spreadsheet

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Numbers/Excel File Cell Search Benguitar Mac Applications and Mac App Store 0 Jan 7, 2014 08:35 AM
Importing text editor to Excel wilcco Mac Basics and Help 2 Feb 26, 2013 04:11 PM
Excel: How to add a table into a single cell champ01 Mac Applications and Mac App Store 3 Jan 18, 2013 01:38 PM
Help With Excel Cell Viewing canuck79 Mac Applications and Mac App Store 0 Jul 19, 2012 09:59 AM
Resolved: dragging text from table cell to text field straber iPhone/iPad Programming 4 Jul 11, 2012 01:27 PM

Forum Jump

All times are GMT -5. The time now is 06:02 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC