Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel xp training - wrap text

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Wrap Text

excel xp training - Wrap Text

ResolvedVersion Standard

Vivienne has attended:
Excel Intermediate course

Wrap Text

What function does wrap text does?

RE: Wrap Text

This function lets the words drop down to the next line when they reach the end of the cell. Similar to Word, when you just keep typing the words transfer to the next line down. Wrapping the text stops the words going outside of the cell itself.

Hope that helps

Tracy

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.