Zap unwanted formatting in Word
You can spend a lot of time formatting content in a Word document and then even more time trying to get rid of it!
Print gridlines and headings in Excel
A printout of data can be more useful if you print gridlines and column and row headings. The gridlines help keep you on track.
Tags: Microsoft Office, Microsoft Corp., Microsoft Excel 2007
Compress pictures to reduce the size of your PowerPoint presentation
While pictures improve the Powerpoint presentation's appeal, they increase the file's size.
Tags: Microsoft Office, Name, Presentation
Use a nonbreaking space to keep words together
Learn how to keep two words together when they happen to fall at the end of the line and Word pushes the last name to the next line.
Tags: Microsoft Office, Microsoft Corp., Backup
Quickly delete every nth row in Excel
Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.
Tags: Microsoft Office, Row, Column
Microsoft Access 2010 new feature overview
Here are some of the new features you can expect to see in Access 2010, including a Web-ready format and an improved macro environment.
Tags: Microsoft Office, Row, Database
Nudge paragraphs in a Word document
Sometimes you need just a little more space before a paragraph. You have to update the style to reflect a little more space before or after each paragraph.
Tags: Microsoft Office, Formula, Microsoft Corp.
Display hidden data in an Excel chart
By default, Excel displays only visible data in a chart. Consequently, if you hide worksheet data, Excel won't display that data in a chart.
Tags: Microsoft Office, Database, Option
How to display pictures that appear to be partially hidden
Sometimes, an in-line text picture doesn't display completely--you can see just the bottom of the image. Find out what you can do to correct the problem.
Tags: Microsoft Office, Slide, Cell
A quick method for counting Access records in a form
There are several ways to count the records in a form's recordset. In fact, Access forms display the record count by default.
Tags: Microsoft Office, Method, File
Use VBA to find hidden Excel sheets
If you have hidden sheets in Excel, it might be helpful to programmatically manipulate those sheets.
Tags: Microsoft Office, Document, File
10+ keyboard shortcuts for entering special characters in a Word document
If you prefer to enter special characters yourself on a case-by-case basis, it's handy to know a few keyboard shortcuts.
Tags: Microsoft Office, keyboard shortcut, keyboard
10+ things that are broken in Access 2007
If you switch to Access 2007, you'll encounter more than just a radical new interface--some things are just plain broken. See what you can hotfix and what you'll have to live with.
Tags: Microsoft Office, Field, Slide
Copy hundreds of rows of Excel formulas in three steps
Copying formulas in Excel is relatively simple, unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof trick to get it done.
Tags: Microsoft Office, Cell, Real Estate
How to use the At and Ln indicators in Word's status bar
At and Ln are used in automating special format requirements. Here's what you need to know.
Tags: Microsoft Office, Form, Cell
Use Access Office Links tool to convert a report to an Excel worksheet
Here's a quick and easy trick for getting your Access report data into Excel--organized just the way you want.
Tags: Microsoft Office, Option, Tool
Calculate a conditional running total in Excel
A straight running total may be all you need to stay on top of a series of Excel values but sometimes, you have to accommodate special conditions to get useful results. Here's how.
Tags: Microsoft Office, Value, Graphics
The 10 most useful Word shortcuts
How many Word shortcuts do you remember and use on a regular basis? Fifty? Twenty? How about just 10 solid go-to shortcuts?
Tags: Microsoft Office, Positioning, Tool
Fill Word form fields with Access data
When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process.
Tags: Microsoft Office, Table, Form
Prevent duplicates when entering data into Excel
Duplicate values, when not valid entries, return erroneous summaries and totals. Here's what to do to prevent duplicates in a specific range using Excel's Validation feature.
Tags: Microsoft Office, MsgBox, Entry
Quick sort for Word lists
Sorting lists with text, numbers or dates in Word isn't exactly intuitive, but here's what you need to know to get it done quickly.
Tags: Microsoft Office, Tools Menu, Microsoft Excel 2007
