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?

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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?

Functions that will move info to a different location in colum
 

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).

"Gord Dibben" wrote:

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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?

Functions that will move info to a different location in colum
 

You want the data temporarily moved up so EditDeleteShift 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

On Mon, 10 Dec 2007 08:46:00 -0800, Bill R
wrote:

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).

"Gord Dibben" wrote:

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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?

Functions that will move info to a different location in colum
 

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

"Gord Dibben" wrote:

You want the data temporarily moved up so EditDeleteShift 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

On Mon, 10 Dec 2007 08:46:00 -0800, Bill R
wrote:

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).

"Gord Dibben" wrote:

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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?

Functions that will move info to a different location in colum
 

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

On Dec 10, 7:05 pm, Bill R wrote:
I qualify the person before presenting the menu, so I choose the products
that I want to present beforehand.



"Gord Dibben" wrote:
You want the data temporarily moved up so EditDeleteShift 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

On Mon, 10 Dec 2007 08:46:00 -0800, Bill R
wrote:

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).

"Gord Dibben" wrote:

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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 -

Functions that will move info to a different location in colum
 

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

On Mon, 10 Dec 2007 11:05:02 -0800, Bill R
wrote:

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

"Gord Dibben" wrote:

You want the data temporarily moved up so EditDeleteShift 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

On Mon, 10 Dec 2007 08:46:00 -0800, Bill R
wrote:

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).

"Gord Dibben" wrote:

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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?

Functions that will move info to a different location in colum
 

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

"Gord Dibben" wrote:

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

On Mon, 10 Dec 2007 11:05:02 -0800, Bill R
wrote:

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

"Gord Dibben" wrote:

You want the data temporarily moved up so EditDeleteShift 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

On Mon, 10 Dec 2007 08:46:00 -0800, Bill R
wrote:

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).

"Gord Dibben" wrote:

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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?

Functions that will move info to a different location in colum
 

I'll drop out now.

My pliers are getting worn down.


Gord

On Mon, 10 Dec 2007 14:15:03 -0800, Bill R
wrote:

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

"Gord Dibben" wrote:

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

On Mon, 10 Dec 2007 11:05:02 -0800, Bill R
wrote:

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

"Gord Dibben" wrote:

You want the data temporarily moved up so EditDeleteShift 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

On Mon, 10 Dec 2007 08:46:00 -0800, Bill R
wrote:

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).

"Gord Dibben" wrote:

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

On Sun, 9 Dec 2007 14:12:00 -0800, Bill R
wrote:

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?