keyboard-1

Need more screen space for your Excel Dashboard?

With just a few setting changes, you can open the screen on your monitor to allow for more space for your Excel Dashboard: On the View Ribbon, in the Show section, remove the check mark from: Gridlines Formula Bar Headings Click the File tab, then Options.  On the left select Advanced.  Scroll to the section [...]

By | October 13th, 2015|Dashboard Tips, Excel Tips, Office 2010 Tips, Office 2013|Comments Off on Need more screen space for your Excel Dashboard?

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