6 May 2017

MS Word: keep tables on one page

Page breaks are an annoyance in word. Whenever you update your document they shift and mess up your layout.
Easily to avoid this by using the paragraph properties keep with next & keep lines together (and I don't know why these do not appear in the ribbon for east access).
But for some reason I never got tables to work with this.
Easy enough to select the table with the little cross in the left top that appears on hovering and setting the paragraph properties, but they did not take effect.
In a document with many small tables they kept on splitting across pages, and I had to revert to page breaks.
It appears that you have to make sure that in the table properties Text Wrapping is set to None. Now all is well!


29 March 2017

powerpoint: swap presenter view and demo

When presenting on windows, switching between a powerpoint (2016) presentation and a demo is problematic.

The goal

During a presentation I am projecting the slides in extended view behind my back to the audience and have the presenter view on my laptop in front of me.
When I switch to a demo I want to duplicate my laptop screen to the projector.
I want to swap easily between both modes.

The Problem

I set up my PC in extended view (F8 on my laptop)  and start the presentation: the full slide is projected and the presenter screen is on my laptop: fine.
When I start a demo, I duplicate my screen. The demo shows up in front of me and on the extended projected view: fine
When I switch back from demo view (duplicate screen) to extended view, the powerpoint presentation does not migrate back to the extended view.

The solution (sort of)

  1. Switch back to extended view
  2. right mouse menu in powerpoint presentation>duplicate slide show: the presentation is now shown in extended view (projector) and on my screen
  3. right mouse menu in powerpoint presentation>show presenter view: the presenter view is on my laptop, the full slide is on the projector.
I reach the result I want. Only this takes three steps. Isn't there more fluent way to do such a common task?

9 February 2017

UK: insurance for self driving cars

UK plans to have a car insurance that does not care whether you or the car is driving. In both cases, an accident is an accident, and you are insured either way by a uniform car insurance.
This is a major step towards the general acceptance of self driving cars.
more...

24 January 2017

Excel 2016: this workbook contains links to one or more external sources that could be unsafe

I get this message sometimes when opening a workbook. Generally I have copied a formula from another workbook instead of a value, but i always want to check before breaking things.

I used a Microsoft support article (ignored the Edge promo):

  1. Type CTRL+F (opens Find and Replace Window)
  2. Click [Options >>]
  3. Fill in these values
    1. Find What: \[
      1. the MS article uses [, but I got some false positives from that
    2. Within: Workbook
    3. Look in: Formulas
  4. Click [Find Next] to search
If after verification you want to get rid of the warning, use the advice you get by clicking the Help button in the box:
  1. On the Data tab, in the Connections group, click Edit Links
    Here you can also update and break the links, but you do not see in which cells they are used.
  2. Click [Startup Prompt...]
  3. Select the option that you want