help with excel

youdsy

youdsy

youdsy

Soldato
Joined
14 Feb 2011
Posts
2,740
hia i need help.

m trying to print out a timetable for my project but the dates print out as #####

wsntif.png


and here is waht it prints out as:

4iorbt.png


any idea whats going on??

thanks.
 
you usually see ### when cells aren't big enough to show all the content. although your worksheet looks ok, i'd try increasing the height of row 1 to see if that helps.
 
marc2003 said:
you usually see ### when cells aren't big enough to show all the content. although your worksheet looks ok, i'd try increasing the height of row 1 to see if that helps.
Click to expand...

Second that.

If you double click the divide between row 1 and 2 it should auto-set the required size for you.
 
got it sorted now.

fiddled with margin size and changed font size.

cheers

really should go on a course to get my skills up to par.
 
youdsy said:
i dont have a clue what im doing if im honest.

such a noob when it comes to excel.
Click to expand...

hover you mouse over the line that separates 1 & 2 in the left hand column. you should see pointer change. now just drag down to increase the row height.

edit: you already sorted it... :p
 
That Gantt Chart looks like a right faff on if you're regularly changing dates and such.

I've built a mechanism for creating Gantt charts in Excel where you can enter start and end dates and add in dependencies on other tasks if you're interested?
 
wesimmo said:
That Gantt Chart looks like a right faff on if you're regularly changing dates and such.

I've built a mechanism for creating Gantt charts in Excel where you can enter start and end dates and add in dependencies on other tasks if you're interested?
Click to expand...

MS Project is also great for this, if you have access to it!
 
You must log in or register to reply here.
Back
Top Bottom