Hello!
I have a very large spreadsheet with formulas in numerous columns. I also have to add rows and would like for the formulas to be appropriately applied to the appropriate columns of the added rows. Is there an easy way to do this - especially since the columns of these added rows will be hidden to viewers?
Thanks!
If you convert your sheet to a list via Data|List|Create List
Then the range will be surrounded by a blue boundary.
When you click on the next available row, it will show an asterisk (*) type in that cell and any formula in the previous rows will automatically copy down....
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks