![]() Tip: If you hold down the Alt key while dragging an object, it will snap to the grid of the Excel spreadsheet, so you can easily align an object's top left corner to the top left corner of a particular cell. So, the only thing you need to do is to position the object where you want it to appear. With regards to the Equation object, it looks as if the defaults for this are already set to "Move but don't size with cells". If rows or columns are resized/inserted/deleted, the object will retain its size. In the latter example, the upper left corner of the object will always be positioned at exactly that cell. Then, changing row height or column width will not affect the object size at all. In many cases, the setting to "Move but don't size with cell" will be the best choice, but it must be set before any row or column changes are applied. In general, this means that the object's dimensions will be stretched out of proportion when the underlying row height or column width is changed. If you insert an object (in the screenshot it's a shape), the default settings are to "Move and resize with cells You can do that by formatting the object and selecting the "Properties" tab or link (depending on your Excel version). ![]() The best you can do is to format the object to move and size as you intend when the underlying cells are manipulated. ![]() You cannot put any object, be it image, shape, chart, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |