Saturday, December 31, 2016

Autofit Table

Fit to page

Select the table and right-click.
Scroll to Autofit and then select AutoFit to Window.

Word will automatically adjust the table width to any margin or page orientation changes.

Here are some more table fit suggestions:

See all Topics

Friday, December 30, 2016

Resize Alt-Tab

Registry hack

Here are the instructions about how to size the thumbnails in Vista/Win7 to fit your screens resolution.

Windows 7

See all Topics

Thursday, December 29, 2016

Wednesday, December 28, 2016

Who's to Blame

The hammer or the carpenter?

Farhad Manjoo places the blame where it belongs, the show's producer, not the software.

No More Bullet Points

See all Topics

Tuesday, December 27, 2016

Excel to Outlook

Concatenate Excel Outlook

A common task is to bring a contact list into Outlook from Excel. Usually Excel will have names separated into columns. Other information, such as addresses may also be divided.
Here’s how to format the Excel file for a seamless import.

See all Topics

Monday, December 26, 2016

Ribon Guide


”These interactive guides show you where your favorite menu and toolbar commands are located in Office 2010-13. Just click the command or button that you want to find, and the guide will show you its location in the 2010-13 version of the program.”

See all Topics

Sunday, December 25, 2016


Web monitor

Versionista monitors web sites and alerts you by email of any changes. It also displays the changes visually on the page.
Here's one mention from the news:

Rachel Maddow

See all Topics

Saturday, December 24, 2016

Windows Split

Easy trick

Here's how to split the open window and/or create new windows.


See all Topics

Friday, December 23, 2016

Office 2010-2013

Preview review

Ed Bott has been writing about Office since 1996. Here is his take on the latest version.

Ed Bott Office 2010

Office 2013

Office 2010: Product Guides

Office 2013

See all Topics

Thursday, December 22, 2016

Runtime is Free

No need for Access

"If no end-user customization is required (including report modifications), you may choose to distribute these Access solutions so that they run without requiring a full installation of Access."

Access 2007 Runtime

Access 2010 Runtime

Access 2013 Runtime

See all Topics

Wednesday, December 21, 2016

Set Your Kindle Free


You can program your Kindle to accept screensavers, and other aps.

How to

See all Topics

Tuesday, December 20, 2016

Monday, December 19, 2016

Last Doc Shortcut

Back Quick

"A separate shortcut with a special switch that will open the last document that was open in Word."

Last Document

See all Topics

Sunday, December 18, 2016

Undelete Deletes

Get it back

"It’s happened to most of us. You delete a file and realize you need it back. This guide will explain when you can get that file back and how to go about it."

 How to Recover a Deleted File

See all Topics

Saturday, December 17, 2016

Move Up the Page

The old fingers walking trick

If you want to move words, paragraphs, bullets, up or down the keyboard shortcut is Shift+Alt + Up/Down/ arrow.

See all Topics

Friday, December 16, 2016


Full control

If you are overly confident about your skills, you might want to look at Greg Schultz's discussion on Administrator power.
”You should use the real Administrator account very sparingly - never make it your default modus operandi! Please note that you use this technique at your own risk.”

See all Topics

Thursday, December 15, 2016

Pause a Sound

And then I said

How to insert a sound file, and set it to play automatically, but also pause the narration at will during the slide show.

Andrew May

See all Topics

Wednesday, December 14, 2016

Hotmail Gmail


Instructions on how to import your old Hotmail account into Gmail:

GoogleSystem Blog

See all Topics

Tuesday, December 13, 2016

How Google Works


Here's what's going on behind the scenes.
  • Googlebot, a web crawler that finds and fetches web pages.
  • The indexer that sorts every word on every page and stores the resulting index of words in a huge database.
  • The query processor, which compares your search query to the index and recommends the documents that it considers most relevant.

See all Topics

Monday, December 12, 2016

Dates with Bill G

What it was like

February and March are incorrect in Excel.
Joel Spolsky talks about dates with Bill G.

Bill G

See all Topics

Sunday, December 11, 2016

How to spot a gun

using a graph

Edward Tufte has this discussion about a graphic that shows how to spot a hidden firearm.
"Color is used to highlight how the gun moves and how the gun reveals itself, short visual noun-verb sentences that indicate the key signs that help detectives to spot someone carrying a hidden handgun. Thus the color usually has a distinct substantive point and is not just used to depict surfaces or to decorate the news."

(Scroll down on web page)

Hidden hand gun

See all Topics

Saturday, December 10, 2016

Bracket Characters


Certain special characters must be surrounded with brackets:
"Microsoft Access does not restrict the use of special characters such as a number sign (#), a period (.), or a quotation mark (") in the database object names or in the database field names. However, if you do use the special characters, you may experience unexpected errors.
" To work around this problem, do not use special characters. If you must use special characters in query expressions, enclose the special characters in brackets ([]). For example, if you want to use the greater than sign (>), use [>]."
Special Characters

See all Topics

Friday, December 09, 2016

Multiple-Choice Template

A, B, or C

A template for creating a test paper.
Multiple-choice test or survey kit:

See all Topics

Thursday, December 08, 2016

Tipsy Windows

More suggestions

A lot of XP stuff, but many suggestions that are still useful.

Marvs Windows Tips

See all Topics

Wednesday, December 07, 2016

No Seeum Buttons

Invisible clicks

How to place spots on your slide that initiate actions when clicked, but are otherwise invisible.

Create invisible buttons

See all Topics

Tuesday, December 06, 2016

Basic Outlook

Good tutorial

  • Basic principles of good time management
  • Folders
  • Rules
  • Notifications
  • Categories
  • Daily review: Managing your time and your tasks
  • Find that message: Searching effectively
  • Calendars and meetings
  • Contacts
Best Practices for Microsoft Outlook

See all Topics

Monday, December 05, 2016

Flight Status

Where da plane?

An easy way to find out whether Aunt Mable's plane is on time is to type the airline name and number into Google (or Bing).

See all Topics

Sunday, December 04, 2016


Process and sample

The need to create a graphic view of a timeline can occur often.

Here are the instructions:

See all Topics

Saturday, December 03, 2016

More Controls

Proximity Functions

"Proximity Functions" is a set of MS Access modules, forms and controls that you can use to easily add professional functionality to your MS Access application without programming. By simply importing a few modules, then copying and pasting one control next to a text control on your form you can add Windows-standard file open/save dialogs, folder browse dialogs, color selection dialogs, a fantastic calendar date picker dialog, and more.

See all Topics

Friday, December 02, 2016

Ribbon Reasoning

What it's all about

Users opened Office 2007-10 and were shocked by the
transformation that was the Ribbon User Interface.
Here's a collection of how to's and why's by Patrick Schmid.
The Office UI Bible

See all Topics

Thursday, December 01, 2016

PPT Suggestions

Many how tos

  • Sound Solution: Playing Music on HTML Presentations
  • Creating Depth within a Slide Presentation
  • Creating & Running an Opening Loop
  • Using PowerPoint in Dual Monitor/Projector
  • Boom - Blowing things up
  • Black and White Printing Solution
  • PowerPoint Animations: Starting Things Going
  • Making and Preserving a Second Master
  • Find fabulous fonts to dress up your deck
  • Ten PowerPoint FAQ Entries You Don't Know You Need to Read

See all Topics