Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - Borders

microsoft-excel-training - Borders

ResolvedVersion Standard

Thu 11 Oct 2007, 17:46 Delegate Josh said...

Josh has attended:
Excel Intermediate course

Borders

How do you take away the borders from a few columns with deleting them to show a heading that may go across column a-e?

Tue 16 Oct 2007, 13:34 Trainer Sandy said...

RE: Borders

Hi Josh

I hope I am correct in thinking that you wish to have a heading in your worksheet to be centred across columns a-e.
If you had your heading in cell A1 click on this cell and select the cells up to E1

Then click on the Merge and Centre icon on your formatting toolbar. You can also go into Format Menu, Cells, Alignment and select Merge Cells under the Text Control section.

Hope this helps
Sandy

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

microsoft-excel-training - Borders

Borders

RE: Borders

Excel articles

Excel tip:

Manually rotating a 3D chart