×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to change Grid Heading

How to change Grid Heading

How to change Grid Heading

(OP)
Hi,

I want to change the Grid heading with table records, how can I do so?

Grid Columns : cat1,cat2,cat3,cat4,cat5,....
Tables Records: Mother & Baby,Hygiene,Paper,Wet Wipes,Personal Care

Thanks

Saif

RE: How to change Grid Heading

Hi,

1) Select the cell containing a table heading.

2) Key in the value you want.

3) TAB to the next table heading.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: How to change Grid Heading

Is this the same question you asked last year, in thread184-1811119: How to insert Heading into Excel Sheet? If so, we went round in a few circles trying to understand what you were trying to achieve - without much success.

It would help to know where you want to get the heading data from. You mentioned a table. Do you mean a table in a database? Of a Word table? Also, what is the "grid"? Is this in Excel? Or Access? Or what?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: How to change Grid Heading

(OP)
No Mike, this is not the same question.

See this image..

I want to change the grid headings of cat1,cat2,cat3 ... to Wet Wipes, Mother & Baby, Hygiene ...



Thanks

Saif

RE: How to change Grid Heading

In that case, Skip has given you the answer. Just type the new headings over the old ones.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: How to change Grid Heading

Oh my!

You show more than 20 cat headings.

Unless this is just a report that no one will EVER try to use as a lookup table or any kind of analysis, this is an awful table structure.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: How to change Grid Heading

(OP)

Quote (Oh my!

You show more than 20 cat headings.

Unless this is just a report that no one will EVER try to use as a lookup table or any kind of analysis, this is an awful table structure.)


Yes, I emphasis not show like this, it is so simple if we show these heads in vertical. Only 5 heads required, like;

1. Party Code
2. Name
3. Location
4. Category
5. Value.

Saif

RE: How to change Grid Heading

Saif_Abc,
Why do you refuse to answer any of Mike's question?

You say you would like to get some help with your issue, but nobody here really knows what the issue is. And just repeating "grid headings" does not mean anything to anybody here. sad

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: How to change Grid Heading

Are you wanting to transform your report table into that 5-column table?

Check out this: FAQ68-5287: NORMALIZE Your Table using the PivotTable Wizard

This process requires 1 column on the left and then however many to the right. So in order to accomplish that you must CONCATENATE your Party Code, Name, Location columns with a delimiter so that after the FAQ process completes, you can use Data > Text to columns to restore those 3 columns.

I have used this technique many times to put a report like you have into a useable table structure. Of course your cat headings need to be changed before you start this process.

Note that you will end up with a lot of ZERO values.
FILTER to display ZERO values.
SELECT the rows.
DELETE.
CLEAR the filter.

Vola y'all!

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

RE: How to change Grid Heading

(OP)

Quote:

Why do you refuse to answer any of Mike's question?

You say you would like to get some help with your issue, but nobody here really knows what the issue is. And just repeating "grid headings" does not mean anything to anybody here

I am sorry, my mistake and sorry not delivered the queries in correct way.

I will try to simply it, as it is not closed.

Thanks

Saif

RE: How to change Grid Heading

Do you plan to change headings in excel worksheet? The screenshot seems to be from VFP table...

combo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close