Forum Discussion

mihail guber's avatar
mihail guber
Copper Contributor
Nov 28, 2017

excel changing basic adjustments

Each time I draw a line in a excel file I have to change its colour and thickness. İts the same thing with the text box font type etc. Help please 

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    There is no way to change the default format for that shapes, but you can automate formatting steps through Macros.

     

    To learn more about Macros, follow these links:

    https://support.office.com/en-us/article/Automate-tasks-with-the-Macro-Recorder-974ef220-f716-4e01-b015-3ea70e64937b

    http://www.excel-easy.com/vba/examples/macro-recorder.html

Resources