Microsoft Excel 2007
23 Stories
Print selected pages from different sections of a Word document
Techguide Choosing which pages to print is a straightforward process, thanks to Word's Page Range options. But if those pages belong to different document sections, you'll need to give Word a little extra guidance.
Tags: Microsoft Office, Microsoft Corp., Section, Chapter, Parameter Query, data entry, Microsoft Excel 2007, Figure, Microsoft Excel, Microsoft Access
Add a looping introduction to a PowerPoint presentation
Techguide You can set up your slide shows to include a little preview presentation that will help prime your audience for the main event. Susan Harkins shows this simple but highly effective technique.
Tags: Microsoft Office, Presentation, Slide, Template, Button, Invoice, PowerPoint Presentation, Microsoft Excel 2007, sales tax, Figure
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
Zap unwanted formatting in Word
Techguide You can spend a lot of time formatting content in a Word document and then even more time trying to get rid of it!
Tags: Microsoft Office, Microsoft Office, Customization Tool, Microsoft Excel Microsoft Excel 2010, Excel 2010, October Sale, C, Microsoft Corp., Sales, Microsoft Excel 2007
Print gridlines and headings in Excel
Techguide 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, page layout, Microsoft PowerPoint, printing, Microsoft Excel, spreadsheet, Microsoft Office
Display hidden data in an Excel chart
Techguide 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, Chart, Microsoft Corp., Tools Menu, Figure B, Microsoft Excel, Microsoft Word, technique
How to display pictures that appear to be partially hidden
Techguide 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, Training, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft Office 2007, Microsoft Excel, Microsoft Office, Microsoft Word
A quick method for counting Access records in a form
Techguide 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, Tool, Tools Menu, Microsoft Excel 2007, File Menu, Microsoft Excel, Microsoft Access, dialog box
The 10 most useful Word shortcuts
Techguide 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, Mouse, Microsoft Excel 2007, Ctrl, keyboard, Microsoft Excel, Microsoft Access, camera
Quick sort for Word lists
Techguide 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, e-mail, Microsoft Excel, dialog box, window, Microsoft Outlook, Microsoft Office, Microsoft Word
Use SUM in an array function to count values that match multiple criteria
Techguide When you need to count values based on more than one criterion, the CountIF function won't do the job. The solution: build an array formula with SUM.
Tags: Microsoft Office, Microsoft Corp., C, Cell, Sales, Tools Menu, Microsoft Excel 2007, Microsoft Excel, Microsoft Access, Microsoft Office
Prevent duplicates when entering data into Excel
Techguide 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, Microsoft Excel 2007, Microsoft Excel, job, Microsoft Access, Microsoft Office, Microsoft Word, HTML
Clear an Access combo box for entering the next record
Techguide Have Access clear the selection from a combo box in a data entry form so that you start fresh with each new record. See how to make this user-friendly tweak.
Tags: Microsoft Office, C, keyboard shortcut, Clear, Microsoft Excel 2007, e-mail, keyboard, Microsoft Excel, Microsoft Access, 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
Control where Word hyphenates a word
Techguide Follow this tip to determine where Word hyphenates your content.
Tags: Microsoft Office, Microsoft Corp., MsgBox, C, vbOKOnly, command button, Tools Menu, Microsoft Excel 2007, Microsoft Excel, Microsoft Access
Jump to
1 2
