Editing excel is fast and straightforward using DocHub. Skip downloading software to your computer and make changes with our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful capabilities that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and send documents for completion to other people. All of this, combined with a competing cost, makes DocHub the perfect choice to copy motif in excel files effortlessly.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the safety of your data, as we securely store them in the DocHub cloud.
foreign welcome to HB and infotech tutorials in this tutorial I am going to resolve the mystery of paste special in paste special there is an option called all using Source theme most of you donamp;#39;t really know about this option now let us see how it works for the demonstration I am taking two workbooks book 1 and book 2. in book 1 there is some data shapes and a chart with Source theme formatting now let us see what happens if we copy and paste them into Book 2 using Ctrl C and Ctrl V foreign you can notice that all contents have been pasted except the formatting now this is where you use the option all using Source theme let us try it out foreign all using Source theme is text contents including the formatting but unfortunately this option doesnamp;#39;t work with shapes charts and other Graphics now let us move forward and understand what are the themes and how to use them a theme is a combination of many formatting options put together a theme defines the appearance