Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ordering cells with texts boxes in Excel
Excel can show in a text box the content of a cell, just clicking in the text
box and puting in it a formula with the relative reference to the cell: I insert text box on the cell A1 and refer to the contents of cell B2 insering in the text box the formula =B2. I continue with the same procedure in successives rows of a list. I set the propriety in the format of text boxes to moving but not dimentioning. But when I order the list by column 2 the contents of text boxes are rong because Excel consider the reference to cells as absolute! No error appears, but on each row the text box does not match with the right cell. Can anybody help me to solve this strange behaviour of Excel? Jean Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract texts & numbers from one cell into four cells | Excel Discussion (Misc queries) | |||
Ordering Columns in Pivot Tables - Excel 2000 | Excel Worksheet Functions | |||
SUMIF or SUMPRODUCT to total cells containing multiple texts | Excel Worksheet Functions | |||
HELP! NEED TEMPLATE FOR ORDERING UNIFORMS FOR STAFF IN EXCEL | Excel Discussion (Misc queries) | |||
Using Texts in Cells | Excel Discussion (Misc queries) |