Hi,
I cant seem to copy the formulas in my spreadsheet by dragging the bottom right of cell square icon, after several attempts, do I need to clear something? Also I have tried to copy and paste just the formulas but I am coming up with either zero in cells or #ref’s in every cell im trying to copy…what is the correct way to copy formulas to other cells??? Also is there a way to upload my file so someone can help me please
thanks
A
Hi, I have attached the spread sheet to see if anyone can help me to get the formulas copied across my spead sheet, I have completed the first few grid, but I cant copy without getting #ref signs, please see attached file and if you could quickly finish it for me I would be eternally greatful…thanks in advancenumber of sales to revenue figures.ods
thanks so much for your invaluable help, I got it working,
but realised its not very printable going landscape, so I tried to make a printable version in portrait, I have included both on the spreadsheet but cant seem to get the portrait version working (down the page not across… please see attached file… thanks again waclnumber of sales to revenue figures.ods
edited 20210220
thanks so much but realised its not very printable going landscape, so I tried to make a printable version in portrait, I have included both on the spreadsheet but cant seem to get the portrait version working… please see attached file… thanks again I tried to get that working, but to no avail, i would prefer to have it in portrait view for future workings, what would be the formula to get it working down the page (ie portrait view) thanks again Ads