Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I delete rows while maintaining textbox spatial relationsh.
I have a lengthy spreadsheet with text boxes specifically spaced in an excel
document. In Excel 2003, I could delete rows and everything below the deletion would move together. In Excel 2007, the text boxes remain while the cells move. This ruins the visual format of the file. I can't find a setting to control whether objects move when cells are deleted. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I delete rows while maintaining textbox spatial relationsh.
Hi Drew,
I know it's tad delayed but perhaps this is what you need. Highlight your text box, then right click and choose "Format Tex Box". Under "Properties" tab you need to select one of the following options: -move and size with cells -move but don't size with cells -don't move or size with cells This applies to both excel 2003 and 2007. I hope this works for you. Regards, Piotr "Drew" wrote: I have a lengthy spreadsheet with text boxes specifically spaced in an excel document. In Excel 2003, I could delete rows and everything below the deletion would move together. In Excel 2007, the text boxes remain while the cells move. This ruins the visual format of the file. I can't find a setting to control whether objects move when cells are deleted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete hyphens within a cell while maintaining the data therein | Excel Discussion (Misc queries) | |||
Inserting Rows and Maintaining Correct Balances | Excel Discussion (Misc queries) | |||
Imported into Vista, how to delete 2000 Excel textbox? | Excel Discussion (Misc queries) | |||
Maintaining in-doc hyperlinks when rows/cells change | Excel Discussion (Misc queries) | |||
Pivot Table - Deleting data rows while maintaining them in the tot | Excel Worksheet Functions |