training ms excel advanced - cells

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training ms excel advanced - Cells

training ms excel advanced - Cells

resolvedResolved · Low Priority · Version Standard

Peter has attended:
Excel Introduction course

Cells

how do i merge and align cells

RE: cells

If you highlight across the cells you wish to merge you can use the Format menu, go to the alignment tab and tick the box towards the bottom of the dialog box which says merge. Once merged you can use the other options on that box to centre the text horizontally across the cells.

There is also a button on your formatting toolbar which merges and centres. It looks like a lower case 'a' with two arrows pointing away from the a. Like this
<--a--> if you find it that does the same job!

regards

Tracy


 

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips


Server loaded in 0.08 secs.