Maximizing Connectivity & Productivity

Archive for the Excel Category

Excel Chart tip -ribbon vs format dialog

The ribbon controls do not have a complete set of tools for chart elements.  The Format dialog box has options that are not available on the ribbon.

Read more

Excel Charts – Pie, Doughnut or Stacked

Pie charts can represent only one data series, whereas doughnut charts can represent multiple data series.  Each of these series in a doughnut chart are represented by concentric rings.  Because one ring is smaller than the other, the slices of the ring(s) may give a visually decieving representation […]

Read more

Excel Cell reference type change shortcut

You can change the cell reference type, manually and painfully using $ signs before the row numbers and/or column headers.  Or, you can take the easy route using the F4 key. To use, insert the ‘=’ sign in the  cell, then use your mouse to select the […]

Read more

Drawing toolbar in Excel 2010

If you are wondering where this disappeared in Excel 2010, you can blame the Ribbon.  The Ribbon is designed to show the menus with commands to help complete a task.  As such, there are the basic commands on each tab, and then there are the Contextual tabs […]

Read more

Scroll through worksheet without losing active cell

 While in the Active cell, press the Scroll Lock key.  Excel will display Scroll Lock  in the Status bar.  Use the navigation arrows to scroll/navigate through the worksheet as required.  When done, use Ctrl-Backspace key to return to the active cell.  Press the Scroll Lock key again […]

Read more

Excel – Date axis in Sparklines

Sparklines in Excel tend to show values as if the dates exist even if there are gaps in dates, by showing even charts with no intervals.  However, if the date axis is selected,  the sparkline charts will show the gaps in the dates. To specify a date […]

Read more

Excel files as source for Excel Query

Data from other Excel workbooks may be used in a workbook.  You can put as many data tables in a workbook as a source for Query, but you will need to name the tables as ranges, because that’s how they are identified in Query.

Read more

Excel – Formatting Comments

Yes, you can change the look of those yellow comments if you feel you have too.. Right click the cell, select Edit Comment, then select the fonts and alignments from their respective groups on the Home tab. Right click the comment’s border,select Format Coment to: Change the color, […]

Read more

Excel Comments to Cells

Comments to cells are a good way to document the purpose of the cell, or describe the formula etc. To add a comment you can: Right-click the cell and select Insert Comment Press Shift+F2 Choose Review-> Comments-> New Comment You can control the display of the comments […]

Read more

Excel 2007 – Calculation Issue

Check out this link for more details..

Read more
Page 2 of 3123
Mississauga, ON, Canada 905.607.3500