Microsoft Word 2007
36 Stories
Easy parallel columns in Word
Techguide Newspaper columns are easy to create in Word, but parallel columns can be troublesome. The solution? Use Word tables.
Tags: Microsoft Office, Microsoft Corp., Column, C, Borders Books & Music, command button, Michigan, vbCrLf, e-mail, Microsoft Excel
Make your Access forms run faster
Techguide By giving a form less data to digest, you can make it run more efficiently. These two tricks can help.
Tags: Microsoft Office, Microsoft Corp., Form, data entry, Mail Merge, performance, Microsoft Excel, Microsoft Word 2007, Microsoft Access, Illinois
Use Excel's DGET function to zero in on information you need
Techguide You can save your users considerable time--and eyestrain--by setting up a handy formula that tells Excel to display a specific cell entry for them.
Tags: Microsoft Office, Microsoft Corp., Cell, Database, data entry, font, Tools Menu, Ctrl, DGET, Replace
Open-source tool creates OOXML docs for the blind
News Microsoft has helped develop an audio file format called Daisy that translates Word files into a 'talking' digital book format, making documents more accessible for users with impaired vision.
Tags: Open source, Corporate responsibility, Disability, Office Open XML, Tool, Australia, consortium, software, business development, vision
Use Access Office Links tool to convert a report to an Excel worksheet
Techguide 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, check box, shortcut menu, Microsoft Excel, Microsoft Word 2007, Microsoft Access, Microsoft Office, Microsoft Word
Move text to the next column permanently
Techguide Word may not be a full-featured layout program, but it does offer some tools that let you control the position of text on a page. Here's how to use a column setting to get text where you want it.
Tags: Microsoft Office, Column, Box, C, Database, check box, phone, Microsoft Excel, Microsoft Word 2007, Microsoft Access
Create a watermark using a Clip Art Gallery image
Techguide You can use the Printed Watermark dialog box to add a custom watermark to your document, but Word also lets you create a watermark from any graphic object by copying the image into the Header window.
Tags: Microsoft Office, Microsoft Corp., C, clip art, font, Microsoft Excel, Microsoft Word 2007, Microsoft Access, spreadsheet, Microsoft Office
Hide the Ribbon programmatically in Access and Excel 2007
Techguide All of the Office 2007 applications sport the infamous Ribbon. Unfortunately for developers, the Ribbon object isn't as easy to control as its earlier counterpart, the command bar object.
Tags: Microsoft Office, Microsoft Corp., Mouse, Microsoft VBA, Microsoft Excel 2007, software, Microsoft Excel, Microsoft Word 2007, Microsoft Access, spreadsheet
Two ways to return a unique list in Excel
Techguide Filtering data to produce a unique list of entries is a common task in Excel. Here are two methods of getting the job done: manually and with a bit of VBA automation.
Tags: Microsoft Office, Microsoft Corp., Data, List, Cell, Database, AdvancedFilter Method, Default Value, Mouse, Microsoft VBA
Add information from related tables to your Access totals queries
Techguide Totals queries can be a little limited in the information they include. Here's a trick that will make them a little more useful.
Tags: Microsoft Office, Microsoft Corp., Field, Products Tests, Database, database window, product id, Design, Microsoft Excel Use Excel, Microsoft Word 2007
Space controls evenly across an Access form
Techguide Access offers a handy command that makes it easy to give your forms a more polished look. See how equally spacing controls can improve the effect.
Tags: Building Block, Document, Feature, Goto, F5 Networks Inc., Figure E, Figure B, Figure C, Figure D, Microsoft Excel
Use an Excel command to quickly separate first and last names
Techguide If you need to split a list of names into two columns, you don't have to do it manually. See how this Excel wizard can quickly knock out the task for you.
Tags: Microsoft Office, Microsoft Corp., Column, Dirty Property, check box, Microsoft VBA, Microsoft Excel 2007, Figure F, Microsoft Excel, Microsoft Word 2007
Create an online form with a Word table
Techguide Tables provide a simple, effective structure for your online forms. Here's a look at how to use a table to set up blank lines that will stay put when users fill out your forms online.
Tags: Microsoft Office, Microsoft Corp., Box, Form, Cell, Borders Books & Music, SQL, Figure, Figure E, Microsoft Excel
Toggle between date values and serial values in Excel
Techguide When working with time and date values, it can be beneficial to know a value’s serial value. Fortunately, Excel makes it easy to take a quick peek.
Tags: Microsoft Windows, Microsoft Corp., Box, font, Ctrl, Microsoft Excel, Microsoft Word 2007, leader, toolbar, Microsoft Access
Where is the AutoFormat As You Type feature in Word 2007?
Techguide Word 2007 has relocated those handy AutoCorrect options, which can be disorienting. See where to find them, or simply add buttons to the Quick Access Toolbar to toggle the options you need.
Tags: Microsoft Office, Microsoft Corp., C, Quick Launch, Tool, Button, check box, Microsoft Excel, Microsoft Word 2007, Microsoft Access
