Spreadsheets

jennihen

When I print out my spread sheet the date column is coming out as "#########"
Where have I gone wrong and how can I fix it?:)

Lancastrian

Try widening the column by grabbing the column divider (at the top of the columns) and moving it slightly to one side. That's the usual case. good luck.

jennihen

Thats not working for me so I've used 'Wk 1, Wk 2' instead of dates!!
Thanks though!!

jennihen

Hey just tried again to widen the column and it worked - Thanks so much!

david39

Also, if you double click on the column-divider at the top of the column it will automatically adjust the width of the column to whatever is necessary to display the widest entry in the column.

That's very useful when working with columns containing text or wide numbers.

googler

..or you can highlight the whole spreadsheet by clicking on the corner box to the left of A and above 1, then select Format -> Column -> Autofit Selection and all columns will be expanded or contracted to fit the largest field value within the column......

Autofit also works for smaller selections than the whole spreadsheet.