ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Border (https://www.excelbanter.com/excel-worksheet-functions/25284-border.html)

Derrick Robinson

Border
 
I have a spreadsheet about 24 rows and 12 columns. Is it possible to put a
border around the spreadsheet area? How is it done?
Thanks
Derrick




Gord Dibben

Derrick

Select your range.

FormatCellsBorderOutline and pick a nice thick border.

With range still selected, FormatCellsPatterns. Click on the "white" button
if you don't want the gridlines to show.

Alternative, when in Page SetupSheet uncheck "gridlines".


Gord Dibben Excel MVP



On Sun, 08 May 2005 17:54:22 GMT, "Derrick Robinson"
wrote:

I have a spreadsheet about 24 rows and 12 columns. Is it possible to put a
border around the spreadsheet area? How is it done?
Thanks
Derrick




Derrick Robinson

Thank you
DR

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Derrick

Select your range.

FormatCellsBorderOutline and pick a nice thick border.

With range still selected, FormatCellsPatterns. Click on the "white"
button
if you don't want the gridlines to show.

Alternative, when in Page SetupSheet uncheck "gridlines".


Gord Dibben Excel MVP



On Sun, 08 May 2005 17:54:22 GMT, "Derrick Robinson"

wrote:

I have a spreadsheet about 24 rows and 12 columns. Is it possible to put a
border around the spreadsheet area? How is it done?
Thanks
Derrick







All times are GMT +1. The time now is 05:58 AM.

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