Functions that will move info to a different location in column

  • Thread starter Thread starter Bill R
  • Start date Start date
B

Bill R

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?
 
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
 
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).
 
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 qualify the person before presenting the menu, so I choose the products
that I want to present beforehand.
 
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 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 don't want to offer products that the customer does not qualify for. I
think that Pete had a good idea. Thanks anyway.
 
Back
Top