Friday 26 February 2010

Is there a way to fit all the data on one page on excel 2003? Log 2

Simply change the print settings from portrait to landscape so all data fits onto one page when printed , if this doesn't work then play with the column and row sizes making them smaller so there is more space to fit everything on the page.


Widening Columns


You probably noticed, as you typed in the numbers, some of the words were just too wide for the default cell width (Investments and Miscellaneous).  Let's widen column B to take care of this. 

Slowly move the mouse arrow to the right edge of the B cell (between the B and the C).  The cursor will turn into an arrow pointing right and left with a small vertical line in the middle (see arrow below).  Hold down the left mouse button and move (drag) the line to the right. 


 
 As soon as you start to move (drag), a dotted vertical line will go down the spreadsheet and it will move as you hold down the left button and drag the mouse. Keep dragging to the right until you are past the widest word and a bit more (for some space).  Release the button.  The column is widened.  Notice in the upper left corner of the screen, below File in the menu bar, and above the buttons, that as you hold down and drag that it tells you that current width of the column.  You can use the same process to shorten columns and make more space on your spreadsheet.

this information was found from : http://www.officetutorials.com/exceltutorials.htm





 





No comments:

Post a Comment