Maximizing Connectivity & Productivity


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

Creating Word Templates

Why create word templates and how do we create them without unwanted add-ons? The number one no-no is to not base your template on an existing document. This will only invite every little attribute or hanger-on that is either not really obvious, but not deleted, to come […]

Read more

Poll: IT Pros plan to buy Microsoft Surface tablets not iPads

What’s the pro opinion on tablets – Apple Ipads vs Microsoft Surface tablets (and others)?  Check the poll results by Techrepublic.. Related:;siu-container

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

Word – Create a new style

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

Word – Page Borders

Dressing up a page with a border is simple.  Apart from a borders decorative uses, a border can be useful too.  For ex. you can use this feature to create cut out borders for coupons. Go to Page Layout tab -> select Page Borders from Page Background […]

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
Page 4 of 8« First...23456...Last »
Mississauga, ON, Canada 905.607.3500