Forum Discussion
Missing Insert Options Button.
With your permission, which excel version do you have? ..Operating system would possibly also be good to know, depending on the topic / problem.
What do you mean by adding a line? VBA or formula?
As far as the translation is concerned, I did not understand what your plan is.
With your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- JuanPZOct 31, 2020Copper Contributor
NikolinoDE I have Version 2009 (Build 13231.20390 Click-to-Run). After I right-click on a line number, I press Insert, a new line appears, but no Insert Options Button shows so I can change Format Same As Above to Format Same As Below. My plan is to Right-click line 19 and insert a new line and then press Format Same As Below.
- NikolinoDEOct 31, 2020Gold Contributor
- JuanPZOct 31, 2020Copper Contributor
NikolinoDE No, I'm able to put a new line in 19 but the little brush logo that appears after inserting a new line doesn't appear for me. I'm trying to change the option "Format Same As Above' to "Format Same As Below'.