ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hiding Column/Row Titles (https://www.excelbanter.com/excel-discussion-misc-queries/68413-hiding-column-row-titles.html)

gti_jobert

Hiding Column/Row Titles
 

Hello All,

How do you hide the column letters and row numbers without hiding any
data? I've done it before but cant remember for the life of me how to
do it again.

Thanks All.


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=506694


EdMac

Hiding Column/Row Titles
 

Hi,

Go to TOOLs OPTIONS and uncheck the box for row and column headings.

Hope this helps

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=506694


gti_jobert

Hiding Column/Row Titles
 

Thanks Ed, was just what I needed!


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=506694


Rob

Hiding Column/Row Titles
 
Go to ToolsOptionsView and deselect Row & Column headers.

Rob

"gti_jobert" wrote
in message ...

Hello All,

How do you hide the column letters and row numbers without hiding any
data? I've done it before but cant remember for the life of me how to
do it again.

Thanks All.


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=506694





All times are GMT +1. The time now is 02:21 AM.

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