Can any body suggest me the best method to shift the objects suppose I have made 30-40 charts , and Finally I think I need to shift all of them downwards in a sheet . How to do so with minimum manual work.
I ususally try Shift + select and move which only works for very few objects ie 3-4
You can Ctrl + left click on each chart. You can left click and hold and drag to highlight all the charts. Or if you want EVERY chart on the tab, you can Edit -> Activate All. Then move them as normal, left click and hold and drag, or Ctrl and the arrow keys, or Shift + Ctrl and the arrow keys.
