Excel PivotTable Issue: Create a Calculated Field that has a Field Title that uses Alt + Enter to Split the Field Title into Multiple Lines

One of the rules for working with an Excel database and preparing it for a PivotTable is that the raw list of worksheet data must contain a header (individual column headings) row and that row can only be one row deep. NOT this!   Below is a workbook with titles on one row but  that [...]

By | June 21st, 2015|Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Excel PivotTable Issue: Create a Calculated Field that has a Field Title that uses Alt + Enter to Split the Field Title into Multiple Lines

Display the Ampersand (&) in an Access Database Label or Text Box

It you need to use the ampersand (&) in a label or text box in a Microsoft Access database, it will display as an underscore (_). For example, you type and want to display “Sales & Marketing” but you get “Sales _ Marketing”. To display the & symbol: Double up the & - “Sales && [...]

By | June 21st, 2015|Access Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Display the Ampersand (&) in an Access Database Label or Text Box

Use the Tab Scroll Buttons in Excel

To make a specific worksheet active for editing, you can click on its sheet tab. Excel lets you know what sheet is active by displaying the sheet name in boldface and making its tab appear on top of the others.  The active sheet tab is a different color from the inactive sheet tabs. On the [...]

By | June 21st, 2015|Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Use the Tab Scroll Buttons in Excel

Use the N function in Excel to Add a Comment to a Cell

You can add a “comment or note” to a cell with a formula and it will be hidden in the cell’s formula. The formula below multiplies the sales ($5,000) by 37.5% then there is a note that explains why.   NOTE: +N(“quotations must be used around the note”)

By | June 15th, 2014|Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Use the N function in Excel to Add a Comment to a Cell