Functions that will move info to a different location in column  
Author Message
web2000inc





PostPosted: Sun Dec 09 15:01:36 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column

Is there a way in Excel to temporaraly hide a column or temporarly move a
paragraph up within the column without affecting the column next to it or
above it?

Excel240  
 
 
Gord





PostPosted: Sun Dec 09 15:01:36 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column Bill

Rows and/or columns can be hidden but individual cells cannot be hidden as they
are part of the row and column.

You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)

You would also have to make sure that cell was locked and hidden and the sheet
protected so the contents would not show in the formula bar.

Or have the Formula bar disabled.

What are you trying to accomplish? There may be another way.


Gord Dibben MS Excel MVP




>Is there a way in Excel to temporaraly hide a column or temporarly move a
>paragraph up within the column without affecting the column next to it or
>above it?

 
 
BillR





PostPosted: Mon Dec 10 08:46:00 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column I have a menu with offers 4 different product packages listed in vertical
columns side by side. Sometimes the person does not qualify for one of the
products in one of the packages so I have have my menu set up to make that
product dissapear from the menu but when it does it leaves a "hole" in the
menu. I would like for all of the products below the deleted one to move up
in the column without affecting the info in the header or the next column(s).



> Bill
>
> Rows and/or columns can be hidden but individual cells cannot be hidden as they
> are part of the row and column.
>
> You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
>
> You would also have to make sure that cell was locked and hidden and the sheet
> protected so the contents would not show in the formula bar.
>
> Or have the Formula bar disabled.
>
> What are you trying to accomplish? There may be another way.
>
>
> Gord Dibben MS Excel MVP
>


>
> >Is there a way in Excel to temporaraly hide a column or temporarly move a
> >paragraph up within the column without affecting the column next to it or
> >above it?
>
>
 
 
Gord





PostPosted: Mon Dec 10 10:28:55 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column You want the data temporarily moved up so Edit>Delete>Shift Cells Up would not
work.

How is the menu created?

How does the person choose from the menu?

How would you know which person is choosing and is not qualified for certain
products?


Gord




>I have a menu with offers 4 different product packages listed in vertical
>columns side by side. Sometimes the person does not qualify for one of the
>products in one of the packages so I have have my menu set up to make that
>product dissapear from the menu but when it does it leaves a "hole" in the
>menu. I would like for all of the products below the deleted one to move up
>in the column without affecting the info in the header or the next column(s).
>

>
>> Bill
>>
>> Rows and/or columns can be hidden but individual cells cannot be hidden as they
>> are part of the row and column.
>>
>> You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
>>
>> You would also have to make sure that cell was locked and hidden and the sheet
>> protected so the contents would not show in the formula bar.
>>
>> Or have the Formula bar disabled.
>>
>> What are you trying to accomplish? There may be another way.
>>
>>
>> Gord Dibben MS Excel MVP
>>


>>
>> >Is there a way in Excel to temporaraly hide a column or temporarly move a
>> >paragraph up within the column without affecting the column next to it or
>> >above it?
>>
>>

 
 
BillR





PostPosted: Mon Dec 10 11:05:02 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column I qualify the person before presenting the menu, so I choose the products
that I want to present beforehand.



> You want the data temporarily moved up so Edit>Delete>Shift Cells Up would not
> work.
>
> How is the menu created?
>
> How does the person choose from the menu?
>
> How would you know which person is choosing and is not qualified for certain
> products?
>
>
> Gord
>


>
> >I have a menu with offers 4 different product packages listed in vertical
> >columns side by side. Sometimes the person does not qualify for one of the
> >products in one of the packages so I have have my menu set up to make that
> >product dissapear from the menu but when it does it leaves a "hole" in the
> >menu. I would like for all of the products below the deleted one to move up
> >in the column without affecting the info in the header or the next column(s).
> >

> >
> >> Bill
> >>
> >> Rows and/or columns can be hidden but individual cells cannot be hidden as they
> >> are part of the row and column.
> >>
> >> You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
> >>
> >> You would also have to make sure that cell was locked and hidden and the sheet
> >> protected so the contents would not show in the formula bar.
> >>
> >> Or have the Formula bar disabled.
> >>
> >> What are you trying to accomplish? There may be another way.
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>


> >>
> >> >Is there a way in Excel to temporaraly hide a column or temporarly move a
> >> >paragraph up within the column without affecting the column next to it or
> >> >above it?
> >>
> >>
>
>
 
 
Pete_UK





PostPosted: Mon Dec 10 11:20:30 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column Maybe you could have a simple coding structure applied to a helper
column (eg a, b, c or d). Then you could apply a custom filter to this
column - Does not equal d, for example, to hide the product associated
with "d". You could hide another one at the same time by clicking on
OR in the custom dialogue and choosing Does not equal b.

Hope this helps.

Pete


> I qualify the person before presenting the menu, so I choose the products
> that I want to present beforehand.
>
>
>

> > You want the data temporarily moved up so Edit>Delete>Shift Cells Up would not
> > work.
>
> > How is the menu created?
>
> > How does the person choose from the menu?
>
> > How would you know which person is choosing and is not qualified for certain
> > products?
>
> > Gord
>


>
> > >I have a menu with offers 4 different product packages listed in vertical
> > >columns side by side. Sometimes the person does not qualify for one of the
> > >products in one of the packages so I have have my menu set up to make that
> > >product dissapear from the menu but when it does it leaves a "hole" in the
> > >menu. I would like for all of the products below the deleted one to move up
> > >in the column without affecting the info in the header or the next column(s).
>

>
> > >> Bill
>
> > >> Rows and/or columns can be hidden but individual cells cannot be hidden as they
> > >> are part of the row and column.
>
> > >> You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
>
> > >> You would also have to make sure that cell was locked and hidden and the sheet
> > >> protected so the contents would not show in the formula bar.
>
> > >> Or have the Formula bar disabled.
>
> > >> What are you trying to accomplish? There may be another way.
>
> > >> Gord Dibben MS Excel MVP
>


>
> > >> >Is there a way in Excel to temporaraly hide a column or temporarly move a
> > >> >paragraph up within the column without affecting the column next to it or
> > >> >above it?- Hide quoted text -
>
> - Show quoted text -

 
 
Gord





PostPosted: Mon Dec 10 12:13:21 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column I still don't understand how the menu is created and where the menu is located
and accessed and by whom.

You just don't want the un-qualified user to see those products or what?

Where is the "hole and why does it bother you? Does it create a problem with
some other function?

Autofilter won't do the job because it will hide the entire row(s).

I'm trying but I just don't have enough information to come up with anything.

You could maybe use Conditional Formatting to blank out the cell contents but
that would leave a "hole" I presume.


Gord




>I qualify the person before presenting the menu, so I choose the products
>that I want to present beforehand.
>

>
>> You want the data temporarily moved up so Edit>Delete>Shift Cells Up would not
>> work.
>>
>> How is the menu created?
>>
>> How does the person choose from the menu?
>>
>> How would you know which person is choosing and is not qualified for certain
>> products?
>>
>>
>> Gord
>>


>>
>> >I have a menu with offers 4 different product packages listed in vertical
>> >columns side by side. Sometimes the person does not qualify for one of the
>> >products in one of the packages so I have have my menu set up to make that
>> >product dissapear from the menu but when it does it leaves a "hole" in the
>> >menu. I would like for all of the products below the deleted one to move up
>> >in the column without affecting the info in the header or the next column(s).
>> >

>> >
>> >> Bill
>> >>
>> >> Rows and/or columns can be hidden but individual cells cannot be hidden as they
>> >> are part of the row and column.
>> >>
>> >> You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
>> >>
>> >> You would also have to make sure that cell was locked and hidden and the sheet
>> >> protected so the contents would not show in the formula bar.
>> >>
>> >> Or have the Formula bar disabled.
>> >>
>> >> What are you trying to accomplish? There may be another way.
>> >>
>> >>
>> >> Gord Dibben MS Excel MVP
>> >>


>> >>
>> >> >Is there a way in Excel to temporaraly hide a column or temporarly move a
>> >> >paragraph up within the column without affecting the column next to it or
>> >> >above it?
>> >>
>> >>
>>
>>

 
 
BillR





PostPosted: Mon Dec 10 14:15:03 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column I don't want to offer products that the customer does not qualify for. I
think that Pete had a good idea. Thanks anyway.



> I still don't understand how the menu is created and where the menu is located
> and accessed and by whom.
>
> You just don't want the un-qualified user to see those products or what?
>
> Where is the "hole and why does it bother you? Does it create a problem with
> some other function?
>
> Autofilter won't do the job because it will hide the entire row(s).
>
> I'm trying but I just don't have enough information to come up with anything.
>
> You could maybe use Conditional Formatting to blank out the cell contents but
> that would leave a "hole" I presume.
>
>
> Gord
>


>
> >I qualify the person before presenting the menu, so I choose the products
> >that I want to present beforehand.
> >

> >
> >> You want the data temporarily moved up so Edit>Delete>Shift Cells Up would not
> >> work.
> >>
> >> How is the menu created?
> >>
> >> How does the person choose from the menu?
> >>
> >> How would you know which person is choosing and is not qualified for certain
> >> products?
> >>
> >>
> >> Gord
> >>


> >>
> >> >I have a menu with offers 4 different product packages listed in vertical
> >> >columns side by side. Sometimes the person does not qualify for one of the
> >> >products in one of the packages so I have have my menu set up to make that
> >> >product dissapear from the menu but when it does it leaves a "hole" in the
> >> >menu. I would like for all of the products below the deleted one to move up
> >> >in the column without affecting the info in the header or the next column(s).
> >> >

> >> >
> >> >> Bill
> >> >>
> >> >> Rows and/or columns can be hidden but individual cells cannot be hidden as they
> >> >> are part of the row and column.
> >> >>
> >> >> You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
> >> >>
> >> >> You would also have to make sure that cell was locked and hidden and the sheet
> >> >> protected so the contents would not show in the formula bar.
> >> >>
> >> >> Or have the Formula bar disabled.
> >> >>
> >> >> What are you trying to accomplish? There may be another way.
> >> >>
> >> >>
> >> >> Gord Dibben MS Excel MVP
> >> >>


> >> >>
> >> >> >Is there a way in Excel to temporaraly hide a column or temporarly move a
> >> >> >paragraph up within the column without affecting the column next to it or
> >> >> >above it?
> >> >>
> >> >>
> >>
> >>
>
>
 
 
Gord





PostPosted: Mon Dec 10 15:36:45 PST 2007 Top

worksheet functions >> Functions that will move info to a different location in column I'll drop out now.

My pliers are getting worn down.


Gord




>I don't want to offer products that the customer does not qualify for. I
>think that Pete had a good idea. Thanks anyway.
>

>
>> I still don't understand how the menu is created and where the menu is located
>> and accessed and by whom.
>>
>> You just don't want the un-qualified user to see those products or what?
>>
>> Where is the "hole and why does it bother you? Does it create a problem with
>> some other function?
>>
>> Autofilter won't do the job because it will hide the entire row(s).
>>
>> I'm trying but I just don't have enough information to come up with anything.
>>
>> You could maybe use Conditional Formatting to blank out the cell contents but
>> that would leave a "hole" I presume.
>>
>>
>> Gord
>>


>>
>> >I qualify the person before presenting the menu, so I choose the products
>> >that I want to present beforehand.
>> >

>> >
>> >> You want the data temporarily moved up so Edit>Delete>Shift Cells Up would not
>> >> work.
>> >>
>> >> How is the menu created?
>> >>
>> >> How does the person choose from the menu?
>> >>
>> >> How would you know which person is choosing and is not qualified for certain
>> >> products?
>> >>
>> >>
>> >> Gord
>> >>


>> >>
>> >> >I have a menu with offers 4 different product packages listed in vertical
>> >> >columns side by side. Sometimes the person does not qualify for one of the
>> >> >products in one of the packages so I have have my menu set up to make that
>> >> >product dissapear from the menu but when it does it leaves a "hole" in the
>> >> >menu. I would like for all of the products below the deleted one to move up
>> >> >in the column without affecting the info in the header or the next column(s).
>> >> >

>> >> >
>> >> >> Bill
>> >> >>
>> >> >> Rows and/or columns can be hidden but individual cells cannot be hidden as they
>> >> >> are part of the row and column.
>> >> >>
>> >> >> You can hide the contents of a cell by Custom Formatting to ;;; (3 semi-colons)
>> >> >>
>> >> >> You would also have to make sure that cell was locked and hidden and the sheet
>> >> >> protected so the contents would not show in the formula bar.
>> >> >>
>> >> >> Or have the Formula bar disabled.
>> >> >>
>> >> >> What are you trying to accomplish? There may be another way.
>> >> >>
>> >> >>
>> >> >> Gord Dibben MS Excel MVP
>> >> >>


>> >> >>
>> >> >> >Is there a way in Excel to temporaraly hide a column or temporarly move a
>> >> >> >paragraph up within the column without affecting the column next to it or
>> >> >> >above it?
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>