Outline Excel Data in Microsoft Excel: Overview You can outline Excel data to add an organizational quality to a long or wide worksheet. When you outline Excel data, you group worksheet data into different levels based on column and row headings. Lower level data is associated with the headings in the rows or columns.
Remove Cell Formatting in Excel: Overview You can remove cell formatting in Excel to clear all the currently applied cell formatting. Removing cell formatting is also called clearing cell formatting. Doing this lets you remove cell formatting that causes problems from selected cells. When you remove cell formatting in Excel, it does not affect
Remove a Watermark in Word: Overview This lesson shows you how to easily remove a watermark in Word. A watermark is simply an image or text that appears underneath the primary text in a document. Watermarks often display additional information or instructions regarding the primary content. For example, you may see a “DO NOT
Create a Custom Page Background in Publisher: Overview Create a Custom Page Background in Publisher: How to Apply or Remove a Page Background You can create a custom page background in Publisher using the “Fill Effect” formatting also applied to shapes and pictures. To display the available default page background choices, click the “Page
Layout Guides in Publisher: Overview Layout Guides in Publisher: Types of Layout Guides You use layout guides in Publisher to help with the layout of page content. There are many different types of layout guides in Publisher. For example, margin guides appear onscreen to help you stay within the printable page area. Margin guides
Conditional Formatting in Excel: Overview Conditional formatting in Excel lets you define criteria for cells which change the way the cells look in the worksheet, but only if the cells’ values match the criteria. For example, you could create a conditional formatting criterion that makes a worksheet cell appear with a red fill color
Workbook Protection in Excel: Overview When you apply workbook protection in Excel, users cannot add, delete, hide, rename, or move workbook worksheets. You can also provide an optional password that must be entered before the workbook can be unprotected. This option is also a bit risky, because if you forget the password, you cannot
Change Worksheet Tab Color in Excel: Overview You can change worksheet tab color in Excel, if desired. To do this, first select the worksheet tab whose tab color you wish to change. Next, click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse