| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.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? |
|
#2
Posted to microsoft.public.excel.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 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question on links where info is added and cell location is wrong | Links and Linking in Excel | |||
| How to move a column from one sheet to another by using functions | Excel Discussion (Misc queries) | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| How to move location of chart within a worksheet? | Excel Discussion (Misc queries) | |||
| Is there a function that will return info of the cursor location? | Excel Worksheet Functions | |||
Linear Mode
