Navigator User Forums
  Formatting Reports
  Account names indented

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Account names indented
FN_User
Member
posted 03-27-2009 12:04 PM     Click Here to See the Profile for FN_User     Edit/Delete Message
Account names are indented on income statements and balance sheets. This looks nice, but when I export to Excel it makes it hard to sort and otherwise manipulate. Can you make a report that doesn't indent?

IP: Logged

David
Administrator
posted 03-27-2009 12:18 PM     Click Here to See the Profile for David     Edit/Delete Message
You can turn off indenting, but only for 12-month reports.
  1. Select 12 Month Income Statement, 12 Month Balance Sheet, or any other 12-month report.
  2. Select Options.
  3. Select Indent Names (12 Month) to remove checkmark.
  4. Run report. Account (and Category) names are no longer indented.
A later version of Navigator may allow you to turn off indenting for other reports besides 12-month reports.

Meanwhile, you can also remove the indenting in Excel using Find & Replace:

  1. Open the report in Excel.
  2. Select Find & Select | Replace (in Excel 2008. Your mileage may vary).
  3. Type eight blank spaces in Find what:.
  4. Select Replace All.

- David
FNI Technical Support
Case #38-10988

[This message has been edited by David (edited 03-27-2009).]

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e