How to make a list with Drag-and-Rearrange feature
I want to do this to be able to rearrange list easily(more user friendly)
Something like this-http://www.grocerygadgets.com/Images...rangeLists.png
How to make a list with Drag-and-Rearrange feature
I want to do this to be able to rearrange list easily(more user friendly)
Something like this-http://www.grocerygadgets.com/Images...rangeLists.png
Last edited by Excelforum*ser_mH7; 04-10-2018 at 10:51 AM.
I do not understand what you want to achieve. In any event, non-editable pictures are of little use.
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential information is removed first!!
4. Try to avoid using merged cells. They cause lots of problems!
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
thanks
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Is this connected with your thread on groupings?
Do I understand correctly that you want to be able to group items in Excel and then to be able to select those groupings and move them around? If so, have you considered using tables?
What you will not be able to do (at least not natively) is to drag tables around and them move out of each others' way as you do so, so without coding (and I don't even know if it's possible then), you will not achieve the interactive quality of your app's menu.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
No you all didnt got my question
I want to be able to rearrange list(Cell in column) with drag nad drop like ease ,Cut and insert is a little tedious,not user-frindly,
Please attach workbook with examples of what you are trying to achieve
- we do not know what you are trying to do
Last edited by kev_; 04-10-2018 at 10:59 AM.
Drag and drop what, exactly?
Example I got a list of grocery , I want to be able to drag and rearrange the list
Please attach a sample worksheet showing BEFORE and AFTER. Telling us that we don't understand and then not EXPLAINING clearly doesn't take us much further forward....
You can drag to rearrange items in Excel: select the cell containing the data (without actually entering the cell) and then drag the box around it to move the cell and its contents.
However, nothing else will move automatically when you do so.
Other cells will not get pushed down using that and
my list has multi-row as item to be dragged
Yes, I know that - that is what I said. In other words, you CAN drag single or multiple cells in Excel, but you CAN'T have Excel respond in the way your app responds.
You still have not provided a workbook, however.
How do I give suggestion about this to Open office,Microsoft,Apache,Libre, or .xlsx(format owner),or who and who?
You need to go to their websites, find their suggestions mechanism (it's User Voice on the MS site) and make your suggestions there.
Google should help you find them.
What are you asking?
It's just as well you are here @AliGW
Just got in from work, Kev!
You seem to be the only one who understands the questions on this thread
Well, I wouldn't go that far ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks