Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Bigron]

Gentlemen, I need a little help. After duelling across time and space with Excel Database, I have almost vanquished the beast!
I needed to catalogue my daily blood pressure results for my GP, which I have done, basically, but when I print the table (from which I create a chart) the framing/division lines surrounding the data do not appear.
It's fine on screen, but no borders around the data in Print Preview, hence not on the print.
I won't go into the number of ways I've tried, but they are all but the right way!

Help?
Please!

Ron.

[zirk]

Have you set the Print Area for that document?

[TheBoy]

Bloody Office self-abuser's tool. And always misused, it should only ever be used for complicated calculations, and not as a lazy arsed way of doing tables.

Rant over.  For now.

[Mister Rog]

I gave up MS Office years ago, now use Libre Office which is . . . . . . FREE !

Anyway, you need to actually put borders around the columns/rows/cell that you want to print. Probably easiest to highlight entire columns and teh rows, or even the whole sheet and the find the "Borders" tool. You can then select what kind of border you want.

 . . . . . . . .  I think                    

[Bigron]

TB, I am not too lazy do tables, but I use Excel to create charts, because I want a graphical representation of the date - shows trend more clearly.
Mister Rog, I'm sure that I've tried your suggestion.....

Ron.

[TheBoy]

I gave up MS Office years ago, now use Libre Office which is . . . . . . FREE !

I do use Office. Yes, it costs a whopping tenner, so that's 2 pints down the Red Lion

Far superior to Libre in every way...   ...though should be, as its infinitely more expensive

[TheBoy]

TB, I am not too lazy do tables, but I use Excel to create charts, because I want a graphical representation of the date - shows trend more clearly.
Mister Rog, I'm sure that I've tried your suggestion.....

Ron.

Its still an Office self-abusers tool, under all circumstances.

rather thing. Should never EVER be used by anyone with that rare commodity, common sense.

Rant over. For now.


Is it the teble that's lacking the border, or the chart? It wasn't clear to me,

[YZ250]

As said, there is a Border icon on the home page, if that's what you meant. It's just under the Bold/italic/underline function. Drag a border around your data and use use drop down to choose the box that shows all sides. This should create a solid box. You can then adjust by using right click/format shape/Border.

Easier to do than explain.

[Entwood]

Don't bother with borders if you just want the normal gridlines ... although with borders you can control the weight of the lines ... but ...

go to File, then Print

then down the bottom in blue ...  Page setup

then right hand tab labelled...  Sheet

put a tick in the box "gridlines" under Print ...

click "OK"

[TheBoy]

Did I mention its an Office self-abusers tool? And that I hate it with a passion?

I suspect this isn't my last rant about Excel (or Spreadsheets in general).

[STEMO]

Did I mention its an Office self-abusers tool? And that I hate it with a passion?

I suspect this isn't my last rant about Excel (or Spreadsheets in general).

You’re quite a ranty person, aren’t you? 

[YZ250]

Did I mention its an Office self-abusers tool? And that I hate it with a passion?

I suspect this isn't my last rant about Excel (or Spreadsheets in general).

You sound unsure of its usefulness, so I'll put you down as undecided.   

[TheBoy]

Did I mention its an Office self-abusers tool? And that I hate it with a passion?

I suspect this isn't my last rant about Excel (or Spreadsheets in general).

You’re quite a ranty person, aren’t you? 

Passionate, sweetheart, passionate.

[Bigron]

Nige, I couldn't fine any of the things you mentioned, except for File + Print - mine is part of the MS Office 2003 suite, so probably earlier than yours.
To clarify, yes I did mean gridlines. My mistake in calling them borders. I've got the data tabulated, which then go on to form charts (graphs) of the data, but the table of data looks "naked" without the gridlines when printed and I want to clothe them!
Ok, it's only cosmetic and not essential, but as I was a college lecturer for nearly 20 years (not bad for a 29 year old) I do like to present my work prettily. 

Ron.

[Rods2]

On Excel 2003 select the File menu and then Page Setup, click on the Sheet tab and tick the top box under the Print heading marked Gridlines.