Academic journal article Journal of Accountancy

A Better Solution: Custom-Print Views in Excel

Academic journal article Journal of Accountancy

A Better Solution: Custom-Print Views in Excel

Article excerpt

When a reader asked how to create a group of custom views of a spreadsheet (JofA, Jul.04, page 96), I suggested he give each section of the worksheet a unique name, which can be recalled by selecting it from the Name Box# drop-down list. But Joey Brannon, CPA, of Bradenton, Florida, reminded me of a better solution.

By using Custom Views (View, Custom Views)# you can create many custom snapshots and also temporarily customize a section of a spreadsheet, give that view a name, show or print it and then return the format to its original state.

For example, start with this section of a spreadsheet:

First I want to show and print the results of all four quarters and the fiscal year; then I want to show and print only the third and fourth quarters and the fiscal year. Begin by highlighting the section that displays all four quarters and click on View#, Custom Views#, evoking this screen:

Click on Add#, and in the space below Views# type a name for it: Full year**.

Now hide the first- and second-quarter results (using Data#, Group and Outline#, Hide Detail#) and highlight the newly formatted image. …

Search by... Author
Show... All Results Primary Sources Peer-reviewed

Oops!

An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.