ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Borders and excel (https://www.excelbanter.com/excel-discussion-misc-queries/110428-borders-excel.html)

Annie

Borders and excel
 
I want to put a border around a column, but each time I do I get
borders round each individual cell. I can do this on a fresh
spreadsheet, but the spreadsheet I am working on has data that has been
imported from a database - it's nearly driving me mad!!

Any help will be appreciated.

Annie


Office Helper

Borders and excel
 
Select the column, then go to Format | Cells. Click the Border tab. Make
sure the only lines that show in the box are the outside ones. Click OK.
I'm guessing the middle one is probably selected.


"Annie" wrote:

I want to put a border around a column, but each time I do I get
borders round each individual cell. I can do this on a fresh
spreadsheet, but the spreadsheet I am working on has data that has been
imported from a database - it's nearly driving me mad!!

Any help will be appreciated.

Annie




All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com