Search:

Type: Posts; User: lizat; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. hmmm... It is odd that the space before is OK...

    hmmm...
    It is odd that the space before is OK for teh first instance but then not honoured, I have no idea why this is a problem.

    As far as the shading goes my solution thus far matches what...
  2. Replies
    2
    Views
    318

    Yes exactly, each of my pages is in a section of...

    Yes exactly, each of my pages is in a section of it's own and the layut is defined as vertically centred. It always used to work.????
  3. Thread: Word 2013; Lists

    by lizat
    Replies
    2
    Views
    297

    Hi Charles, Thank you, I know this well and...

    Hi Charles,

    Thank you, I know this well and should have reread my own notes based on Shauna's excellent guide. I have been away from Word for a while and so got a bit rusty. I thought I was doing...
  4. Replies
    2
    Views
    318

    Word 2013: Vertical Centring

    Dear Loungers,

    I cannot always get a section to vertically centre. Does anyone have an idea what might prevent this?

    I have one document, the first page is vertically centred successfully. Most...
  5. Thread: Word 2013; Lists

    by lizat
    Replies
    2
    Views
    297

    Word 2013; Lists

    Dear Loungers,

    Every now and then i tidy my templates and try again to understand and make list templates work consistently. Possibly a lost cause, but I live in hope!

    What is annoying me at...
  6. Word 2013: Heading with large top margin not honoured after the first

    Dear Loungers,

    I have a Heading 1 style defined with a large space before it - about 6 cms. I have two problems:


    The first instance of the style the large top margin is Ok. All subsequent...
  7. Replies
    6
    Views
    941

    Can't get to Network Properties

    Hi Loungers,

    In the good old days (never thought I'd refer to W7 that way!) If you click the network icon in systray and right click one of the networks you can get to the Properties for the...
  8. Hi Steve, The formatting was originally set-up...

    Hi Steve,

    The formatting was originally set-up manually and worked, the macro was developed based on recording and some tweaks to optimise it a little. The rules look correct after the macro has...
  9. Hi Steve, Yes, I understand what it is doing....

    Hi Steve,

    Yes, I understand what it is doing. And although I know that is how it behaves it isn't the way most people (in mt experience) want Excel to behave. Hence the macro. The behaviour it...
  10. Hi Steve, The original problem is that,...

    Hi Steve,

    The original problem is that, depending how things are inserted or amended, you can end up with a huge number of conditional format rules that amount to the right thing - effected by a...
  11. VBA for conditional formatting, but not applied dynamically

    Dear loungers,

    Since Excel doesn't maintain conditional formatting as I would like - once new rows and columns are added it becomes unmanageable - I have got into the habit of having a bit of VBA...
  12. Replies
    1
    Views
    284

    display conditional formatting rules

    Hi Loungers,

    Does anyone know how to display the current set of conditional formatting? I don't want to go to the cells I want a listing of all the conditional formatting rules. I am sure I have...
  13. Replies
    2
    Views
    258

    OK found it, the format wasn't set to a number...

    OK found it, the format wasn't set to a number for the cell
  14. Replies
    2
    Views
    258

    Using NOW or TODAY with DATEDIF

    Dear loungers,

    If I use this formula:

    =-(DATEDIF(TODAY(), GoLiveStartDate,"D")+3)/7

    I get an endless row of hashes. The same with NOW() instead of TODAY().
    The formula works with a cell...
  15. Backup & Restore personal application settings

    Dear Loungers,

    At work they are planning to replace my PC. I am a little nervous of this since I seem to know more that the guys doing the upgrade - they are just running a build script. And...
  16. Excel 2010 here's the sheet, nothing...

    Excel 2010

    here's the sheet, nothing confidential in it the Summary tab is the problem and it's working off the Config progress tab

    Thank you...................... liz
  17. Thank you Rory. However, my sheet has two...

    Thank you Rory.

    However, my sheet has two pivot tables, they work from the same data just showing slightly different summaries. The Column heading will be identical.
    So, following your idea I had...
  18. Pivot table - getting all possible column headings

    Dear loungers,

    My pivot table uses a status column to create the column headings. This status column is driven by a drop-down based on a list. I want the pivot tabel to have all possible status...
  19. Replies
    15
    Views
    555

    fab!!!!

    fab!!!!
  20. Replies
    15
    Views
    555

    This seems to work: ...

    This seems to work:

    =INDEX(E4:E200,COUNTA(E4:E200),1)

    It doesn't cope if the sequence has cells with blank in them but is good enough
  21. Replies
    15
    Views
    555

    Hi Maud, Thank you. The reason i wanted a...

    Hi Maud,

    Thank you.

    The reason i wanted a formula is that i need to do it several times and display the result in a cell at the top of the column in question. I am trying it with index and...
  22. Replies
    15
    Views
    555

    Find last value in a column

    Dear Loungers,

    just can't get the formula right for this.

    I have a column with values in, they are numbers but in the form of text i.e. with a single quotation mark in front like this '0.01. I...
  23. Replies
    3
    Views
    345

    Hi Retired Geek, How annoying obvious! I was...

    Hi Retired Geek,

    How annoying obvious! I was going blind having stared at it for so long. Thank you

    My problem then was how to wrap INDIRECT around it, I had a problem with quotation marks....
  24. Replies
    3
    Views
    345

    Indirect cell addressing

    Dear loungers,

    I have a spreadsheet where I want to construct an address that has the data I want to retrieve.

    This is the address: 'Missing Fields 16 July'$E$4
    This is constructed like this...
  25. Dear Retired Geek, Was pulled off onto an...

    Dear Retired Geek,

    Was pulled off onto an emergency and just getting back to this,... looks good I will have a play. Thank you once again for being "retired"!!!

    liz
Results 1 to 25 of 487
Page 1 of 20 1 2 3 4