Help! I hid the two top rows of an Excel file, and now I can’t figure out how to get them back because I can’t find a way to access them to reverse the Hide command. I sympathize. There is nothing intuitive about this solution, which works in Excel 2003
Advertisement
TOPICS
Information management and technology assurance
Adjust the Size of Received E-Mails
Sometimes the font of my newly arrived e-mail is so small I can hardly read it. Is there an easy way to enlarge it? Yes, but the method depends on which e-mail client or browser you use. Here are some of your choices: If you use Outlook 2007: Press the
A Measure of Success
While we wish our colleagues at Bailey & Co., Snyder & Co., Harrex Group and Kennedy and Coe LLC every success, the article “The Firm of the Future” (Nov. 08, page 68) made it difficult to determine the firms’ outcomes which, ultimately, will determine their success or failure—profitability. The only
Financial Reporting
The SEC adopted new rules that will require public companies to provide an XBRL version of their SEC filings. Under the new rules, approximately 500 of the largest U.S. public companies and foreign private issuers listed with the SEC will be required to provide financial information using XBRL beginning in
Mergers & Acquisitions of CPA Firms
Despite the best intentions of all involved parties, some CPA firm mergers and acquisitions are not as successful as originally planned; indeed, some end as failures. When viewed in perfect hindsight, it often seems that simple common sense, or lack thereof, was the reason for the success or failure of
Stop Word’s Automatic Numbering When You Start a New List
I’ve had to stop using the automatic numbering system in Word because it drove me crazy. But I really need it. Here’s the thing: Whenever I want to add a second, separate numbered list under the first list, which ends, say, with six items, Word second-guesses me and no matter
Forecasting With Excel—Illustration File
Editor’s Note: This file accompanies “Forecasting With Excel,” by James A. Weisel, which appears in the February 2009 issue of the JofA. Click here to download the illustration file of the analysis of Dave’s BBQ.
Sample Sabbatical Program Policy
Here is a sample sabbatical policy based on actual policies used by firms: 1. Eligibility. All partners with five years of service will be eligible to take a sabbatical every five years. All managing associates with seven years of service will be eligible to take a sabbatical every seven years. Partners
Converting to IFRS
The SEC’s proposed road map for the potential use of IFRS in financial statements prepared by U.S. issuers could result in the mandatory use of international standards beginning in 2014, 2015 or 2016, depending on a company’s size. Under the plan, the SEC would decide in 2011 whether to proceed
Forecasting With Excel
Your client, Dave’s BBQ, a local independent restaurant, is interested in determining the effect on sales revenue of certain advertising strategies. Dave has weekly data on advertising dollars spent as well as sales revenue from the restaurant and has come to you, his CPA, to help him determine the link
Practice Management
A survey of 2,722 CPA firms revealed strong growth during the past two-year period but less progress in succession planning and professional training. According to the 2008 National Management of Accounting Practice survey, 75% of responding firms experienced growth ranging from 1% to 19% from May 2006 through June 2008.
Uniting the Global Profession
Robert Bunting became president of the International Federation of Accountants (IFAC) in November, beginning a two-year term. Prior to this, he was deputy president of IFAC for two years and has been a member of the IFAC Board since 2005. Bunting is a partner in Seattle-based Moss Adams LLP, where
The Virtues and Challenges of a Long Break
Some people do solo retreats for personal development. Others provide volunteer services. One CPA firm partner took his two adopted children back to their homelands—Korea and Vietnam—where his 21-year-old son was reunited with his birth mother, brother and sister after 14 years, and discovered he had six nieces and nephews.
Why Can’t They Read My Word 2007 Document?
I recently switched to Vista and Word 2007 and, while I’m finally getting used to the new setup, I am having a serious intermittent problem. Here’s the thing: Sometimes when I send a memo to a client who uses Word 2003, I’m careful to configure the file in the older
Fast Way to Adjust Height and Width of Cells in Excel
When I’m working in Excel, I frequently need to adjust the height and width of a cell. I can do it with a mouse, but that means I have to shift my hand from the keyboard to the mouse. I’m beginning to realize I can be more efficient if I
Right Track Your CPA Career
Careers aimed toward excellence start with the recognition that every CPA is truly running his or her own personal firm. Whether they are in public accounting, government or private industry, everyone must make investments into their company to be successful. These investments provide extraordinary returns for the individual CPA as
Create Custom Calendars in Excel and Word
I can’t tell you how many times I’ve wished I could peek at a calendar while working in Excel to verify a date or check the timing of some transaction. Sure, I can switch to Outlook for that, but I figured since I can input a date with two keystrokes,
Another Way to Hide Desktop Shortcuts
In the November 2008 issue, page 105, I suggested ways to easily hide desktop shortcuts of confidential material. I suggested moving them off the desktop, out of sight to the Start menu, which only comes into view when you click on Start. However, I should have mentioned still another, even
Advice for Technophobes
I confess—computer technology makes me nervous. How can I overcome this silly fear? It’s a real drag. First of all, it’s not silly. It’s serious and fairly common. In this age of advanced technology, it’s a major handicap. I know accountants with this problem, and many have told me they’ve
Using IFRS to Drive Business Development
Inside the growing footprint of IFRS lies something many small and midsize CPA firms may be overlooking—rich opportunities for business development. IFRS-related work in the United States has largely been the domain of major accounting firms thus far. While national firms are filling many of the needs, there’s a large
Features
FROM THIS MONTH'S ISSUE
Create interactive dashboards with Excel PivotCharts and slicers
Leave the static spreadsheets behind. This JofA Technology Q&A article with video walkthrough provides a step-by-step guide for creating interactive dashboards in Excel that decision-makers can use.
From The Tax Adviser
January 31, 2026
Trust distributions in kind and the Sec. 643(e)(3) election
January 31, 2026
Effects of the OBBBA on higher education
December 31, 2025
