Changing font colors using Paste Special:
Paste Special in Excel
If you are copying some data from any other database or worksheet you have a variety of options to paste that data in the target database.
You can select to paste just the formula, value, formats, etc. only.
You can specifically select what to paste and what not to paste.
Let us take an example:
- Select the cell or database you want to copy and press CTRL+C
- Move to the desired location (it can be any other worksheet or somewhere in the same worksheet) and right click.
- Now click on Paste Special, a dialog box will appear
In this box you can select the desired option which you want to paste.
For example, you can just copy the formula or just the values from the copied cell.
Or you can just copy the validation criteria (if any).
Also, there are other options to select from like pasting only the comments and skipping blanks or transposing the database.
- After selecting your option click on OK and the results will appear and desired value will be pasted in the selected cell or database.
In our example we have just pasted the formula.
See the formula has relatively been changed due to non-availability of values in I1 to I3 cells.
Notice the background color is not copied.
Changing the font colors when using Paste Special
In the earlier example we discussed pasting the formula using Paste Special.
Now we will talk about how you can copy the format of the text to the target cell.
For e.g.
Let us try to copy the whole format of the cell in A column to that of the F column.
Follow the steps below to copy the font color and other formatting to the target cell.
- Select the cell to be copied with formatting option and press CTRL+C
- Right click on the target cell, where you want to copy the formatting.
Then click on paste special
- A dialog box will appear
Select the Radio button with Label: Format and click on OK
- Now you can see the formatting i.e. the font-color as well as the background color has been changed in the target cell to match-up with the other cell.
In this way you can use paste special to format other cells and copy formatting information (cell color, font-color, font-size, font-style, etc.)
At TechnoExcel :
You can upskill yourself with:
Why us?
Techno Excel is a leading provider of Excel courses and data analytics courses. We not only teach you how to use excel but also help customize it for your exact needs! Make the most out of your career with Techno Excel. Students can join via classroom course or via Online course. This is the place where students can easily learn the required skill set to get placed immediately
Learn data science and other technologies at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace. Whether you are a beginner or a professional looking for advanced techniques, we have the right course for you. Hurry up!! Book your seat now!!!
Class-room of your choice
Upskill yourself by attending classroom or online class.
Flexible timings
Learn at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace.
Class-Room Size
With limited students in class, attention to each student's performance will be given.
Industry Ready Curriculum
The course is designed for people who want to work in the industry.
Book your free consultation now
If you want to improve your skills and get ready for the workforce! Please enter your information below, and one of our expertise will contact you shortly.
