ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to hide cell reference borders (top/left side) in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/102949-how-hide-cell-reference-borders-top-left-side-excel.html)

jwe06

How to hide cell reference borders (top/left side) in Excel?
 
Using Excel 2003. I have seen an Excel file that looked more like a form &
does not have the alpha reference border on the top or the number reference
border on the left side. I would like to make a similar form, but can not
find the option to hide them.

Miguel Zapico

How to hide cell reference borders (top/left side) in Excel?
 
That option is on Tools-Options, on the View Tab. There are some checkboxes
at the bottom, on the Window option section, that control what you want to
show/hide.

Hope this helps,
Miguel

"jwe06" wrote:

Using Excel 2003. I have seen an Excel file that looked more like a form &
does not have the alpha reference border on the top or the number reference
border on the left side. I would like to make a similar form, but can not
find the option to hide them.



All times are GMT +1. The time now is 10:05 PM.

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