2

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.

Improve this question
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, 2014 at 16:07
  • Tried, didn't work..
    – Firee
    Mar 2, 2014 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, 2014 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, 2014 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, 2014 at 12:06

8 Answers 8

Reset to default
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.

Improve this answer
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, 2018 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.
Improve this answer
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.

Improve this answer
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, 2014 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

Improve this answer
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.

Improve this answer
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'

Improve this answer
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

Improve this answer
-1

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

Improve this answer
2
  • 2
    Couldn't locate it, can you put a screenshot
    – Firee
    Nov 28, 2014 at 9:53
  • @Noel, You might mean Powerpoint; his question is about Excel
    – Mohammad ElNesr
    Mar 16, 2023 at 21:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .