The cells in a spreadsheet are quite small, so typing in a lot of information can lead to it overlapping and covering up other cells. One method for confining lots of information to just one cell block is text wrapping.
Try this out by typing a lot of text in to a cell so that is overlaps the edge. Next, select the cell by clicking on it, and then click on the Wrap text button in the ribbon above. After you have done this the text should be confined to the vertical cell borders, as seen below:
Similar resources you may like
Tags
Excel, Excel 2007 Tutorial, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, spreadsheet, text wrapping, Tips, top Tips, Training
Share This Resource
Leave a Reply
+44 (0)1273 622272
Follow Silicon Beach Training
Categories
Upcoming courses
- 6 - 10 Sep 2010
2272 - Implementing and Supporting Microsoft Windows XP Professional - 6 - 8 Sep 2010
Lean Processes and Tools - 6 - 10 Sep 2010
Software Test Management - 6 - 8 Sep 2010
PRINCE2 Foundation - 6 Sep 2010
Project Management - 6 - 8 Sep 2010
Project Management & MS Project - 6 - 8 Sep 2010
Systems Development Essentials with Agile - 6 - 10 Sep 2010
PRINCE2 Practitioner - 6 - 8 Sep 2010
Systems Modelling Techniques with UML - 7 - 8 Sep 2010
MS Project - 9 - 10 Sep 2010
PRINCE2 Practitioner Conversion - 9 - 10 Sep 2010
2794 - Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 - 9 - 10 Sep 2010
Lean Six Sigma Yellow Belt - 9 - 10 Sep 2010
HTML - 9 - 10 Sep 2010
Modelling Business Processes
|
|
|