Excel Training – Page 72 – STL

Text wrapping allows you to make all the contents of a cell visible without adjusting the cell’s size.

When you enter data, if that data is longer than the width of the cell, it appears in one of two ways:

(1) If the cell to the right contains data, you will see only as much as the size of its cell allows. ( fig.1, column B)

(2) If the cell to the right is blank, the data will spill across into that cell. (fig.1, column C)

Text wrapping gives you a third option, where none of the data is obscured, nor does it spill across to the next cell. (fig.1, column E)

You will find the Wrap Text (fig.2) command in the Home ribbon and the Alignment group.To apply it, highlight the relevant cell(s) and click on the Wrap Text button.

It’s that simple. Why not give it a try.

fig.2

I’ve recently upgraded from Excel 2003 to 2010 – and I’m scared. What if it’s too tricky, what if I break it…. and then I thought I could do save time by teaching myself…

Image of Excel 2003 — My familiar looking Excel 2003 screen

So I’ve made my list to overcome this fear…and I’m sharing it because I suspect that I’m not alone…

I use Excel everyday, but I don’t really get the most out of if. There is bound to be an easier way to get results and enter data.
If I don’t make time to learn it, I’m going to miss out on all the time saving features, and tools for analysing data more easily.
I know I have an Excel Skills gap but I’ve been too busy to tackle it.
I need to work out what Excel can do, and what I’d like to be able to do based on my work, so I can do some targeted Excel training.
I actually like learning! I just have a fear of computers doing things I don’t understand.

Screen-shot-Excel- 2010 — This is how my new shiny Excel 2010 looks…it’s asking me to learn more…

So my conclusion is that:

I’d like to think that I can learn all this from books or online, but in reality, what works for me, is learning from a real, live person. So I can ask questions, work through examples, and learn from mistakes.
To build my skills I need to do it quickly with our Excel intermediate course and our upgrade to MS Office 2010 (so I’m working across the whole office suite) to the best out of all the programs and can link work between them.
I need to be able to practise in a “safe environment” so I’m not worrying about ruining live data or a colleague spotting me struggling.
I need a trainer who has all the knowledge of the program, and who can break it down into usable chunks in plain language.

To overcome my fear, I had to face the uncomfortable feeling of “I don’t know how to do that”, and now, I can focus on “What can the program do and how can I make it do what I want” and most of all “When can I start”. Excel 2010 training booked…first step taken.

Blog Categories