Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How to re-size a Balance Sheet template??

I'm using Microsort Exel 2003, which have a balance sheet template, I can add
lines to make it bigger in pages, but when I go to print my work, the borders
around the balance sheet does not fit to a normal sheet of paper. If I
change the margins on the side, it automatically add more pages and seperate
the colums. I would like to have the sheet that I'm working with print to the
size of the paper and not have the document printed smaller than the sheet of
paper.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 207
Default How to re-size a Balance Sheet template??

Issac F,
Did you try this:
Once you have the workbook set with all the information that you want.
Select "View", "Page Break Preview".
You will get a warning on making changes, select "OK".
Move the solid blue lines to include all new cells, move any dashed lines to
solid blue lines to remove them.
You should end up with a single blue square around all the cells.
Doing it this way means you don't have to do trial and error to get the
right percent size to get all data.
Save the file, then select "View" , Select "Normal".
That should do it for you.
hth


"Isaac F" wrote:

I'm using Microsort Exel 2003, which have a balance sheet template, I can add
lines to make it bigger in pages, but when I go to print my work, the borders
around the balance sheet does not fit to a normal sheet of paper. If I
change the margins on the side, it automatically add more pages and seperate
the colums. I would like to have the sheet that I'm working with print to the
size of the paper and not have the document printed smaller than the sheet of
paper.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Template for Balance sheet Chimo New Users to Excel 2 April 15th 09 07:03 PM
what's the easiest way to common size a balance sheet poke Excel Worksheet Functions 0 May 30th 06 08:38 PM
USING THE BALANCE SHEET TEMPLATE, ANY WAY TO EXPAND? RABBITS Excel Worksheet Functions 1 July 27th 05 06:37 PM
how can i add lines to the balance sheet template RABBITS Excel Discussion (Misc queries) 0 July 27th 05 06:30 PM
Values in 'Balance sheet' template are in $ I want £ but there is. amulcrone Excel Discussion (Misc queries) 2 December 2nd 04 08:05 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"