microsoft-excel-training - borders

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

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

microsoft-excel-training - Borders

resolvedResolved · Low Priority · Version 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:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips


Server loaded in 0.09 secs.