I am working on a spreadsheet for use in Google docs, and I want to be able to add new items to cells in the middle of a column -- but without adding rows, because that will mess up formatting of other items on the spreadsheet.
I have made an Excel spreadsheet with a macro that does what I want, and that may be the best way to explain what I need. Here is a link to the Excel spreadsheet (it does have one Macro called macro1 in it -- but it is harmless): http://linetype.fileburst.com/accounting.xls As you can see, there are three separate categories of expenses. If you click on the orange rectangle under "gas" then the cells in this category are all shifted down, so a new entry can be added at the top. But the other categories are not shifted down. Is there any way to do this in Google Docs, probably with a gadget? The only way I can think of to accomplish it is to cut out all the cells and paste them in lower down. Perhaps that could be automated? Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "iGoogle Developer Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Gadgets-API?hl=en -~----------~----~----~----~------~----~------~--~---
