Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default Row and column headings missing

I now this is so simple, but I'm drawing a blank.
I'm working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?

Thanks,

Steve
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default Row and column headings missing

One way:

Tools/Options/View check the "Row & column headers" checkbox.

In article ,
Steve wrote:

I now this is so simple, but I'm drawing a blank.
I'm working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?

Thanks,

Steve

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default Row and column headings missing

Thanks both.
I said it was simple, but I'm even more embarassed now because it's even
simplier than I imagined.

Thanks again,

Steve

"JE McGimpsey" wrote:

One way:

Tools/Options/View check the "Row & column headers" checkbox.

In article ,
Steve wrote:

I now this is so simple, but I'm drawing a blank.
I'm working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?

Thanks,

Steve


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,089
Default Row and column headings missing

Steve

Tools | Options | Tick "Row and column headers"

Regards

Trevor


"Steve" wrote in message
...
I now this is so simple, but I'm drawing a blank.
I'm working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?

Thanks,

Steve



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default Row and column headings missing

They are under toolsoptionsviewwindow options, you can still change the
size by going into formatcolumn/row


--
Regards,

Peo Sjoblom



"Steve" wrote in message
...
I now this is so simple, but I'm drawing a blank.
I'm working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?

Thanks,

Steve





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default Row and column headings missing

In Excel 2003 or earlier:
From the TOOLS Menu, select "Options"
On the VIEW Tab, check "Row & Column Headers"

In Excel 2007:
Go to the VIEW Tab on the Ribbon
In the "Show/Hide" Section, check "Headings"

HTH,
Elkar



"Steve" wrote:

I now this is so simple, but I'm drawing a blank.
I'm working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?

Thanks,

Steve

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,311
Default Row and column headings missing

Tools-Options-View
Check 'Row & column headers'

HTH,
Paul

--

"Steve" wrote in message
...
I now this is so simple, but I'm drawing a blank.
I'm working with a worksheet that does not have the row & column headings.
How do I produce them so I can change the column width ?

Thanks,

Steve



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using an Index by Column Headings instead of Column Numbers Sean Bishop New Users to Excel 2 November 21st 06 09:38 PM
Column Headings Allison Excel Discussion (Misc queries) 2 April 6th 06 07:52 PM
How do I take information in 1 column to make column headings? Northside Excel Discussion (Misc queries) 1 December 16th 05 09:47 PM
How do I create column headings in Excel in the A, B, C etc column eliannaj Excel Discussion (Misc queries) 2 November 23rd 05 06:48 PM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"