Information management and technology assurance

Here’s a tip sent by reader Mike Hendricks, CPA, cost accounting manager of Yarnell Ice Cream Co., Searcy, Ark.: If you have a range of data you need to keep together—for instance, a lookup table—you can anchor it without using dollar signs, such as in $A$1:$Z$50 . Do this instead:

We have something like 75 different spreadsheets containing various studies and reports circulating in the office at any one time. While it’s usually possible to identify each author because of the subject, I’d like some easy way to label each file without putting the information directly in the worksheet. Any

Should you turn off your computer at day’s end? This question is being hotly debated in my office. The split seems to be between those who drive gas guzzlers and those with economy cars. You are raising a much bigger issue than energy conservation. You surely save electricity by turning

Key to Instructions To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type shows the names of files and the names of commands and instructions that users should type into

I use Word to make up multicolor brochures for my firm, then check that the makeup and colors are just right by using Print Preview . While the test image it produces is OK, it doesn’t give me quite the precision I need to feel comfortable printing several hundred copies

1 1 / 2 -line paragraph spacing: Ctrl+5 Centered paragraph: Ctrl+E Double-spaced paragraph: Ctrl+2 Justified paragraph: Ctrl+0 Left-aligned paragraph: Ctrl+L Right-aligned paragraph: Ctrl+J Single-spaced paragraph: Ctrl+1.  Stanley Zarowin, a former JofA senior editor, is now a contributing editor. His e-mail address is zarowin@mindspring.com . Do you have technology questions for

There is. But, like many Microsoft shortcuts, it’s hard to find. If you click on F1 for information you won’t find even a clue that such a shortcut exists. The icon tool operates like the keyboard shortcut, except without the mouse. Highlight the area you want the format copied and

Key to Instructions To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type shows the names of files and the names of commands and instructions that users should type into

My spreadsheets contain very long, complex formulas that are hard to read. Is there some way to break them into smaller pieces without affecting the integrity of the formula? There is an easy solution. For example, take this long formula: Wouldn’t it be easier to read if it were broken

When I started with computers in the 1980s, we had those 5 inch floppy disks—and they really were floppy. Then PCs and DOS came along with three-inch disks (and although they were still called floppies, there were no longer floppy). Now my new computer doesn’t even have a floppy slot.