Skip to content
Skip to content
Menu
Alchemex
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Alchemex

How to prevent objects from distorting in Excel

By admin on March 17, 2017April 19, 2019

When an object has been placed in the same row as your data and you delete some of your rows, you may find that your object will either be compressed or deleted completely.  This can easily be avoided by changing a setting in your object properties, thus preventing your object from distorting in Excel.
In the below example, if you delete rows 2 to 6 the object will be compressed vertically.  If you delete rows 2 to 13, the object will be completely deleted.
Applies To: Microsoft® Excel® 2010, 2013 and 2016.

To avoid this from happening to your report, right-click on the object and select “Size and Properties”.

Ensure that “Move but don’t size with cells” has been selected under the Properties section.

If you have more than one object on a worksheet, you can select all the objects using F5 > Special > Objects and follow the above steps to set the properties on all of them.
 
You will be able to work more effectively with objects by applying this tip, and save time sorting out the layout of your reports.
The post How to prevent objects from distorting in Excel appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Learn how to grant or restrict access to reports in the Sage Intelligence Report Viewer
Understanding your Cash Flow

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600
©2025 Alchemex | WordPress Theme by SuperbThemes.com