1

There is a nifty 'Eyedropper' tool present in Powerpoint 2013. Does anybody know if the same can be enabled / activated or is it present in Excel 2013.

9
  • Why not use the eyedropper to catch the color and then use that color in excel? Or use a web tool to define the hex or dec color and use it in excel? – Raystafarian Feb 27 '14 at 16:07
  • Tried, didn't work.. – Firee Mar 2 '14 at 12:32
  • which part? Could you get the value of the color and not put it in excel? Or not get the value at all? – Raystafarian Mar 2 '14 at 14:47
  • The eyedropper cursor will remain in the confines of the power-point window, you can't minimize it and point it to something in your browser for example or other office documents – Firee Mar 2 '14 at 19:12
  • 1
    @Firee: Is using good-old Paint an option - Snipping tool > Snip > Copy > Paste to Paint & use Color Picker tool there. – Viral Jain Mar 3 '14 at 12:06
2

It isn't available in Excel 2013. Excel isn't designed to be focused as heavily on the visual aspect of the presentation of data, so it has fewer tools to do that with.

1
  • 2
    I'd prefer consistency between all MS products - just my 50 cents; its getting better with most recent version but its still a long way to go – n3rd Oct 11 '18 at 16:02
3

There are multiple ways to do this.

One way is within Excel to find out a color by going to

  1. Page Layout and on the Themes menu selecting Colors, and then
  2. selecting Customize Colors, and then
  3. whichever color you want to use.
    • You can click on "More Colors" underneath it and find out the RGB levels and then manually put that in for other shapes you want.

OR, easier still, you can

  1. copy/paste whatever you want from Excel into Powerpoint and then
  2. use the eyedropper in Powerpoint on it to select the color, and then
  3. go to Fill/More Colors and find out what the RGB levels are for it and then manually use that in Excel or other MS programs.
1

One can use the Format Painter to copy the formatting from one place and apply to another. Go to the Clipboard at the upper left corner and look for a Paint Brush

paintbrush

hover over for a brief description.

1
  • I don't believe this is what the questioner is asking about. They were looking for a precise color picker rather than a way to copy an entire format. – fixer1234 Dec 7 '14 at 0:55
1

Use Pixie to tell you the RGB values and type manually into Excel's Custom Colors dialog.

http://www.nattyware.com/pixie.php

  1. Open Pixie and hover mouse over desired color
  2. Open Custom Color Dialog in Excel and type the RGB value in

Pixie with Excel example: Pixie with Excel example

1

Easier variation to the RGB method:

  1. Select a component with the desired color
  2. Navigate to Colors → More Colors
  3. Select OK

The color will be listed under "Recent Colors" for easy use.

0

There is no eye dropper tool available. Ways to replicate a colour to another cell include.

1) Clicking the drop down box at the side of the paint pot icon. Click 'more colours'. Click the 'custom' tab. Note down the colour model reference numbers. Next select the cell that you want this colour to be applied to, follow the same process and then when in the 'custom' colour tab type in the reference numbers you had noted earlier.

2) right click the coloured cell and click 'copy'. Next go to the new cell, right click and select 'paste special'. Then either click the 'formatting icon' or simply type the letter 'R'

0

You cannot. But, if you have to use many colors you can try my suggestion below:

  • Get the screenshot of the area you want to get the colors (printscreen [PRT SC] key)

  • Open Paint.

  • Paste into Paint.

    For each specific color:

  • Use eyedropper tool in Paint

  • Click the color

  • Click "Edit colors" in toolbar

  • Add the color into "Custum colors" (use tab to switch to the group and use arrow keys to locate an empty area and press "Add to Custom Colors")

Now you have all the colors in custom colors (maximum 16).

But, unfortunately, you cannot use this Windows standard(!) color dialog box in Excel (maybe or hopefully in the future).

You have to open Paint and Excel side by side and enter the color's RGB (Red, Green, Blue) values by looking it in Paint by clicking "Edit colors" in toolbar and clicking the specific color in "Custom colors"

See a demonstration in Turkish Windows

-1

If you go format shape - colour - more colours - theres a magnifying glass that acts as an eye dropper.

1
  • 2
    Couldn't locate it, can you put a screenshot – Firee Nov 28 '14 at 9:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.