Does anyone know how to print a budget without the "Actual" and "Difference" columns?
pjdubman
Quicken Windows Subscription Member ✭✭
I'm trying to print just the budget column
0
Best Answer
-
After pressing Ctrl + P, choose Export to:, select Tab-delimited (Excel compatible) text file in the pull-down menu and Export. You may then import the file into the spreadsheet program of your choice and manipulate the format to your liking.pjdubman said:Yes, thank you.
Do you know if there is an option to just print the Summary column. I can only seem to print all months with summary and it uses too much paper even in landscape orientation.
5
Answers
-
Open the budget, select Annual view and Budget only from the pull-down menus, and press Ctrl + P.0
-
Yes, thank you.
Do you know if there is an option to just print the Summary column. I can only seem to print all months with summary and it uses too much paper even in landscape orientation.0 -
After pressing Ctrl + P, choose Export to:, select Tab-delimited (Excel compatible) text file in the pull-down menu and Export. You may then import the file into the spreadsheet program of your choice and manipulate the format to your liking.pjdubman said:Yes, thank you.
Do you know if there is an option to just print the Summary column. I can only seem to print all months with summary and it uses too much paper even in landscape orientation.
5 -
This option only seems to export in a text file and therefore cannot be imported into an Excel spreadsheet. What am I doing wrong?0
-
If you haven't already, you may want to review: https://support.office.com/en-us/article/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393bapjdubman said:This option only seems to export in a text file and therefore cannot be imported into an Excel spreadsheet. What am I doing wrong?0 -
@pjdubmanSherlock said:
If you haven't already, you may want to review: https://support.office.com/en-us/article/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393bapjdubman said:This option only seems to export in a text file and therefore cannot be imported into an Excel spreadsheet. What am I doing wrong?
Along with what Sherlock gave you for how to import text file in Excel there is a "trick" in Quicken's export too.
In the Print dialog, on the Export to: menu there are three choices.
Text file
tab-delimited (Excel compatible) disk file
.RRN (123-compatible) disk file
The tab-delimited file is will work better than the "Text file", but you will still need to go through the same dialogs in Excel to tell it is tab-delimited.
The trick is that .PRN format is actual CSV.
So if you print to that format, and just change the name so ends in .csv instead of .prn. You can open it directly into Excel or any other spreadsheet program.
I wish the developers would change it because no one uses .PRN any more, but LOTS of people use CSV.
Using Quicken Subscription Premier (and have a copy of Starter to test things on)0
This discussion has been closed.
Categories
- All Categories
- 56 Product Ideas
- 36 Announcements
- 225 Alerts, Online Banking & Known Product Issues
- 22 Product Alerts
- 703 Welcome to the Community!
- 671 Before you Buy
- 1.2K Product Ideas
- 53.7K Quicken Classic for Windows
- 16.3K Quicken Classic for Mac
- 1K Quicken Mobile
- 812 Quicken on the Web
- 111 Quicken LifeHub
