Insert an object shortcut

[aash]

Hello everyone,

I wanted to ask if it's possible that I can drag and object to a group of combined cells in excel. I understand that you can go to insert and insert and object but what I'm trying to do here is drag a file such as word and drop it in the particular box that I assigned by group of merged cells. meaning instead of going to insert menu and then go through the options then locate the file I need to just drag and drop the file in that box. Is that possible!! and to be more clear Can I do anything that will make those group of merged cells accept dragging and dropping?

P.S. Even if I have to use Macro to do that it's fine but please walk me through it. Also when entering an object is it possible to save the settings for any future objects I enter? for example the edges of the object by default they are black I assign them to white so they don't show, can I save that option so when I enter an another object it comes with white edges?

Please let me know. Thanks

 

[bobhc]

You are working with merged cells so not much will work


Avoid merging cells


Merged cells can help you arrange values in a meaningful way, but they come with problems -- numerous problems, big problems.


For instance, Excel won't apply column formats to a merged cell unless you select all the columns that comprise the merge.


In addition, not all cell formats, stick once you emerge a cell.


You can't sort a column with merged cells.


You can't even select a single-column range if there's a merged cell in it -- go ahead, try!, the whole column will become merged, not good.


You cannot put a filter on it. The problem is the filter is completely useless because the filter will groan with the "merged cells need to be identically sized." Warning, which in English means you have to make each group of merged cells the same size as the largest group. And you have to find them all!


Merging cells in columns and rows could lead to data loss, bad thing.


Formulas and Functions that refer to merged cells will not work, bad thing.


Don't hesitate to use merged cells if you really need them (you don’t), but they will limit what you can do to the cells and even the columns involved.


Center Across Selection is a far better alternative to merging.


To apply this format, select the cells you want to appear merged and then launch the Alignment group dialog, Ctrl + 1, and click the Alignment tab. Center Across Selection is in the Horizontal drop-down.


You will get the desired look you want but without the merged cell's problems.

 

[aash]

Even if

You are working with merged cells so not much will work


Avoid merging cells


Merged cells can help you arrange values in a meaningful way, but they come with problems -- numerous problems, big problems.


For instance, Excel won't apply column formats to a merged cell unless you select all the columns that comprise the merge.


In addition, not all cell formats, stick once you emerge a cell.


You can't sort a column with merged cells.


You can't even select a single-column range if there's a merged cell in it -- go ahead, try!, the whole column will become merged, not good.


You cannot put a filter on it. The problem is the filter is completely useless because the filter will groan with the "merged cells need to be identically sized." Warning, which in English means you have to make each group of merged cells the same size as the largest group. And you have to find them all!


Merging cells in columns and rows could lead to data loss, bad thing.


Formulas and Functions that refer to merged cells will not work, bad thing.


Don't hesitate to use merged cells if you really need them (you don’t), but they will limit what you can do to the cells and even the columns involved.


Center Across Selection is a far better alternative to merging.


To apply this format, select the cells you want to appear merged and then launch the Alignment group dialog, Ctrl + 1, and click the Alignment tab. Center Across Selection is in the Horizontal drop-down.


You will get the desired look you want but without the merged cell's problems.

Thanks for the info. So If I don't merge any cells Can I insert an object and save some default settings for any inserted object in the future. For example if I want to insert an object which is a word document can I get rid of the border for that document. I can do that by selecting the color to white but can I save that for all future documents or objects that I will be inserting? please let me know if it's possible or not. Even if I have to use macro it's fine I just need to get that done if possible.

Thanks again for the previous information.