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

microsoft-excel-training - borders

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

microsoft-excel-training - Borders

ResolvedVersion Standard

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?

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.