Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default EXCEL-2000 column headings hide from data

Don't pick a column.

Pick a range.


Gord Dibben MS Excel MVP

On Wed, 24 Feb 2010 10:24:01 -0800, CRHIV
wrote:

I don't see a way not to include the row of labels that are on the top of the
column. When you set up D-V, it asks for a list, then you pick a column to
look in.

"????? (????) ?????" wrote:

Assuming the Data validation drop=down relays on a list [range of cells] DO
NOT include that cell while defining the data validation.
Micky


"CRHIV" wrote:

How do you make the column headings where they don't show in data validation
drop down box?


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
Excell 2000--My column headings have changed from letters to numb Jay F Excel Discussion (Misc queries) 5 October 21st 08 07:44 PM
MS Excel: hide a selection of data (not an entire row or column)? Panda Q Excel Discussion (Misc queries) 4 August 13th 08 10:11 PM
How do you hide column and row headings in Excel? B143 Excel Worksheet Functions 2 February 9th 06 08:15 PM
How do I link data in Excel 2000 from a column to a row? rbenedict Excel Discussion (Misc queries) 1 December 8th 05 04:30 PM
How to hide the column headings displayed by Excel at the left of. pc300 Excel Discussion (Misc queries) 1 January 28th 05 07:11 PM


All times are GMT +1. The time now is 09:11 AM.

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"