Stuff that occurs to me

All of my 'how to' posts are tagged here. The most popular posts are about blocking and private accounts on Twitter, also the science communication jobs list. None of the science or medical information I might post to this blog should be taken as medical advice (I'm not medically trained).

Think of this blog as a sort of nursery for my half-baked ideas hence 'stuff that occurs to me'.

Contact: @JoBrodie Email: jo DOT brodie AT gmail DOT com

Science in London: The 2018/19 scientific society talks in London blog post

Showing posts with label Word tips. Show all posts
Showing posts with label Word tips. Show all posts

Wednesday, 19 September 2012

More Word glitches solved - troublesome HYPERLINKs and apostrophes


Sporadically (usually after a Windows update I think) my work computer's version of Word starts to look like this, with embedded URLs showing up with the format { HYPERLINK "http://www. " }

Before

Screenshot of shouty hyperlinks









After

Screenshot of normal embedded hyperlinks








In a few weeks or months it will probably do it again and I'll google the solution. It's Alt+F9.

Information found from http://www.codingforums.com/archive/index.php/t-39782.html (switch your sound off, the website has an annoying autoplay advert but the info works) - apparently I'm toggling field code shortcuts.

I suppose this way of acknowledging a hyperlink is just a more overt equivalent of hovering over the link so that the URL pops up, as it does on the web.

For some reason this doesn't appear to work on my version of Word anymore and if I want to see what the URL is I have to pretend to edit it (right click, edit hyperlink). One day I'll add that to my solved glitches too but the workaround works fine I suppose.

Bonus solved annoyance
Shortly after I fixed that I found that apostrophes were playing up. I tried to type "you've" but it ended up as "you' ve" with a single enlarged space between the apostrophe and the letter V. Googling brought up a forum post in which several answers were offered (I found selecting all the text and changing the font was the one that worked for me). The solution was to be found here
http://www.proz.com/forum/office_applications/76284-word_adds_a_biiiig_space_after_an_apostrophe.html

I've written before on the odd characters that Google adds to the address after you've done your search.

https://www.google.co.uk/search?hl=en&sa=X&ei=qb9Z[deleted]AfHjoCoDQ&ved=0C[deleted]AQ&q=Word+gap+after+apostrophe&spell=1&biw=1307&bih=7[deleted]3

This is the one that you'd share with someone else (unless you just said "search for... on Google"). It's not particularly human readable (at least not Jo-readable) so I don't know what it means - I've deleted random bits of it so it won't actually work as a live address.

Given that the amended version below works perfectly well I don't see why all these extra characters should get to be involved.

https://www.google.co.uk/search?hl=en&q=Word+gap+after+apostrophe

More posts in the Word tips series...

Thursday, 13 September 2012

How to avoid deleting stuff and how to recover from it - at a fairly basic level I think

Edit: 2 December 2012 - instructions are for PCs, which is what I wrote this post on. Now I'm using a Mac the instructions are more or less the same but wherever it says Ctrl use the Command key . Where I've referenced notepad or paint - use TextEdit or TextWrangler and [need to check name of Paint version!]. 

When I started using computers for writing documents in earnest (the days of AmiPro, WordPerfect and early versions of Word) I soon learned that saving often and backing up was important. 

The first thing I ever learned, and probably the thing I type most with my left hand, is Ctrl+S which is your basic 'save whatever I'm working on now' keyboard command on a PC. As far as I'm aware it'll work on anything where you can type.

If you've not saved the document before (ie, it's a new document) then pressing Ctrl+S will likely bring up a little box inviting you to name the document and say where you want to store it.

Generally programmes like Word don't crash anything like as often as they used to and recovery appears to be built in as default (if not, try File > Options > Save, making sure relevant boxes are ticked).

Even if your computer needs to be switched off and on again to restart things, Word, when you restart it, will show you the last saved version (the programme automatically saves at intervals, you can change the intervals yourself [see below] and of course Ctrl+S overrides and saves with the current version) and ask if you want to keep or discard it.

A couple of quick ways of grabbing your text before things crash, that is if you get any warning, are...
(1) use Ctrl+A which selects all of the text in the currently-active typing window, then Ctrl+C to copy that text to the clipboard (which is hidden, so it looks like nothing happens). Ctrl+V will then paste the text into a fresh window - I often use notepad for most of my editing (in fact I'm drafting this post in notepad now) which is a much smaller programme and quicker to save a file in, in an emergency. My preference is to start in notepad and then transfer (using Ctrl+A, C and V) into Word for a document or email, or into a blog post, comment window or whatever.

Or (less brilliantly)

(2) to press the Print Screen button on your keyboard (PrtScn on mine, next to Scroll Lock) and then open up Paint (basic picture editing software that's bundled with every version of Windows I've ever seen, used to be called Paintbrush) which you can find by Start » Paint (type it in the search box). Pressing PrtScn copies an image of the entire desktop (you can also do Alt+PrtScn just to copy the current window) which you can then paste (Ctrl+V) into Paint and save it. Admittedly all that will do is save a couple of hundred words or so which you'll then have to retype them. We've all done it ;)

Recap
  • To save your document as you go, use Ctrl+S
  • To select all the text in the window that you're currently writing in, use Ctrl+A
  • To copy the text that you've selected (you can use your mouse to click and drag a smaller selection of text of course) - Ctrl+C  || Use PrtScn or Alt+PrtScn to grab a 'photo' of what you were working on, save it in Paint and re-write it when you've recovered.
  • To paste the text that you've copied somewhere, use Ctrl+V (you need to position your mouse cursor into the spot where you want your text to appear).
We're also writing a lot of stuff these days directly 'onto the internet' in terms of drafting blog posts or writing comments on YouTube. Here there are greater risks of losing stuff when you press send and the page refreshes itself taking my / your pithy insights to the grave. Swearingly annoying when that happens. 

I do sometimes weaken and type directly into an internet comment box (I include 'compose new Gmail message' in this category) but before I press send / publish / comment or any other 'go' button I usually do a quick Ctrl+A (to select all) and Ctrl+C (to copy it to the clipboard) ready to paste it again (Ctrl+V) in case of disaster.

A free program that autosaves as you write: Evernote
Evernote acts both as a local filestore and as a place to store files on the internet. You can create a new note, type text in it and press Ctrl+S and it's saved to your computer. If you're connected to the internet it will miraculously synchronise with the Evernote server providing (a) back up of your note and (b) let you read your note on any other device that you've chosen to sync with your Evernote account (eg iPhone). You can also click the Sync button to manually synchronise.

I use this a lot when going to a place I've not visited before - I use Google Maps to find information, take screenshots on my PC, stick them into an Evernote note then click Sync to synchronise. Once done I can then view this information on my iPhone while on the move (the iPhone version of Evernote needs to be synchronised too so do this before you leave in case the signal's poor when you're out). Very useful.


Free online filestore: Google Drive née Google Docs
If you've a Gmail / Googlemail account (and if not it's pretty easy to get one) you already have a large free internet space to create and store files on Google Drive. If you use the Chrome browser (it's Google's) you can work offline but will need to synchronise once you are online again, so that you can access the files from another computer. You can also export your documents to doc, pdf, rtf etc.

Thanks to Erik J Cox and Joe Dunkley (@joedunckley) for suggesting Google Drive and also for what to say about it, in response to a related tweet of mine.

If you've done something you didn't mean to: Ctrl+Z
I have always felt a bit like this XKCD cartoon [where someone says they've never seen the diet coke and mentos demo before and you get the joy of showing them] whenever I've shown someone how to recover whatever they were doing with the Ctrl+Z command.

With a-bit-too-sensitive laptop pointers it's annoyingly easy to unwittingly select a bunch of text and overwrite it. I do this a lot by accident when I'm actually trying to paste something (Ctrl+V) on top of some text I want to replace and mistakenly end up just pressing the letter v, replacing an entire paragraph of text with "v". Pressing Ctrl+Z fixes this (it reverts you back one step) - it's exactly the same as 'undo' and works anywhere you can type. 

You can toggle between 'undo' (Ctrl+Z) and 'redo' (Ctrl+Y) all you like (although ironically it's not that effective in notepad!)

In programmes like Word you can do several steps backwards if you press and hold Ctrl and press Z a few times and you can probably set how many times you're able to go back - although I've not found out how to do it. It seems I can go back several steps on my copy of Word so I think the default setting is pretty forgiving.

Recap
  • You've done something you wish you hadn't and want to go back a step (undo), use Ctrl+Z
  • You've done several somethings you wish you hadn't, use Ctrl+Z, Z, Z (keep holding the Ctrl button while pressing Z!)
  • Actually that was fine, you didn't need to undo that (redo), use Ctrl+Y
A free tool to back up your files: Dropbox
This is a file storage system that, like Evernote, works locally and on a remote server. When you save a file you save it to a location on your own computer but it is also synchronised with a copy of that file on the Dropbox servers. I use this to work on something in the office, save it, close... and then pick it up at home. As long as you don't have the work and home copies open simultaneously you'll never run into problems (even then it just saves two copies and marks one as a copy, for you to decide which one to keep). 

Both Dropbox and Evernote have pretty much eliminated the need to email documents to myself. 

Even if you delete a file on your computer's Dropbox and didn't mean to you can undelete and recover it via the web server - http://dropbox.com

Learning objectives: you should now be familiar with... ;)
  • Use Ctrl+A, Ctrl+C to copy a bit of text before publishing it somewhere, using Ctrl+V to paste it, just in case you lose it.
  • When working in a document type of programme use Ctrl+S regularly to save it.
  • Recover from error with Ctrl+Z to undo (or Ctrl+Y to redo)
  • Use 'cloud' type services like Evernote or Dropbox (free versions available) to 'type and save' as you go.
  • If writing on the web (eg a blog post or comment) draft it in something like notepad first before transferring the text. Or if writing directly onto the web copy the text before you publish it in case the page loses it when you press 'publish'. 
Miscellaneous things about Word that I've mentioned above
Tweaking the time between automatic saving of your document.
These instructions work for Word 10 (the one with ribbons) - they're slightly different from earlier ribbon-free versions of Word.
  • Click on File (it's probably highlighted in blue and is to the left of the Home tab). 
  • Choose Options which is towards the bottom of the menu.
  • Choose 'Save' to view the options for saving documents.
In the main panel you'll see an option for "Save AutoRecover information every ... minutes" - make sure it's ticked and set a time, eg 10 minutes, or lower if you type fast. There's also a "Keep the last autosaved version if you close without saving" - I'd be surprised if this wasn't already ticked as default but tick it if not.

Temporary copies of your Word documents are probably available somewhere on your computer
It used to be the case that when you were working on older versions of Word every time you saved the document the system would create a temporary (.tmp) file which was overwritten once you closed Word.

It was possible to recover these when disaster occurred and sometimes to get the text out (this was not always straightforward and required a bit of prior knowledge and patience). I vividly remember lovely IT folk helping me access these types of files in the first place so that I could then work on one to try and recover the text. The contents were usually fairly unreadable and it wasn't simply a matter of opening up the .tmp file and carrying on as you were - you had to pick the closest correct format to open and then do quite a bit of processing of the mangled text to fix things. 

This is where I learned to use things like Edit / Replace All but that's not particularly relevant to this post, but see this one for more on that.

I've honestly no idea where the .tmp files are to be found on my current laptop - I've never needed to look for them as the software hardly ever crashes (sometimes it hangs, but it recovers a few moments later). This is probably a useful technique to record so if anyone knows more and tells me I'll add it here but I've found all the other methods above tend to solve everything for me.

Meanwhile, I suggest trying to search for *.tmp / *.tmp* / *.doc or *.doc* to see what's there. If your file is called important.doc you could replace the first asterisk with important, the second asterisk covers all eventualities of your file ending being .tmp$ or .docx etc. See Retrophile's second comment below.

More posts in the Word tips series...

Thursday, 26 July 2012

Ways in which data give you away - redaction, and phone keyclicks

1. Redacting information - careful with your spreadsheets and Word documents etc
Earlier today I read the rather interesting story of the unwittingly-released personal data of residents in a London borough, via the MySociety newsletter.

A Freedom of Information request was made to find out who had been provided council housing and the council obliged with information in an Excel spreadsheet. Although sensitive data was not overtly available it was available in 'hidden sheets' which are recoverable by fairly minor geek skills. MySociety links to a page on Microsoft's site that shows how to do this.

While few people downloaded these files (I don't know who downloaded them or what they did with that info) this information should have been redacted.

Redaction involves properly removing something, not just hiding it. A failure to redact or bungled attempts can be unfortunate and amusing and in some cases can draw attention to the fact that an attempt has been made to hide something ;)

Whenever you email a Word document to someone, unless you've removed some of the details the recipient can see when you began editing it, how long you've spent editing it, and the document's author (may or may not be you). Generally this is no big deal and I can't actually think of a time when I've bothered to / needed to do this (the version of Word I have actually prompts you for this, inviting you to make a version more suitable for sharing).


You can also read the much more hyperbolic version of the story from the local paper.

Other posts in the Word tips series...

Redaction and FOI
Paul Bradshaw of Help Me Investigate posted on his blog that any claims made by organisations that redaction will eat into their costs are likely to be nonsense. Apparently there's been a ruling on it: "we find that a public authority cannot include the time cost of redaction when estimating its costs."

2. Mobile phone keyclicks - it's possible to work out what number you're dialling
On the bus this morning someone dialled a number on their mobile and as they had keyclicks on every number entered made that little 'number being entered' sound. This particular person was using the classic two-tone sounds that dial phones make (you can hear each of the tones here, in the DTMF* number keypad bit) - each number has two separate tones combined to form a chord.

*Dual-tone multifrequency signalling

I wondered how easy it would be for someone listening to be able to instantly know which numbers were being entered. Even if someone couldn't do it live a recording of the keyclicks (admittedly it's fairly unlikely that anyone would bother to do this!) could be played back and the number uncovered. While I don't have perfect pitch and could only guess the intervals between the dialled 'notes' I'm sure there are people who could hear the number being dialled live. I've listened to all the tones and I think that some of the numbers 'sound' warmer than some of the others (chords are less dissonant I suppose) but that's about it - I can differentiate them but can't remember which is which.

After I tweeted this idea, @minifig (Thom) replied to suggest that if a recording was made then playing it down the handset of an old style phone would probably be sufficient to ring that number too. After much childhood playing with telephones I know that pressing the button (that indicates when the handset is replaced) several times at different rates could get the phone to do different things so this seems pretty likely - this was later confirmed by tweets from @schrodingerskit and @drjohnmitchell




Thom also linked to this video of a 2 year old child who can recognise numbers just by hearing them dialled - I suppose it it can't be that rare to be able to do this but I wonder how many people / toddlers have really noticed that the numbers sound different.

 

Funnily enough when I was young my dad gave me a musical calculator which played a unique note (not the dual-tone)  for each number. Although a bit like something out of Close Encounters of the Third Kind I can still remember the 7-note melody that my childhood home phone number made.

Geeky asides aside, this sounds like useful ammunition in trying to get people to switch off the annoying keyclicks on their phone.  I might have to learn the number sounds to be more convincing about this ;)

Thursday, 24 May 2012

How to get rid of white space / line breaks in Word

I seem to be on a Words / lines thing at the moment.

Right then, I had a 35 page Word document* which had many paragraphs each separated by four lines of white space (the equivalent of 'enter' having been pressed four times). One line suffices so I sought to find out how to quickly Find / Replace (Ctrl+H) the three extra linespaces with nothing (or I could have replaced four linespaces with one linespace).

@dianthusmed had the answer to my question
It works: ^l^l^l is the string to select three linespaces. The ^ is called a caret.

1. Press Ctrl+H to bring up the Find and Replace menu
2. Type ^l (SHIFT 6 on full-size keyboard and the letter L) three times into the 'Find what' dialogue box, leave the 'Replace with' box blank
3. Click the Find Next button to make sure it's selecting correctly and then Replace to replace - once you're satisfied that all is well click the 'Replace All' and smile as your 35-page document trims itself to 23 pages.

Thanks also to @zeno001 who offered suggestions too and this is also a useful read "Special characters you can use with Find and Replace in Word"

*Technically it's a LaTeX document that I'm viewing in Word. Ironically I can't compile the 'tex doc into a pretty thing to read because there are other files (bibliographies) embedded into the doc that it needs to run and I don't have access to them. So this was my workaround, but I like saving paper when printing.

Wednesday, 16 May 2012

How to get rid of lines in Word (Microsoft Word 2010)

by @JoBrodie, brodiesnotes.blogspot.com

Effing effing lines in Word. You put them in thinking they might break up the text a little. And so they do, effing it all up entirely and chasing you around the page.

How to get rid of the little bastards?
My method is below but a commenter below suggested using Ctrl+Q which you might like to try first:

"You can also use the magic of ctrl+Q this resets the paragraph formating. have something of text on both side of the offending line, select that and press ctrl+q ^^"
 
Highlight the area of concern and click on the Page Layout tab in the menu (File | Home | Insert | Page Layout). Swear for a bit until you spot the word 'page borders' in the 'Page background' section of the ribbon thing. Click on that and then click on the Borders tab on the left (you'll probably be on the default tab in the middle which is Page Border). Click the 'None' setting in the left and then OK. This should magically remove the lines. [See pictures below]

If you get into real difficulty the only foolproof way I've found of wresting back control from recalcitrant text is to copy and paste it into Notepad (try C:\Windows\system32\notepad.exe but if not it's Start > notepad [then press enter]) which strips the text of all formatting allowing you to start from scratch.

I use Notepad more than I use any other software programme, before transferring text to whatever programme I want to save it in. If it's really important stuff I tend to write it directly into Evernote and I press Ctrl+S very frequently to make sure I've saved it. Word has its own autosave which is useful but I nearly always start a document in Notepad.

Picture 1 is what happens when you create a solid line using the hyphens... you can use the option that appears just after you create one to nip future solid lines in the bud but for previously created lines see picture 2.

When you type a few hyphens - - - - (without spaces, I just put them in to make it look more like a line of hyphens) and press enter, a solid line is created. On the left hand side the lightning icon will appear and the option to permanently switch off the creation of border lines (highlighted) is the way to stop these lines at source.

Picture 2 is how to remove previously set lines.

Click on image to enlarge: 1. Select your text | 2. Click on the tab marked 'Page Layout' | 3. In the page layout ribbon that appears below the tab, click on 'Page Borders' | 4. Choose the left tab called "Border" (not the middle Page Border one which I am mistakenly showing you here, oops) then select 'None' and press OK.


See also
Other posts in the Word tips series...
 


Wednesday, 1 February 2012

...but which one will let me position the picture where I want it in Word?

In my quest to make some sticky labels (for work purposes, doing some public engagement work and thought the kids might like stickers) I have learned about the limits of my nerd skills. Clearly Word is not the best tool for this but it's the one I use most frequently so know my way around. Quite possibly I could have done it in PowerPoint although Word has these handy-ish gridlines and I don't think PP's are anywhere near as good.


The picture editing tools above offer options for positioning an image on the screen, but generally they are in relation to text. Not too surprising as Word is more interested in text than images. But if you just have an image to go into 65 slots on page (repeating image so all stickers are identical), and you want the image to sit neatly within the sticker slot and not lurch too far to one side - which would you use?

I think I've tried them all but I'm curious as to which one will let me move the image with the most fine-grained movements - ie which will offer the least resistance and let me take charge of the positioning. Pretend I'm a surgeon trying to avoid accidentally cutting something important and I want to be able to move the picture a little bit thataway and down a bit rather than unending fights.

The up / down / left / right arrow keys were equally treacherous today. Every time I pressed the down arrow (innocently thinking it might move the image down a notch) it moved the image down AND to the left, but it did this inconsistently. Maddening.

I went with 'Through' in the end but I'm not sure how it differs from the others (although I usually avoid square I think).

Where's the guide to trouble-free image positioning / label making?
<-- start at 10 mins :)

Ingredients
  • Ryman P65 labels (25 sheets of 65 labels, 1,625 labels), about £6-7 per pack depending on offers.
  • Free template for P65 labels
  • Time
  • Patience
  • Patient colleagues who don't mind you swearing and getting a bit huffy. 
Edit: 2 February 2012
Eventually I gave up with the free templates business and learned how to make label templates in Word. It's still fiddly but I managed it. And I was greatly helped in my task by these two websites, and the picture below which showed me what 'vertical pitch' and so forth actually mean. These figures work reasonably well for P65 labels but further tweaking of the image is still needed - I am just not very good at this sort of thing I'm afraid.


More posts in the Word tips series...




    Wednesday, 19 October 2011

    How to stop Word 2007 / 2010 (y’know, ‘new’ Word) capitalising words.

    Instructions
    • File » Options, click on Proofing, then AutoCorrect Options... button
    • In the new window make sure there ISN'T a tick next to "Capitalize first letter of sentences".
    • Adjust other options to taste then OK, and OK again to dismiss final window.
    Background chatter
    I’ve been using ‘new’ Word for ages and find it pretty intuitive but today I found that I wanted it to stop capitalising the first letter of a word in a list (every damn time I press space or enter – maddening!)

    In the old days it was Tools » fiddle about with the Options / Autocorrect options, but of course there doesn’t seem to be a Tools toolbar to hand. Anyway, I’ve found that it’s in the File tab.

    This is a tab that’s always confused me. I’m currently in ‘Home’ but File is the one that’s highlighted blue.. anyway, if you click on File it will bring up a window in which you can do other stuff (I’d much prefer this to have been a floating dialogue window as it used to be but…). Lurking towards the bottom of the left hand side of the menu is Options – it’s all in there – see instructions above.

    Seriously I’ve only just spotted that…

    I wrote this bit first and then realised that people might just want the how-to rather than the me-bleating so put it at the top.


    Other posts in the Word tips series...