So I have a named range C2 - F45 and have set it as a print range and I want to edit it to B1- C45 but using Formula- Print range - Edit does nothing so how do I edit an existing named range?
Ron
Under Format → Print Ranges → Edit… you can edit the currently used print range. If you there select an existing named range and edit the range reference it does not change the name range’s reference but sets the current print area reference. To change the named range’s reference permanently hit Ctrl+F3 or go to Sheet → Named Ranges and Expressions → Manage… and select the range and edit the reference.
Thank you, finding the Calc function which is equivalent to Excel , is possibly the most time consuming.
Modifying an Excel file to LO does not print without some modifications to margins, etc. The data OK but formatting is slightly off but we will get there ( I had that re-think many years ago when the firm I worked for changed from Lotus 1-2-3 , etc all over to Microsoft so I had to learn Excel).
Ron
@Sol1 Please use add a comment when responding to an answer. Answers should be only used as a response to the original question.
Also, when you have been helped, please help others to know the question has been answered by clicking on the 
in upper left area of answer which satisfied the question.
Thank you for that process.