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.
Format a PivotTable in Excel: Overview You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing
Make Columns in Publisher: Overview You can make columns in Publisher to aid in the layout of a publication page. You can then add text boxes over the column guides you create in the page to produce newsletter-style layouts. When you make columns in Publisher, you can also add rows to a publication 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
Use a Top 10 AutoFilter in Excel: Overview You can use a Top 10 AutoFilter in Excel to show a specified number of the top or bottom percent or items in a field within the table. When you use a Top 10 AutoFilter in Excel, it defaults to showing the top 10 percent of
Sort a Table in Excel: Overview You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
Create Columns in Word: Overview You may need to create columns in Word for documents that need them, like a newsletter. This is helpful for separating text vertically. When you create columns in Word, the text flows from one column to the next on the same page. Also note that you can add columns
Add a Citation Placeholder in Word: Overview You can add a citation placeholder in Word if you need to add a citation, but don’t have one yet. In this case, you can insert a “Citation Placeholder” to mark the location in the document for a future citation. You can then return to edit the