Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Moving Drawing Objects.
by Allen Wyatt
(last updated June 20, 2016)
Over the course of many ExcelTips you have learned different ways to create objects using the drawing tools provided in Excel. If you later want to change the positioning of these objects, you can do so in this manner:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3239) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Moving Drawing Objects.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Don't like the way that Excel formats lines and arrows? You can easily make your own formatting changes, and then use your ...Discover More
Want to change an existing bar chart to a different type of chart, such as a line chart or a column chart? It's easy to do ...Discover More
Have you ever wanted to take a "picture" of a part of a worksheet and put it in another section? This tip explains how to use ...Discover More
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.