Ask Your Question
0

Edit a named range

asked 2018-10-05 16:10:13 +0200

Sol gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
2

answered 2018-10-05 21:05:25 +0200

erAck gravatar image

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.

edit flag offensive delete link more
0

answered 2018-10-06 01:01:14 +0200

Sol gravatar image

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

edit flag offensive delete link more

Comments

@Sol 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.

Ratslinger gravatar imageRatslinger ( 2018-10-06 01:24:30 +0200 )edit

Thank you for that process.

Sol gravatar imageSol ( 2018-10-06 01:29:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-05 16:10:13 +0200

Seen: 158 times

Last updated: Oct 06 '18