odlkp.blogg.se - How to choose fill color for background excel mac

In addition, we can also add a gradient effect to a cell selection.ġ. Here, WPS Office has provided us with multiple color choices. If there is no color we want, we can click More colors. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box.Ĭlick Patterns, then we can choose a pure color to fill the cell in the Background color area. If we want to fill the B3:G3 cell with color, select this area first.Ĥ. To do this, we can fill the cell with background color and pattern.ġ. There's every chance the inexperienced user will never realise that the apparently same "Format Comment." option available at the comment border actually reveals a whole lot more tabs.When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. What I find disappointing about the Excel UI in this case is that right-clicking while hovering over the body of the comment instead produces a context menu that looks almost exactly the same (one word is different: "Exit Edit Text" replaces "Edit Text"), but here the "Format Comment." option reveals only the Font tab. On mine (Excel 2016) there's a sense in which both suggestions for step 2 are correct: if I hover over one of the 'o handles' (turning the cursor into a double-headed arrow _or_ if I hover over any other part of the comment border (turning the cursor into a four-headed arrow) I can right-click and Format Comment will then reveal the full set of tabs including Colors and Lines.

I agree with Redd, Manning - these tips are very valuable and welcome, notwithstanding slight variations between systems and versions.

You can then follow steps 4 through 7, the same as above.

Adjust the transparency of the fill color, as desired.Īn alternative way to display the Format Comment dialog box is to simply click once on the comment (step 1) and then press Ctrl+1.

Use the Color drop-down list (the one at the top of the dialog box) to specify what color you want used to fill your comment box.

Make sure the Colors and Lines tab is displayed.

Word displays the Format Comment dialog box.

Right-click and then choose Format Comment from the resulting Context menu.

Hover the mouse pointer over the border it will look like a four-headed arrow.

Handles should appear around the border of the comment.

Click once on the comment to select it.

You can change the fill color of a comment rather easily. She wonders, though, if there is a way to actually change the background (fill) color of the comment. When working with comments, Heather figured out how to change the font color in the comment.