How to create a dark matter box pattern in microsoft excel

Here’s how to add a line, pattern, or custom border to a text box, picture, and other objects in Word, PowerPoint, or Excel for Mac.

Note: If you didn’t add the border to the shape, text box, picture, or other object in Mac Office, you can’t change or remove the border for the object.

Try the “Sketched” outline

This feature is available only to Microsoft 365 Subscribers for Windows desktop clients.

If you’re using Microsoft 365 for Mac (version 16.28 or later), you can give a casual, hand-drawn look to shapes with the Sketched outline.

Select an existing shape in your document, or draw a new one.

With the shape selected, on the Shape Format tab, select Shape Outline > Sketched, and then select a line width. (The smaller the point size (“pt”), the thinner the line is.)

Add or remove a border for a shape or text box

Select the shape or text box to which you want to add, change, or remove a border.

Click Shape Format, and then click the arrow next to Shape Outline.

How to create a dark matter box pattern in microsoft excel

Do any of the following:

Add or change the color of the border

Either click the color that you want, or mix your own color by clicking More Outline Colors.

Add or change the thickness of the border

Point to Weight, and then choose the line weight that you want.

Add or change the style of the border

Point to Dashes, and then click the line style that you want.

Remove the border from the shape or text box

Click No Outline.

Add or remove a picture border

Select the picture to which you want to add, change, or remove a border.

Click Picture Format, and then click the arrow next to Picture Border.

How to create a dark matter box pattern in microsoft excel

Do any of the following:

Add or change the color of the border

Either click the color you want, or mix your own color by clicking More Outline Colors.

Add or change the thickness of the border

Point to Weight, and then choose the line weight you want.

Add or change the style of the border

Point to Dashes, and then click the line style you want.

This article shows you how to automatically apply shading to every other row or column in a worksheet.

There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data.

One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd numbered, and then applies the shading accordingly. The formula is shown here:

Note: If you want to apply shading to alternate columns instead of alternate rows, enter =MOD(COLUMN(),2)=0 instead.

On the worksheet, do one of the following:

To apply the shading to a specific range of cells, select the cells you want to format.

To apply the shading to the entire worksheet, click the Select All button.

On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click New Rule.

In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format.

In the Format values where this formula is true box, enter =MOD(ROW(),2)=0, as shown in the following illustration.

How to create a dark matter box pattern in microsoft excel

In the Format Cells dialog box, click the Fill tab.

Select the background or pattern color that you want to use for the shaded rows, and then click OK.

At this point, the color you just selected should appear in the Preview window in the New Formatting Rule dialog box.

To apply the formatting to the cells on your worksheet, click OK

Note: To view or edit the conditional formatting rule, on the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules.

Another way to quickly add shading or banding to alternate rows is by applying a predefined Excel table style. This is useful when you want to format a specific range of cells, and you want the additional benefits that you get with a table, such the ability to quickly display total rows or header rows in which filter drop-down lists automatically appear.

By default, banding is applied to the rows in a table to make the data easier to read. The automatic banding continues if you add or delete rows in the table.

How to create a dark matter box pattern in microsoft excel

If you find you want the table style without the table functionality, you can convert the table to a regular range of data. If you do this, however, you won’t get the automatic banding as you add more data to your range.

On the worksheet, select the range of cells that you want to format.

On the Home tab, in the Styles group, click Format as Table.

Under Light, Medium, or Dark, click the table style that you want to use.

Tip: Custom table styles are available under Custom after you create one or more of them. For information about how to create a custom table style, see Format an Excel table.

In the Format as Table dialog box, click OK.

Notice that the Banded Rows check box is selected by default in the Table Style Options group.

If you want to apply shading to alternate columns instead of alternate rows, you can clear this check box and select Banded Columns instead.

If you want to convert the Excel table back to a regular range of cells, click anywhere in the table to display the tools necessary for converting the table back to a range of data.

On the Design tab, in the Tools group, click Convert to Range.

Tip: You can also right-click the table, click Table, and then click Convert to Range.

Note: You cannot create custom conditional formatting rules to apply shading to alternate rows or columns in Excel for the web.

When you create a table in Excel for the web, by default, every other row in the table is shaded. The automatic banding continues if you add or delete rows in the table. However, you can apply shading to alternate columns. To do that:

Select any cell in the table.

Click the Table Design tab, and under Style Options, select the Banded Columns checkbox.

To remove shading from rows or columns, under Style Options, remove the checkbox next to Banded Rows or Banded Columns.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

You can use several types of UI elements to extend the Office UI, including add-in commands and HTML containers. These UI elements look like a natural extension of Office and work across platforms. You can insert your custom web-based code into any of these elements.

The following image shows the types of Office UI elements that you can create.

How to create a dark matter box pattern in microsoft excel

Add-in commands

Use add-in commands to add entry points to your add-in to the Office app ribbon. Commands start actions in your add-in either by running JavaScript code, or by launching an HTML container. You can create two types of add-in commands.

Command type Description
Ribbon buttons, menus, and tabs Use to add custom buttons, menus (dropdowns), or tabs to the default ribbon in Office. Use Buttons and menus to trigger an action in Office. Use tabs to group and organize buttons and menus.
Context menus Use to extend the default context menu. Context menus are displayed when users right-click text in an Office document or a table in Excel.

HTML containers

Use HTML containers to embed HTML-based UI code within Office clients. These web pages can then reference the Office JavaScript API to interact with content in the document. You can create three types of HTML containers.

How to create a dark matter box pattern in microsoft excel

Among the new features in Microsoft Office 2016 are some improvements to the user interface. For example, they added a background image to the title bar in each Office program, and an improved dark theme. Customizing the background and theme is easy, and we’ll show you how to do it.

By default, the background image is clouds, but there are several other background images from which you can choose. You cannot add your own images, but if you don’t like any of the included images, you can choose to not have a background image on the title bar at all.

We’ll show you how to change the title bar background and theme in Word, but the procedure is the same in Excel, PowerPoint, and Outlook as well. To begin, click the “File” tab.

How to create a dark matter box pattern in microsoft excel

On the backstage screen, click “Options” in the list of items on the left.

How to create a dark matter box pattern in microsoft excel

The General screen displays by default. On the right side, in the Personalize your copy of Microsoft Office section, select an option from the “Office Background” drop-down list. If you don’t want a background image on the title bar, select “No Background”.

How to create a dark matter box pattern in microsoft excel

If you don’t see a background image on the title and the Office Background drop-down list is not available on the Options dialog box, that means you aren’t signed into your Microsoft account in Office. The Office Background feature is only available when you are signed into your Microsoft account. If you’ve signed in to Windows 10 using your Microsoft account, you should have access to the Office Background option, unless you specifically sign out of Office.

How to create a dark matter box pattern in microsoft excel

If you use a local account in Windows 10, or you’re using an earlier version of Windows, you can access the Office Background feature by signing into your Microsoft account in any Office program, using the “Sign in” link on the right side of the title bar.

How to create a dark matter box pattern in microsoft excel

To change the color theme, select an option from the “Office Theme” drop-down list. The Dark Gray and Black themes are now available as dark themes; however, the Black theme is only available to Office 365 subscribers. The Colorful theme is a different color in each program, such as blue in Word, green in Excel, and orange in PowerPoint.

How to create a dark matter box pattern in microsoft excel

Once you’ve made your changes, click “OK” to accept them and close the Options dialog box.

How to create a dark matter box pattern in microsoft excel

The newly selected background image (if any) and theme is applied to the title bar in the currently open Office program.

How to create a dark matter box pattern in microsoft excel

The selected background image and theme is applied to all Office programs. You cannot select a different image and theme for each program.

To change the colors of the current workbook

1. On the Page Layout tab, in the Themes group, click Theme Colors:

2. Click Customize Colors. :

How to create a dark matter box pattern in microsoft excel

3. In the Create New Theme Colors dialog box, under Theme colors, click the button of the theme color element that you want to change:

How to create a dark matter box pattern in microsoft excel

4. Under Theme colors, select the colors that you want to use:

How to create a dark matter box pattern in microsoft excel

In the Create New Theme Colors dialog box, under Sample, you can see the effect of the changes that you make.

5. Repeat steps 3 and 4 for all of the theme color elements that you want to change.

6. In the Name box, type an appropriate name for the new theme colors.

7. Click Save.

Note: To revert all theme color elements to their original theme colors, you can click Reset before you click Save.

To make changes apply to all new workbooks

If you would like to make these color changes apply to all new workbooks that you create, you need to create a default workbook template.

1. On the Page Layout tab, in the Themes group, click Themes.

2. Click Save Current Theme. :

How to create a dark matter box pattern in microsoft excel

3. In the File Name box, type an appropriate name for the theme.

Note: A customs document theme is saved in the Document Themes folder and is automatically added to the list of custom themes.

4. On the File tab, choose Save As.

5. In the Save Current Theme dialog box, was selected Office Theme (*.thmx) and chose the Document Themes folder as the location. You can use your own filename instead of the proposed Theme1.thmx.

The location of the Document Themes folder may vary, but it is usually located here:

C:Users AppData Roaming Microsoft Templates Document Themes

6. Click Save.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

This example shows you how to use conditional formatting to shade alternate rows. Shading every other row in a range makes it easier to read your data.

1. Select a range.

How to create a dark matter box pattern in microsoft excel

2. On the Home tab, in the Styles group, click Conditional Formatting.

3. Click New Rule.

How to create a dark matter box pattern in microsoft excel

4. Select ‘Use a formula to determine which cells to format’.

5. Enter the formula =MOD(ROW(),2)

6. Select a formatting style and click OK.

How to create a dark matter box pattern in microsoft excel

How to create a dark matter box pattern in microsoft excel

Explanation: the MOD function gives the remainder of a division. The ROW() function returns the row number. For example, for the seventh row, MOD(7,2) = 1 because 7 divided by 2 equals 3 with a remainder of 1. For the eight row, MOD(8,2) = 0 because 8 divided by 2 equals 4 with a remainder of 0. As a result, all odd rows return 1 (TRUE) and will be shaded.

When you create a new, blank spreadsheet in Microsoft Excel, and you are using the default settings, you see gridlines that indicate the size of your individual cells. These are effective when you are looking at that sheet on your computer screen, and when you haven’t made any formatting changes.

But as more and more actions are taken on that spreadsheet, you may find that you need some additional indication of the separation of your cells. Fortunately you can achieve this by adding borders to a cell. You can do this the same way for individual cells, or even for the entire spreadsheet.

How to Add Borders to Cells in Excel

The steps in this article were performed in the Excel for Office 365 version of the application, but will also work in other Excel versions after the 2007 version.

Note that borders and gridlines are different things. If you are trying to add borders to your cells when you print, then consider changing the gridline setting on the Page Layout tab instead by checking the box to the left of Print under Gridlines.

Step 1: Open your spreadsheet in Excel.

Step 2: Select the cell(s) to which you wish to apply a border. Note that you can select the entire sheet by clicking the gray button above the row 1 heading and to the left of the column A heading.

How to create a dark matter box pattern in microsoft excel

Step 3: Click the Home tab at the top of the window, then click the arrow to the right of the Borders button in the Font section of the ribbon.

How to create a dark matter box pattern in microsoft excel

Step 4: Select the type of border that you wish to apply to the selected cells. If you want to add borders to all sides of your cell, for example, click the All Borders option.

How to create a dark matter box pattern in microsoft excel

If you wish to make changes to the style of the borders, you can select the More Borders option from the bottom of the menu in step 4.

How to create a dark matter box pattern in microsoft excel

Do some of your cells have row shading that you don’t want, or is no longer useful? Find out how to remove all row shading from a spreadsheet in Excel.

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Color Scales in Excel make it very easy to visualize values in a range of cells. The shade of the color represents the value in the cell.

To add a color scale, execute the following steps.

1. Select a range.

2. On the Home tab, in the Styles group, click Conditional Formatting.

3. Click Color Scales and click a subtype.

How to create a dark matter box pattern in microsoft excel

How to create a dark matter box pattern in microsoft excel

Explanation: by default, for 3-Color scales, Excel calculates the 50th percentile (also known as median, middle value or midpoint). The cell that holds the minimum value (9) is colored red. The cell that holds the median (36) is colored yellow, and the cell that holds the maximum value (80) is colored green. All other cells are colored proportionally.

Read on to further customize this color scale.

4. Select the range A1:A7.

5. On the Home tab, in the Styles group, click Conditional Formatting, Manage Rules.

6. Click Edit rule.

Excel launches the Edit Formatting Rule dialog box. Here you can further customize your color scale (Format Style, Minimum, Midpoint and Maximum, Color, etc).

How to create a dark matter box pattern in microsoft excel

Note: to directly launch this dialog box for new rules, at step 3, click More Rules.

7. Select 2-Color Scale from the Format Style drop-down list and select white and blue.