Omega Owners Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Search the maintenance guides for answers to 99.999% of Omega questions

Pages: [1] 2  All   Go Down

Author Topic: Battling with Microsoft Excel.  (Read 257 times)

0 Members and 1 Guest are viewing this topic.

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 2667
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Battling with Microsoft Excel.
« on: 25 September 2017, 16:48:33 »

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.
Logged

zirk

  • Omega Queen
  • ********
  • Offline Offline
  • Gender: Male
  • Epping Forest
  • Posts: 10242
  • 3.2 Manual Special Saloon ReMapped and LPG'd and
    • 3.2 Manual Special Estate
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #1 on: 25 September 2017, 17:08:28 »

Have you set the Print Area for that document?
Logged

TheBoy

  • Administrator
  • *********
  • Offline Offline
  • Gender: Male
  • Brackley, Northants
  • Posts: 94510
  • Ah, the Silver Bullet
    • Jaaaaaaaag
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #2 on: 25 September 2017, 17:22:58 »

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.
Logged
I don't tolerate bickering, and I'm always grumpy.
And Lizzie Zoom says I'm a heartless bastid...and she's absolutely correct!

Mister Rog

  • Omega Knight
  • *****
  • Offline Offline
  • Gender: Male
  • Wales
  • Posts: 1721
    • Volvo XC70
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #3 on: 25 September 2017, 17:34:21 »


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         ::)      ::)      ::)

Logged
“The desire to be a politician should bar you for life from ever becoming one.” Billy Connolly

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 2667
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #4 on: 25 September 2017, 17:45:50 »

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.
Logged

TheBoy

  • Administrator
  • *********
  • Offline Offline
  • Gender: Male
  • Brackley, Northants
  • Posts: 94510
  • Ah, the Silver Bullet
    • Jaaaaaaaag
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #5 on: 25 September 2017, 17:56:22 »

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 ;D
Logged
I don't tolerate bickering, and I'm always grumpy.
And Lizzie Zoom says I'm a heartless bastid...and she's absolutely correct!

TheBoy

  • Administrator
  • *********
  • Offline Offline
  • Gender: Male
  • Brackley, Northants
  • Posts: 94510
  • Ah, the Silver Bullet
    • Jaaaaaaaag
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #6 on: 25 September 2017, 17:59:03 »

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,
Logged
I don't tolerate bickering, and I'm always grumpy.
And Lizzie Zoom says I'm a heartless bastid...and she's absolutely correct!

YZ250

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Oxford/Bucks border
  • Posts: 2590
    • Black 3.2 Elite Estate
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #7 on: 25 September 2017, 18:20:53 »

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.

Logged
My fun car is a 2017 Bmw F32 430d M Sport with indicators.

Entwood

  • Omega Queen
  • ********
  • Offline Offline
  • Gender: Male
  • North Wiltshire
  • Posts: 18710
  • Quietly Confident
    • Elite 3.2 V6 (LPG)
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #8 on: 25 September 2017, 19:11:48 »

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"

:)
Logged
V6 Cam locking/setting kit, Maxscan GS500 OBDII code reader/EML resetter available.  

TheBoy

  • Administrator
  • *********
  • Offline Offline
  • Gender: Male
  • Brackley, Northants
  • Posts: 94510
  • Ah, the Silver Bullet
    • Jaaaaaaaag
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #9 on: 25 September 2017, 19:20:08 »

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).
Logged
I don't tolerate bickering, and I'm always grumpy.
And Lizzie Zoom says I'm a heartless bastid...and she's absolutely correct!

STEMO

  • Omega Lord
  • *******
  • Offline Offline
  • Gender: Male
  • Up North
  • Posts: 7102
    • Astra 2.0 diesel
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #10 on: 25 September 2017, 19:31:26 »

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?  ;D
Logged
If you are offended by anything I post, sorry. Just thought I'd get that in now.

YZ250

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Oxford/Bucks border
  • Posts: 2590
    • Black 3.2 Elite Estate
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #11 on: 25 September 2017, 19:35:56 »

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.   ;D
Logged
My fun car is a 2017 Bmw F32 430d M Sport with indicators.

TheBoy

  • Administrator
  • *********
  • Offline Offline
  • Gender: Male
  • Brackley, Northants
  • Posts: 94510
  • Ah, the Silver Bullet
    • Jaaaaaaaag
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #12 on: 25 September 2017, 19:43:12 »

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?  ;D
Passionate, sweetheart, passionate.
Logged
I don't tolerate bickering, and I'm always grumpy.
And Lizzie Zoom says I'm a heartless bastid...and she's absolutely correct!

Bigron

  • Omega Baron
  • ******
  • Offline Offline
  • Gender: Male
  • Witham, Essex
  • Posts: 2667
    • Omega 2.6 V6 Auto '51 Reg
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #13 on: 25 September 2017, 20:53:32 »

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.  8)

Ron.
Logged

Rods2

  • Omega Lord
  • *******
  • Offline Offline
  • Gender: Male
  • Sandhurst Berkshire
  • Posts: 6194
    • 1999 3.0 Elite Estate
    • View Profile
Re: Battling with Microsoft Excel.
« Reply #14 on: 25 September 2017, 21:46:15 »

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. 8)
Logged
US Fracking and Saudi Arabia defending its market share = The good news of an oil glut, lower and lower prices for us and squeaky bum time for Putin!
Pages: [1] 2  All   Go Up
 

Page created in 0.069 seconds with 16 queries.