Sunday, April 23, 2017

Worksheet Name

Formula construction

There may come a time when you need to display the name of a worksheet.

This formula will do the job:

returns the path, the Workbook name and the Worksheet name. (C:\Documents\[April.xls]\Costs)
selects the text that starts at a certain point and goes on for a certain number of characters.

The formula, as written, looks at the full path and selects the first time a closing bracket (]) is found.

It then moves 1 character to the right and displays the results up to 31 characters.
(A worksheet name cannot be more that 31 characters long.)

You could include a reference to that cell on other worksheets.

See all Topics

Saturday, April 22, 2017

Hosts File

I've got your number

"...the Hosts file is like an address book. When you type an address like into your browser, the Hosts file is consulted to see if you have the IP address, or "telephone number," for that site. If you do, then your computer will "call it" and the site will open. If not, your computer will ask your ISP's (internet service provider) computer for the phone number before it can "call" that site.
Most of the time, you do not have addresses in your "address book," because you have not put any there. Therefore, most of the time your computer asks for the IP address from your ISP to find sites."

What is a Hosts file? has a Hosts file that you can download and install. It includes a BAT file that renames the old file before it saves the new one.

See all Topics

Friday, April 21, 2017

Busted Links


With the Expression Web Designer go to Site>Reports>Problems>Hyperlinks.
You will able to check if any links have failed and need to be fixed.

There are a few third-party shareware programs that do the same thing.

One of them is:

Xenu's Link Sleuth

It's free and will create a report that can be saved for reference.

See all Topics

Thursday, April 20, 2017

Squeezin' out the Pixals

Slim PP Fast

When you insert pictures into a PowerPoint show, the size of the file begins to bloat. There is a built in tool that helps.
  1. Select the graphic.
  2. Right-click and pick "Format Picture".
  3. Click the "Picture" tab and click on the "Compress" button.
  4. Click "Selected pictures" to compress the currently picture. Choose "All pictures in document" to handle all images in the show.
  5. In the "Change resolution" section, choose how your show is going to be presented.
  6. In the "Options" section, check both "Compress pictures" and "Delete cropped areas of pictures."
  7. OK your way out.
In PowerPoint 2007+ select the picture and look at the Picture Tools >Format group.


The PowerPoint & Office Art Team Blog:
Compress Pictures

See all Topics

Wednesday, April 19, 2017

View Related Fields

The whole thing

When designing a query, you'll often find the need to temporarily view fields beyond the ones you want shown in the final result.

To do so, you probably drag the relevant fields to the design grid and then delete them when you're done. However, there's an easier way to view the data that you typically want excluded in the query.

To do so:
  1. Open the query in Design view.
  2. Display the query's Properties sheet
  3. Set the Output All Fields property setting to Yes
  4. Run the query
Data from all of the underlying tables' fields will be displayed in addition to the fields you specified in the QBE grid. To change the query so that it only displays the fields explicitly selected in the QBE grid, simply
reset the Output All Fields property to No.


See all Topics

Tuesday, April 18, 2017

Delete Fast

No waiting

Unfortunately, Outlook does not allow you to use CTRL or Shift to select multiple folders at a time to delete them. Also the process slows down as the contents are deleted and then the folder. A quick way to get rid of them is to drag them to the Deleted Items folder.

The same is true of emails destined for the garbage bin.
Delete Folders

See all Topics

Monday, April 17, 2017

CSS Links

Some of the Best

If you have an interest in Cascading Style sheets, look at a few of these tutorials and downloads.

"CSS Creator site is a place for you to learn about and create CSS, Cascading Style Sheets. The CSS Forum is a place where you can discuss CSS page layouts, positioning, bugs and just about anything related to cascading style sheets.
The forum is new, free and most of all needs people like you to create a community. Talk about CSS, ask questions, find solutions, and help each other learn at the CSS Forum."

CSS has a collection of links to valuable Web design information.

See all Topics

Sunday, April 16, 2017

Work that Menu

List of project docs

A collection of tips including:

Word (pre-07) allows you to add a menu to the toolbar that can keep a list of papers you're working on:

  1. Go to Tools>Customize.
  2. Click the Commands tab.
  3. Under the list of Categories, click Built-in menus.
  4. Under the list of Commands, locate and drag the Work menu to your toolbar.
  5. Click Close

Work Menu

In Word 2007+, you can see a list of 50 recently used documents when you click the Office logo. If you don't want them to drop off the list, they can be pinned.

See all Topics

Saturday, April 15, 2017

Custom Lists

Your Way

At times, you will want to enter the same information repeatedly in a spreadsheet.
It could be employee names, products or State names.

Here is a way to produce the information when needed.

Make a list of the items.
Enter the data in, say, A1, B1, C1 etc.
Be sure to enter in the right order; maybe Supervisor and then team members in alphabetic order.

Select all of the cells.
Go to Tools>Options and choose the Custom lists tab.
Click Import.
OK your way out.

Now you can delete the entries on the spreadsheet.

Choose any cell and type one of the items that are on your Custom List.
Click and drag on the fill handle; the tiny square at the bottom right corner of the selected cell.
As you pull, Excel will duplicate your list.

(In Excel 2007+, go to the Office Logo. Choose Excel Options. Edit Custom Lists will be on the Popular page.)

Also see:

The First Shall Be Last
by Dick Kusleika

Sorting by Color
by Chip Pearson

See all Topics

Friday, April 14, 2017

PowerPoint Screed

WSJ on slide shows

Here is another article trying to rein in the PP overkill.
It is easier to put together a PowerPoint show than it is to write an intriguing speech; Six bullet points vs. 6 pages of text.

Why is it the that polite audience members congratulate even the worse presentations?
"But the civility has some self-interest. Larry Chung, a software developer, doesn't criticize fellow presenters, he says, "because I know the tables could be turned a few weeks later."
To him, PowerPoint presentations are like corporate karaoke. "For the most part, it's tough to listen to," he says. "We all applaud each other even though we know how bad it stinks."

Go Easy on the Text

See all Topics

Thursday, April 13, 2017

Calendar Templates

New days

Here are calendars that you can produce using Word, PowerPoint, or even Visio.


Also see
Make a Calendar

"For each month of each year featured, there are a variety of printable calendar pages for you to choose from. You can print out calendar pages that include coloring pages, selected craft projects, and special days to celebrate. "

See all Topics

Wednesday, April 12, 2017

Progress bar on Forms

Show movement

You can display computer time by using the Microsoft Progress Bar Control. In earlier versions of Access, it can be found by using the "More Controls icon in the Toolbox. In Access 2007 it's under "Insert Active X Control".

Here are the instructions from
Progress Clock

See all Topics

Tuesday, April 11, 2017

Calendar Printing Assistant

Printing help for 2007+

Some of the things you can do:

  • You can print and compare calendars in a variety of views:
  • Personalize your calendars with notes, images, colors, and designs:
  • Adjust information to changing views
  • Display information the way you need it:
  • Forecast your activities. The Calendar Printing Assistant has tools to display and organize long-range calendar
Calendar Printing Assistant

Also see
Printing Tools

See all Topics

Monday, April 10, 2017


What's to know?

Fun, fashion & science in this quirky site about shoelaces. Whether you want to learn to lace shoes, tie shoelaces, stop shoelaces from coming undone, calculate shoelace lengths or even repair aglets, Ian's Shoelace Site has the answer!

See all Topics

Sunday, April 09, 2017

Template Videos

See how it's done

Access 2013-16 template videos available.

"Access  ships with Web database templates, each of which does a great job of showing off the new features. We've created videos about how to use each template, as well as a video showing you how to modify a template by adding a field."

See all Topics

Saturday, April 08, 2017

Spell Checker Update

Word 2007+

A discussion of how Spell Checker works and how it has improved over the years.

See all Topics

Friday, April 07, 2017

Thursday, April 06, 2017

Montage in PPT

No need for Photoshop

Fill a picture with a gradient - or another picture in PowerPoint? Have you wanted to blend two pictures in PowerPoint to create a montage?

Transparent montages in PowerPoint

See all Topics

Wednesday, April 05, 2017

Open Calendar

First thing

"If you want Outlook to start in the Calendar folder, go to Tools, Options, Other tab, Advanced and select the calendar in the Start up in this folder field. If the folder you want to use isn’t listed you can create a shortcut using the /select switch: "
outlook /select "outlook:calendar\subcalendar"

See all Topics

Tuesday, April 04, 2017

Video without sidebar

Avoid collateral references

Sometime the appropriate video has inappropriate links next to it. Here's how to embed just what you want

See all Topics

Monday, April 03, 2017

Control Sort

Your choice

You can determine how Excel sorts your data.


See all Topics

Sunday, April 02, 2017

Find Commands

Ribbon seeker

MS has a download that can be used to search for those old toolbar commands on the new Ribbon.

See all Topics

Saturday, April 01, 2017

SS Zip Codes

Excel to Access

Social Security Numbers and ZIP Codes can present special challenges when importing them into Access from Excel. This tip explains how you can prepare the data for the smoothest transition possible.

See all Topics

Friday, March 31, 2017

Command Line

Control Line

"The Windows command line is a mainstay for systems administrators and power users but is relatively unknown to many PC users. The purpose of this site is to make the power and utility of the command line more familiar to a wider community of computer users. Also under-appreciated are the related resources of batch files and scripts and these will be discussed as well."

See all Topics

Thursday, March 30, 2017

Sound Throughout


You can set up sound to run throughout your show, music or narration.
(Included on this link is a list of free music locations)

See all Topics

Wednesday, March 29, 2017

Signature Tutorial

Sign it

"Create your own signatures using text, hyperlinks, pictures, or even an Electronic Business Card.
Use your signature in every message or just when you want to.
Create different signatures for your different roles or e-mail accounts and switch between them to suit your needs."

See all Topics

Tuesday, March 28, 2017

CSS Basics


Cascading Style Sheets can help to unify site design.
Here are some tips:

See all Topics

Monday, March 27, 2017

Stacked Columns

On on another

Instructions how to put one column on top of another in a chart.

See all Topics

Sunday, March 26, 2017

Open with Google

And you want to do this why?

"Google has added the functionality to make its office apps (Docs and Spreadsheets) the default application to open word documents and spreadsheet files, either for files downloaded from the Internet or local files on your computer, or both."

See all Topics

Saturday, March 25, 2017

Animated Forms

Add action

"Publishing your Access forms on the Web? Add some fun with animated images! For example, say you want to publish a form that allows your users to enter a keyword that will search your software catalog for winter specials; to illustrate this, you’ve embedded an image of two boys hitting the a puck with their hockey sticks."

See all Topics

Friday, March 24, 2017

Calculating Time

Using EditTime field

Word keeps track of the time you spend editing. You can use this to figure out how to bill your time.

Paul McFedries

See all Topics

Thursday, March 23, 2017

Hints and Tips

For Windows

A number of suggestions to use with Windows.

Ramesh Srinivasan
Microsoft MVP, Windows Desktop Experience

Ramesh's Site

See all Topics

Wednesday, March 22, 2017

Hints and Tips

more ideas

  • Customize the Ribbon
  • New Shape Tools
  • Media Triggered Animations
  • Video across slides
  • Where did the stretch animation go?
  • Animated text in circle (2007 / 2010)

See all Topics

Tuesday, March 21, 2017

Steps to Take

Keep it up

TechRepublic presents 10 things you can do to keep Outlook running.

10 Things to Do

See all Topics

Monday, March 20, 2017



If you have a task with an app that you find yourself repeating, make a template.
Here are some suggestions.
Bottom line: don't do it twice if you can template it once.

See all Topics

Sunday, March 19, 2017

Dynamic Charts

Keep on changing

Instructions and examples of charts that change as the data changes.

See all Topics

Saturday, March 18, 2017

PPT from Access


"Create a PowerPoint slide presentation from scratch using Access data. In addition, display and control a slide show from within an Access form. Walk through the solution and explore ways to extend the sample for your own applications."

See all Topics

Thursday, March 16, 2017

Speed up your Macro

Wha's a macro?

"The purpose of this column is simply to provide information to anyone interested in how to make their work life more efficient through the use of macros. When your average computer user finds out that macros are all about little bits of code, the fear in their hearts becomes palpable, all the way from here. And so today I want to ease those fears and invite those of you who've been curious about macros to take the plunge and finally learn about them."

See all Topics

Countdown Timers

Please sit down

To get your audience to settle down before you start or for breaks, you can create a timer slide that counts down the seconds or minutes before you begin.
Here are step by step instructions and links to other timers.

See all Topics

Wednesday, March 15, 2017

Moving Day

Transfer Outlook

A new machine and old Outlook data; how to combine the two.

Step 1: Get Files from Old Computer
Step 2: Put Files on New Computer
Step 3: Create a Profile
Step 4: More Settings
Step 5: Add Old Data File (*.PST)
Step 6: Finishing Touches
Step 7: Signatures & Stationery (and custom dictionary)

See all Topics

Tuesday, March 14, 2017

Bullets and HTML

Some code

Bullets aren’t too difficult to create using HTML.







Here’s an article that goes into more detail:

See all Topics

Monday, March 13, 2017

Why Pie Charts

Why Pie?

"The popularity of pie charts is a bit of a mystery. The data visualization goals of a pie chart can easily and more effectively be shown with a bar chart or even a simple table. In the worst of cases, a whole pie chart is used to show a single number."

See all Topics

Sunday, March 12, 2017

Long Bets

Take a chance

The purpose of Long Bets is to improve long–term thinking. Long Bets is a public arena for enjoyably competitive predictions, of interest to society, with philanthropic money at stake. The Long Now Foundation furnishes the continuity to see even the longest bets through to public resolution. This website provides a forum for discussion about what may be learned from the bets and their eventual outcomes.
  • By 2060 the total population of humans on earth will be less than it is today.
  • By 2020, bio-terror or bio-error will lead to one million casualties in a single event.
  • By the year 2020 solar electricity will be as cheap or cheaper than that produced by fossil fuels.

See all Topics

Saturday, March 11, 2017

Access Forum II

Answers and samples

"The premier Microsoft Access help forum with Visual Basic, SQL Server, Office and more! Members are able to post questions and help others with problem solutions. UtterAccess has been seen in over 160 countries, recording over 825,000,000 hits to date. Microsoft Access Tables, Queries, Forms, Reports, Pages, Macros,'ll find all the free samples and answers here!"
Utter Access

See all Topics

Friday, March 10, 2017

Click and Type

Custom fields

It’s often useful to create “click-and-type” text placeholders. The idea is that you click the placeholder, and then you type the required text.

See all Topics

Thursday, March 09, 2017

Simple-Safe Passwords

Memorable and protective

A new approach does away with the need for long strings of letters and numbers.

See all Topics

Wednesday, March 08, 2017

How to Prepare

Steps to a show

Microsoft has provided a roadmap to building a PowerPoint presentation.

Office Microsoft

See all Topics

Tuesday, March 07, 2017

Find Features

Hidden, but not forgotten

Take a look here if you can’t find your favorite feature.

See all Topics

Monday, March 06, 2017

Low Down Footer

CSS code

How to create a CSS footer that remains at the bottom of the page, regardless of content.

See all Topics

Sunday, March 05, 2017

Saturday, March 04, 2017


So far to go

Here's how to inset an overbar or macron, Ā, in Word.


See all Topics

Friday, March 03, 2017

Getting Started with Access

2010, but still good

A new look and new features designed to help you get your work done more easily than ever. You'll see differences right away, starting with the Getting Started with Microsoft Office Access.

See all Topics

Thursday, March 02, 2017

Limit MRU

choose a number

Click on the "Office" button (File in 2010).
Choose "PowerPoint Options".
Click the "Advanced" entry in the left column.
Under "Display" enter "0"
Click "OK"
The list will be erased. No entries will be displayed under MRU
If you go back you can re-enter a number and PP will start list files
from that point on.

See all Topics

Wednesday, March 01, 2017

Second Sort

Different criteria

Add a secondary sort column to an Outlook sort.

See all Topics

Tuesday, February 28, 2017

Monday, February 27, 2017

Sunday, February 26, 2017

Snow Flakes


Your online guide to snowflakes, snow crystals, and other ice phenomena ...


See all Topics

Saturday, February 25, 2017

Count Unique

Distinct entries

A common query is needed to determine the number of different items in a data base. Here is the code:


See all Topics

Friday, February 24, 2017

Charts and Tables


Word 2007-13 handles charts in a different manner than previously. The Excel Charting program is used instead of MSGraph.

Word Ribbon Tips

See all Topics

Thursday, February 23, 2017

Reliability Monitor

Track the behavior of your system

"This utility provides you with a canned set of preconfigured counters that you can easily use to monitor the reliability of your system over time. An overview of Windows Reliability Monitor and show you how to use its System Stability Chart to track the behavior of your system over its lifetime."

Windows 10

See all Topics

Wednesday, February 22, 2017

Sliding Slide Show


  • The Push Left slide transition
  • A background with no vertical borders
  • One or two continuous horizontal lines
  • Other optional horizontal elements

See all Topics

Tuesday, February 21, 2017

Resolve Names

CC search

”When you have more than one Contacts folder or address list enabled as an address book Outlook will use the folder when it resolves names provided it's on the check names list.

When you type a name in the To, CC or BCC fields, Outlook begins searching in the address list at the top of this list and works its way down the folders on the list, until it finds a match. For example: if you type Bill in the To field and have Bill Smith in the first contacts folder and Bill Jones is in the second folder on the list, typing just Bill will resolve to Bill Smith. You'll need to type Bill J to resolve to Bill Jones, or reorder the list.

If names in the address book are not resolving, open the address book
(Ctrl+Shft+B) and look on its Tools, Options menu. If the contacts folder is not listed in the 'When sending mail, check names using these addresses in the following order:' dialog, you'll need to click Add to add it to the list.”
Diane Poremsky

See all Topics

Monday, February 20, 2017

Sunday, February 19, 2017

Formatted Input Boxes

Use text boxes

"You can use a Data Validation Input Message to display a message when a cell is selected. However, the font can't be changed, nor can message box size be controlled.

To overcome these limitations, you can create a text box to display the message, and use programming to make it appear if cells that contain a data validation Input Message are selected."

See all Topics

Saturday, February 18, 2017

First Aid

Do it yourself

Got a foreign object in your nose? The Mayo Clinic has some advice on First Aid.

See all Topics

Friday, February 17, 2017

Grouping in Sections

Enhance grouping in your Access reports

Discover a quick way to put these groups in sections and then enhance these sections by providing summary details about the group.

See all Topics

Thursday, February 16, 2017

Style Sets

Formatting collections

Here is a tutorial about Style sets. You can develop and reuse your own collection of font/attribute choices.

How to use:

See all Topics

Wednesday, February 15, 2017

Shuffle Windows Media Player

Sort repeat

You have control over how Media player shuffles, repeats, and sorts content.


See all Topics

Tuesday, February 14, 2017


How to even in earlier versions

Sandra Johnson demonstrates how to create reflections in PowerPoint. 2007-13, of course, but also in earlier versions.

See all Topics

Monday, February 13, 2017

Calendars on line

Available to all

You can publish a calendar to Office Online. People that do not have Outlook can still view the team calendar using the Office Online web site.

See all Topics

Sunday, February 12, 2017

CSS Menus

For the coder

Alan Gresley from Australia has an interesting site that includes the CSS code to create menus. One of the styles is called "Sons of Ursidae Menus".

See all Topics

Saturday, February 11, 2017

Friday, February 10, 2017

Color in Access

Not dull

You can now use more than 16 colors in your datasheets.
You can pick any colors you want for gridlines, background and alternate background.
New themes and more color control in 2007+.

See all Topics

Thursday, February 09, 2017

Language Formatting

Spell Check

When you use another language in your document, the spell checker will find errors in the text.
To avoid that, format the words with a language style.

See all Topics

Wednesday, February 08, 2017

Excel to PPT

And Access

This example shows how to place the VBA code in PowerPoint, retrieve data from Excel and or Access and display it in a PowerPoint table.

See all Topics

Tuesday, February 07, 2017

YouTube Time Link

To the second

You can link directly to a specific time in a YouTube video. All you have to do is add a #t= anchor to the end of the URL that indicates the time position in minutes and seconds.

Here are the instructions:

See all Topics

Monday, February 06, 2017

Saturday, February 04, 2017

Cut the Shortcut Arrow

Clean icons

If little things bother you, try this suggestion to remove the arrow that appears on shortcut icons.

See all Topics

Friday, February 03, 2017

YouTube on a Slide

Good trick

YouTube is a treasure chest of material. This link shows how to add a YouTube video to your PowerPoint presentation.

See all Topics

Thursday, February 02, 2017

Storage Option

Alternate method

Sent mail can be stored with original message.

See all Topics

Tuesday, January 31, 2017

Code Copy

Excel to Word

You can select, copy, and paste to put Excel data into a Word document, but this piece of VBA automates to process.

See all Topics

Monday, January 30, 2017

Tag a Collection

Basic naming and tagging protocol

Here are some suggestions about indexing a collection. In this case pictures on Flickr.

Deciding on classifications and inputting the tags is the hard part. Once all of the tags are in place your collection is searchable, and you can make sets based on any of the criteria used.

See all Topics

Sunday, January 29, 2017

Drag Query to Word

Drop in

Rather than duplicate the effort, an Access query can be dragged into a Word document.

See all Topics

Saturday, January 28, 2017

Quick Parts


Word 2007+ uses the term Quick Parts for Building Blocks.
You can use any kind of content, including pictures, tables, document properties, hyperlinks, and more to create a building block.

See all Topics

Friday, January 27, 2017

Autoshapes to Pictures


You can, sometimes, do more with AutoShapes if you change them into Pictures.
Scaling and formatting choices are different with pictures.

See all Topics

Thursday, January 26, 2017

Exclude Words

Not every one

Outlook 2007+ uses Word as a Spell Checker. Here’s how to omit certain words from the process. One reason might be to exclude words that are spelled correctly, but are really typos. One example might be Public and Pubic.

See all Topics

Tuesday, January 24, 2017

Custom Functions

Write your own

Excel allows you to create your own functions. If =SUM() is not enough for you, look at this link:

Custom Functions - User Defined Functions

See all Topics

Monday, January 23, 2017

One Summer America, 1927

EVERYTHING happened in the Summer of 1927!

by Bill Bryson

"It’s amazing what a talented writer at the top of his game can do with a seemingly narrow topic. The title of Bill Bryson’s latest sums up the simplicity of his task: to document the “most extraordinary summer” of 1927, beginning with Charles Lindbergh’s successful flight across the Atlantic. 

Even though we know many of these stories--Lindbergh’s flight, Babe Ruth’s 60-homerun season, the Mississippi River flood, Al Capone’s bullet-ridden reign over Chicago--in Bryson’s hands, and in the context of one amazing summer of twentieth-century ingenuity and accomplishment, they feel fresh, lively, and just plain fun. The book is so jammed with “did you know it” nuggets and fascinating origin stories (the opening of the Holland Tunnel, the first Mickey Mouse prototype, the source of the term “hot dog”), the effect is like sitting beside a brilliant, slightly boozy barstool raconteur, who knows a little bit about everything

From a tabloid murder trial to a flagpole-sitting record to the secret origins of the looming Great Depression, One Summer offers a new look at a transitional period in history, re-introducing us to such characters as Capone, Jack Dempsey, Al Jolson, Charles Ponzi, and Herbert Hoover. Ultimately, this is a book about the moment when important things, for good or ill, began happening in the US. With a giddy narrative voice and keen eye for off-kilter details, Bryson has spun a clever tale of America’s coming of age." --Neal Thompson

See all Topics

Sunday, January 22, 2017

Healthy Computing

10 tips

Neck hurt? Wrists ache? Back pain?
Here are some suggestions.


See all Topics

Saturday, January 21, 2017

Access FAQ

What's to know

Some interesting questions answered. Links are included for more detail.


See all Topics

Friday, January 20, 2017

Make Templates

How to

This link tells what you need to know to create templates for your own or organizational use.

See all Topics

Thursday, January 19, 2017

Background Sound

All the way through

In some circumstances you may want music to play throughout the presentation.

See all Topics

Wednesday, January 18, 2017

Lines next to response

Choose your mark

Don’t like those vertical lines next to an e mail response?

See all Topics

Tuesday, January 17, 2017

Blog Control


Using CSS on Blogs is not difficult. Here is a site that shows how to do many things including using different background images for different times of day.

See all Topics

Monday, January 16, 2017

Need a Doctor?

Look up site

”Celebrating its 20th Anniversary in 2016, the AIM DocFinder was the only online physician directory of its kind when it was launched in 1996. The DocFinder is still recognized for its easy to use search engine. DocFinder remains the only combined database of all licensing jurisdictions that has its direct source of data from and controlled by state licensing boards and remains free of charge to the public.”

See all Topics

Sunday, January 15, 2017

Auto Space Controls

Even it out

Access' automatic control spacing feature easily adjusts the horizontal or vertical distance between controls. Learn more in this tip.

See all Topics

Saturday, January 14, 2017

Line Numbers

Count them all

  1. In Word, click Page Layout (File > Page Setup).

  2. Click Line Numbers.

  3. Choose Line Numbering Options.

  4. Click Line Numbering . . . .

  5. Put a check in the box labeled "Add line numbering."

  6. Set "Start at" to 1, "From text" to "Auto," and "Count by" to 1.

  7. Under "Numbering" select "Restart each page."

  8. Click OK.

  9. Click OK.

  10. Make sure you're looking at Print Layout.

See all Topics

Friday, January 13, 2017

Edit Control Panel

Add items

”Have you ever wondered where the Display Settings icon or Network Connections folder went in the Control Panel’s Classic View? For that matter, why can’t you search for them using the start menu search? Because they are prohibited from loading in the registry - that’s why.”

See all Topics

Thursday, January 12, 2017

PPT Photo Album


How to use PowerPoint to create a photo album.
In this article:

Step 1 – start a photo album
Step 2 – insert pictures
Step 3 – create the album layout
Step 4 – create titles and subtitles
Step 5 – format pictures
Step 6 – edit the photo album

Create a photo album in PowerPoint in 6 steps

See all Topics

Wednesday, January 11, 2017

Increase DLs

More bits

This is a registry hack that controls the number of downloads you can have at one time.

See all Topics

Tuesday, January 10, 2017

Mail a Range

Combine Excel and Outlook

"The subs will send a newly created workbook with just the visible cells in the selection or range.
The cells will be PasteSpecial as values in the workbook you send. 
It saves the workbook before mailing it with a date/time stamp. 
After the file is sent, the workbook will be deleted from your hard disk."

See all Topics

Monday, January 09, 2017

How to Lace Shoes

Two trillion Ways

Forget about Velcro. Here are 33 illustrated ways to lace your shoes.

See all Topics

Sunday, January 08, 2017

Change Splash

Make it your own

A splash screen appears when you start Access. Here is how to customize what is displayed.

Adding Splash

See all Topics

Saturday, January 07, 2017

Barcodes in Word

Print your own

Printing bar codes in Microsoft Word documents.



See all Topics

Friday, January 06, 2017

Time to Dump PowerPoint

Presentation questions

"One of the findings mentioned in the article: it is more difficult to process information if it is coming at you both verbally and in written form at the same time."

See all Topics

Thursday, January 05, 2017

Hold Back the Mail

Timing is everything

Outlook allows you to choose when your mail is sent. For instance, set up a birthday greeting ahead of time so you will not forget it.

See all Topics

Wednesday, January 04, 2017

CSS Templates

Free samples and suggestions

"Solucija offers a selection of some of the most popular web templates available today. Whether you're looking for a free web template, premium one, or an inspiration - you'll find it here. All our templates are hand coded, standards compliant and can be easily used as a standalone templates or in combination with CMS to create a fully dynamic site."

See all Topics

Tuesday, January 03, 2017

Spreadsheets in Education

Samples and papers

"SIE is an electronic journal devoted to the publication of quality refereed articles concerned with studies of the role that spreadsheets can play in education. Our aim is to provide a focus for advances in our understanding of the role that spreadsheets can play in constructivist educational contexts.
Spreadsheets in Education (eJSiE) is a free facility for authors to publish suitable, peer reviewed articles and for anyone to view and download articles."


See all Topics

Monday, January 02, 2017

Sgt. Pepper

If you're old enough

The Oxford Dictionary presents an interactive version of the cover.
Oxford Dictionary of National Biography

See all Topics

Sunday, January 01, 2017

Package up Runtime

Runtime solutions

"The Package Solution Wizard provides a simple way to bundle and deploy Office Access 2007-13 database applications. The wizard guides you through the steps that are required to bundle stand-alone Access 2007-13 applications into deployment packages. You can use the Package Solution Wizard to include the Access 2007-13 Runtime in your packages and to create shortcuts that start the appropriate Access file. The output of the Package Solution Wizard is a Windows Installer (.msi) Setup file that guides users through the installation of your Access application."

2013 Runtime

See all Topics