RSS

Monthly Archives: March 2016

How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?

When you’re printing an Excel spreadsheet, how do you make the gridlines print, too?

This article tells you how to print the gridlines automatically, working in the Page Layout Tab, in Excel 2007, 2010 and 2013 (screen shots are taken from Excel 2010).

With your spreadsheet open, go to the Page Layout tab and look to the right to find the Sheet Options area:

print headings

In this area, you can tick Print to make the gridlines appear when you print out the spreadsheet.

There are two things to note here:

  1.  You can also untick the View boxes so you can’t see the gridlines at all. I’m not sure why you might want to do this, but there it is.
  2. If you have used the borders option already to draw borders around some cells, if you print without ticking Print Gridlines, the borders you have added will print anyway; if you tick Print Gridlines, all of the gridlines and borders will print.

Adding customised borders to cells

A quick reminder on adding borders:

Click on the cell(s) you want to add borders to. Click on the Borders drop-down in the Home Tab, Font area:

apply borders excel

then choose where you want your borders to go:

border options excel

More sheet options

You will see that there’s a little arrow in the bottom right corner of the Sheet Options area:

sheet options

Click on this arrow and the Page Setup dialogue box opens – here you can change a few more options, too, or set your headings to print if you want to, as well as going into the other tabs to change the orientation or margins, etc.:

sheet options print gridlines

And that’s it – now you can print the row numbers and heading letters in Excel 2007, 2010 or 2013!

If this has been helpful, please comment below or share the article using the buttons. Thank you!

Related posts on this blog

How do I print the row numbers and column letters in my Excel spreadsheet?

How do I print the Excel header row on every page of my spreadsheet printout?

How do I print the Word header row on every page of my table printout?

 
7 Comments

Posted by on March 23, 2016 in Excel

 

Tags: , , ,

How do I print row numbers and heading letters in Excel 2007, 2010 and 2013?

When you’re printing an Excel spreadsheet, how do you make the row numbers and heading letters print, too?

This article tells you how to do this, working in the Page Layout Tab, in Excel 2007, 2010 and 2013 (screen shots are taken from Excel 2010).

In your spreadsheet, go to the Page Layout tab and look to the right to find the Sheet Options area:

print headings

In this area, you can tick Print to make the headings (or, indeed, the gridlines) appear when you print out the spreadsheet. Note that if you want to, you can also untick the View boxes so you can’t see the headings. I’m not entirely sure why you wouldn’t want to see those, but the option is there.

You will see that there’s a little arrow in the bottom right corner of the Sheet Options area:

sheet options

Click on this arrow and the Page Setup dialogue box opens – here you can change a few more options, too, or set your headings to print if you want to, as well as going into the other tabs to change the orientation or margins, etc.:

sheet options print headings

And that’s it – now you can print the row numbers and heading letters in Excel 2007, 2010 or 2013!

If this has been helpful, please comment below or share the article using the buttons. Thank you!

Related posts on this blog

How do I print the Excel header row on every page of my spreadsheet printout?

How do I print the Word header row on every page of my table printout?

 
6 Comments

Posted by on March 17, 2016 in Excel

 

Tags: , , ,

How can I transcribe more quickly?

Because transcription is usually paid by the audio minute (i.e. if you have a 20 minute tape, you will be paid 20 x your per-minute rate), the faster (and more accurately) you transcribe, the more money you can make per hour. Here are some tips from my own experience about how you can transcribe more quickly. It’s not all about typing faster, either – it’s about typing faster and typing smarter and working smarter.

All links are to my own articles that explain the topics in greater depth.

Typing faster

One main way (but not the only way) to improve your transcription speed is to simply (ha!) type more quickly. Here are some tips on how to build your typing speed. The first one might surprise you ..

  • Number one tip: trim your fingernails.

I have studied this (because someone has to) and I can improve my typing speed by about 5% by trimming my nails. I can type more quickly when just the pads of my fingers are striking the keys. It also takes longer to wear the letters off your keys if you’ve not got long nails to scratch them …

  • If you’re serious about going into transcription, especially if you have a specialised medical or legal background where the fees are that bit higher, it’s worth investing in typing training – have a look at Pitman courses.
  • A decent keyboard will also help you to type more quickly. Have a look at my post on ergonomics and keyboards, as I cover that there in a lot of detail. But typing on a decent keyboard as opposed to bashing away at a laptop or netbook will improve your typing speed.
  • The more you type, the faster you’ll typically get, up to a point. So you might start off a bit slow, but your speed should pick up, if you’re touch-typing reasonably accurately.

Typing smarter

As well as physically typing faster, you can use technology to help you to transcribe more quickly and efficiently.

  • If you’re not using transcription management software, start doing so (read more on this here). This doesn’t do your typing for you, but it allows you to manage the speed of your tape and stop and start it in the most ergonomic way possible.
  • Use autocorrect to your advantage. I’ve written about this at length in another article, but these are the most important points for building speed and accuracy:
    • Set up common shortcuts right from the start – bec = because, w = with, nec = necessarily, etc. Add these are you come across them.
    • Set up any words you commonly misspell – you can do this when you’re spell-checking, as there’s an autocorrect option in the spell check dialogue box (I have trouble typing occurred correctly, for example).
    • As soon as you recognise commonly used words or phrases in your particular tape, get them into the autocorrect. Long album titles? The name of a big exhibition the artist is working on? Moisturiser and concealer in a set of interviews assessing makeup? If they come up more than twice, create an autocorrect for them.
    • If you’re typing the names of people in the conversation, have a convention, e.g. aa for the interviewer, bb for the first interviewee, change the autocorrected text for that shortcut for each tape (e.g. aa might be Interviewer for one tape, Manager for another, Anita for a third, bb might be Interviewee, Employee or Jane), and always use the same shortcut for the main and secondary person, so it’s super-easy to remember what to type.
  • How about using voice recognition software? This has got a way to go, and editing it, in my experience, takes as long as transcribing in the first place.

Working smarter

This is mainly around the things that delay you in doing the work – looking things up and distractions.

  • I look things up when I’m transcribing – band names, place names, etc. It’s far more professional to provide a transcription with the facts checked and anything you can’t hear or are unsure of marked. Make looking things up work the way you need it to:
    • I find it easist to look them up as I go along, you might finid that disturbs the flow. Do what’s best for you.
    • I have found from experience that if I can’t hear a word, especially a technical term or proper noun, often the interviewer will ask the interviewee to spell it out … just after I’ve spent ages looking it up. So let the tape run a bit and see if it helps you pick that information up without spending time searching for it.
  • I type for an hour at the very most, as after that length of time my posture droops and my typing slows. It might only be a stretch and a march up and down the stairs, but do break it up a bit. Read more about ergonomics here.
  • I do need to have the Internet turned on while transcribing, because I need to look things up, but I’m careful not to answer phone calls or even look at emails until my break. Nothing is that urgent it can’t wait, and three minutes spent looking at something, plus the time it takes to get back in the transcription zone, can lose a few minutes per hour of transcribing. It all builds up!

A final thought

I hope these tips have helped to give you some ideas about how to transcribe more quickly and efficiently. Here are two final thoughts …

  1. If you’re reading this and you’re a journalist or researcher, not a professional typist, especially if you can’t touch type, it’s probably a better idea for you to explore finding a transcriber to do it for you than to try to get faster. I can often transcribe a tape up to twice as fast as a non-professional, freeing my clients up to do their real jobs!
  2. However quickly you type, ALWAYS assume a job is going to take slightly longer than you think. Why do you think this is being posted on Thursday morning instead of Wednesday afternoon …?

If you’ve found this article useful OR if you have more tips for transcribing more quickly, please do comment below – I always love to hear from my readers! There are sharing buttons there, too, so you can share this on whatever social media platforms you use. Thank you!

Other useful articles on this blog

How do you start a career in transcription? – are you suited for it?

The professional transcriber – the technology you need

10 top tips for transcribers – what every new transcriber needs to know

Why do you need human transcribers, anyway? – I explain why!

Keyboards, ergonomics and RSI – the risks and keeping safe

Transcribing multiple voices – hints to make it easier

Why do transcribers charge by the audio minute? – explains it all

 
Leave a comment

Posted by on March 10, 2016 in Business, Transcription, Word

 

Tags: , , ,