98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - Borders
microsoft-excel-training - Borders
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create and delete bordersTo put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range. |