RSS

Monthly Archives: June 2018

I want to publish my book but I’m confused! Do I need an editor, a line editor or a proofreader?

a hand writing in a bookI was recently writing back to a prospective client who had got very confused about the different types of editing and proofreading and the process needed for publishing their book. I sent them some resources from this blog and thought it might be useful to share those here, too.

So, here are some articles I’ve written about the different kinds of editing, the process of editing and proofreading (and where your beta readers fit in to that process) and how to make sure your editor and proofreader are, ahem, on the same page. At the bottom are two articles I’ve written about how to deal with an editor – that can feel like an alarming process in itself, so hopefully I’ll reassure you there!

This one talks about the different kinds of editing and proofreading (it’s biased towards fiction but also works for non-fiction):

https://libroediting.com/2014/05/22/do-i-need-editing-or-proofreading/

This one sets out the processes you go through and their order:

https://libroediting.com/2016/10/19/what-questions-should-i-ask-my-beta-readers/

It’s certainly best to have different people do the edit and final proofread, as it’s not great to have the same eyes going over and over a text (that’s why we can’t proofread our own work!). If you use two people for these stages, make sure your editor provides you with a style sheet to pass on to your proofreader – more on style sheets here:

https://libroediting.com/2016/01/14/what-is-a-style-sheet-for-people-using-editors/

And when you’re ready to talk to an editor (or proofreader), here are two articles explaining that side of the process, so you and your prospective editor can experience a smooth process and happy negotiation:

How to request a quotation from an editor:

https://libroediting.com/2016/11/30/working-with-an-editor-1-how-do-i-request-a-quote-from-an-editor-or-proofreader/

Ideas on negotiating and booking in your project:

https://libroediting.com/2016/12/07/working-with-an-editor-2-how-do-i-negotiate-with-an-editor-or-proofreader-and-book-my-project-in/

I hope you’ve found this very quick guide to dealing with the complexities of getting your book edited and proofread, and how to deal with contacting an editor, useful. If you have, please share this article using the buttons below, or leave me a comment. Thank you!
 
5 Comments

Posted by on June 27, 2018 in Copyediting, proofreading, Writing

 

Tags: , ,

How do I search in a whole workbook in Excel?

How do I search for a word or phrase across multiple sheets in a workbook in Excel 2007, 2010, 2013 and 2016?

Why would I want to search a whole workbook?

We think of Excel as being used primarily for numbers (although you might want to search for those, too), but I often encounter spreadsheets full of text. For example, when I’m localising text from US to UK English, or editing text that’s been translated, and it’s been output from a translation tool such as Trados, it often comes to me in an Excel spreadsheet.

Just like when I’m editing a Word or PDF file, I often want to either look for all instances of a word I want to change or check that I haven’t missed anything. And if that word might be in any one of many sheets in a workbook, I will want to search all of those sheets.

How do I perform a search in all the sheets of a workbook?

In this example, I want to find all the instances of the word “authorized” in all the many sheets in an Excel workbook.

First of all, press Control and F at the same time to bring up the Find and Replace dialogue box:

Using this search without changing anything will just search in the sheet I’m currently in.

Click on Options:

This brings up a load of options, including some other exciting ones we’re not looking at here, but which might be useful as well:

Click on the drop-down arrow to the right of Within: Sheet and change it to Workbook:

Now when you click “Find Next”, it will find the cell where that text is throughout the whole workbook.


In this article, we’ve learned how to search a whole workbook in Excel 2007, 2010, 2013 and 2016.

If you’ve found this article helpful, please do post a comment below, and if you think others would find it useful, please share it using the sharing buttons below the article. Thank you!

Other useful posts on Excel on this blog:

How to view two workbooks side by side in Excel 2007 and 2010

How to view two pages of a workbook at the same time

How do I print the column headings on every sheet in Excel?

How to print the column and row numbers/ letters and gridlines

How to change rows into columns and columns into rows in Excel

Freezing rows and columns in Excel – and freezing both at the same time

How to flip a column in Excel – turn it upside down but keep the exact same order!

 
Leave a comment

Posted by on June 20, 2018 in Excel, Short cuts

 

Tags: , ,