RSS

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: , ,

What’s an acceptable error rate for an editor?

I have found this article from the marvellous industry journal copyediting.com considering acceptable error rates for editors extremely useful for sharing with clients and setting expectations. Although editors/proofreaders do tend to be perfectionists, we are human, and it’s good for us and our clients to remember this.

If a piece is full of errors, even a 99% accurate editor will leave some errors behind.

Read Adrienne Montgomerie’s article, “Error Rates in Copyediting” here.

 
Leave a comment

Posted by on May 31, 2018 in Copyediting, proofreading

 

Tags: , ,

Small business chat update – Shelly Terry

Small business chat update – Shelly Terry

Welcome to another update and a big change for one of our former crafty ladies, as this time round Shelly Terry from hand-made card company, Evelyn Mae, has become Shelly Terry from social media management and strategy and coaching company, Sheldon & Co. We first met Shelly back in in February 2013,  and then updated with her in March 2014, February 2015, April 2016 and, most recently, May 2017. At that point, Shelly was still making cards and was thinking ahead to shifts in her daughter’s routine and how that might affect her business, a very real concern for all those entrepreneur parents out there: “Next year I have a feeling it will all change when my daughter starts to drop her naps – I am hoping this is the same time she can attend nursery, so I can still have some designated work hours, but we shall see!” But what happened next? Something exciting, I think …

Hello again, Shelly! I suspect not, but are you where you thought you’d be when you looked forward a year ago?

Absolutely not! My daughter did indeed drop her nap, and I have a better pattern for working, but everything else about my business changed!

What has changed and what has stayed the same?

So I have a brand new business that I didn’t plan on having this time last year! In September a business friend asked for help with managing her business Facebook account, and I now run a business as a social media manager, strategist and coach! I help other entrepreneurs to manage their social media accounts, build Facebook shops and put a social media strategy in place and help them to create content for their online platforms.

I also run a free coaching group in Facebook which gives business owners support in creating content for their social media platforms, and guidance on developing strategy to implement in their own business.

What have you learned? What do you wish you’d known a year ago?

I have learned to plan my year better, this business is already out-doing my previous one, even after 8 months, so there is so much room to grow, that I need to be organised. I absolutely love it!

I wish I had known that I would find a career that was a surprise, but that I adored – I might have pursued it before it found me! I have had a variety of jobs in the past from college lecturer to actress, and it has surprised me to find a career that encompasses all of that!

Any more hints and tips for people?

Be as prepared and as organised as you can be for your business ideas, and work towards that ‘ideal’ business you have in your mind’s eye- but don’t be so blinkered that you miss other opportunities that you don’t even know exist yet!

And … where do you see yourself and your business in a(nother) year’s time?

We are moving house, so I envisage I will be working out of a new office space that is far tidier and more organised than my current one. I also hope to have some larger clients on books, as my daughter will have 15 hours of pre-school so I will have a lot more time to invest in my exciting new business!

I also plan currently to continue with my greetings card business for now – but I think at some point I will have to decide how viable it is along side my new business. Time will tell!

Wow – an impressive shift. I love what Shelly says about being organised yet open to new opportunities – I’ve often mentioned that a whole half of my business came about when I saw a tweet from a journalist I followed who needed a transcriber and thought “Why not put my audio-typing training to good use?” and now I spend half my time transcribing for journalists, academics and ghostwriters, something I’d have never imagined when I started out as an editor. Have a look at these lovely new links and I can’t wait to see what Shelly does with her new business!

… and her lovely cards still going at www.evelynmae.co.uk

If you’ve enjoyed this interview, please see more small business chat, the index to all the interviewees, and information on how you can have your business featured. If you’re considering setting up a new business or have recently done so, why not take a look at my books, all available now, in print and e-book formats, from a variety of sources. 

 
Leave a comment

Posted by on May 26, 2018 in Business, Small Business Chat

 

What else do editors and other small business owners do?

I haven’t got a Small Business Chat to share with you all today, so I thought I’d have a bit of fun and ask the editing and general small business community … what else do you do?

I’ll go first, shall I, then I’d love it if people shared in the comments. I’m looking for maybe surprising things you do outside of your job / business, whether that’s sport, crafts, volunteering or family responsibilities, whatever any of those things mean to you.

I’m an editor, proofreader, transcriber and localiser, and while my long-lasting hobby of reading All The Things (see my book review blog here) also keeps me sitting on my bottom a lot, my other hobby is running and all things to do with running.

So as well as running myself (I’m pictured here with running chums having done my third marathon, a DIY one), I’m a qualified Run Leader (so I can support groups of new and established runners), I’ve just qualified as a Level One Endurance Official (meaning I am working my way up through the levels of officiating at cross-country and road races), I regularly volunteer to lead runs and support beginners at my running club and I’m a committed parkrun volunteer. Keeps me busy and on my feet and outdoors, which is really important for balance in my life and keeping me socialised, too!

How do you keep balance in your life and switch off from your work responsibilities. Do share in the comments, and of course feel free to include your URL!

 
16 Comments

Posted by on May 5, 2018 in Uncategorized

 

What do I actually do? What do you actually do? Who does an editor or transcriber work for?

Taking a well-earned coffee break this week, my friend Jen challenged me to draw a Venn Diagram of what I actually do, for whom. I accepted the challenge.

Libroediting services venn diagram

Especially if you have a portfolio business, where you offer more than one service, can you draw out your customer base and services? How many attempts do you have to make (four for me!)? Can you see any patterns?

 

Tags: , , ,

Small business chat update – Kathy Ennis

Small business chat update – Kathy Ennis

Welcome to an update with Kathy Ennis, who changed her brand name to LittlePiggy last year. Kathy joined this interview series in May 2012 and we updated her story in July 2013, August 2014 and February 2016. and most recently in April 2017. At that point, this was Kathy’s plan for the year: I may be moving home in the next 12-months so, although I am planning, things may be disrupted because of that. However, my plan is to increase the amount of work with Enterprise Agencies, or other organisations that offer training and mentoring support for small and micro businesses.” Let’s see what happened next …

Hello again, Kathy! So, are you where you thought you’d be when you looked forward a year ago?

Well, I haven’t moved home (yet!) but it’s still in the pipeline – probably later this year.

I did achieve my goal of working with more Enterprise Agencies and those that offer mentoring support and training to small and micro businesses. I now have contracts with three organisations. Along with the 1-2-1 clients I work with this creates a really great mix and I get to meet some truly inspirational business people.

I am also really fortunate to be part of the Facebook / Enterprise Nation #SheMeansBusiness initiative. I spent 2017, along with 7 others certified by Facebook, delivering training and inspirational activities to more than 12,000 women in the UK (our target was 10,000, so we smashed it!). In 2018 the scheme is getting bigger and better with more trainers being taken on and a higher target number.

I did get my book published – The Big Social Media Marketing Organiser (https://littlepiggy.ltd/books/) – and I am really proud of it. I think it’s not only a terrific resource for all small and micro businesses, I believe it sums me up and demonstrates my approach to things.

What has changed and what has stayed the same?

Gosh, there have been changes, but they have crept up on me I think. The big change I made was more than a year ago – changing the name of the company – and I think that has had the most effect. My new brand and brand message has had a really significant impact on how I am working with clients and the type of clients I am working with.

What have you learned? What do you wish you’d known a year ago?

I’ve learned a helluva lot about Facebook! Being part of the #SheMeansBusiness team meant I had to take on a lot of knowledge about Facebook (and Instagram) really quickly.

I can honestly say that this year has been very steady. Nothing has cropped up that I was unprepared for. So there’s nothing I wish I had known a year ago.

Any more hints and tips for people?

Can I say buy my book? Ha, ha, ha!!

Seriously, if this year has taught me anything it is the need for businesses (especially small and micro businesses) to plan. I have lost count of the number of clients and trainees I have worked with who are having difficulties building their business successfully. When we dive deeper into what’s happening, it’s because things are being done piecemeal. There’s no broad understanding of what is actually happening in the business, let alone what they want to happen in the business. No wonder they are struggling.

And … where do you see yourself and your business in a(nother) year’s time?

Well, I hope to be living beside the sea by that time.

As far as the business is concerned, I just want things to tick along the way they are at the moment as it’s all so lovely at the moment.

It’s great to see Kathy going from strength to strength and really helping people with their planning, which is something a lot of people lack. I had to really plan my business in the early stages to see where I had to get to go full-time and I’ve always kept an eye on things and kept marketing even when I’ve been busy – it is worth it. Well done Kathy, and on the book, too!

Website: https://littlepiggy.ltd/

Facebook: https://www.facebook.com/LittlePiggyUK/

Twitter: https://twitter.com/kathyennis

LinkedIn: https://www.linkedin.com/in/kathyennis

Email: kathy@littlepiggy.ltd

You can find the website for Kathy’s book here, and order it from Amazon.

Phone: 07815951585

If you’ve enjoyed this interview, please see more small business chat, the index to all the interviewees, and information on how you can have your business featured (I have a full roster of interviewees now so am only taking on a very few new ones). If you’re considering setting up a new business or have recently done so, why not take a look at my books, all available now, in print and e-book formats, from a variety of sources. 

 
Leave a comment

Posted by on April 21, 2018 in Business, Small Business Chat

 

Tags: ,

Small business chat update – Sophie Playle

Small business chat update – Sophie Playle

Welcome to an update with  Sophie Playle, editor and trainer of editors from Liminal Pages,  We first met Sophie in December 2013, at which point she’d only been going for eight months, Sophie updated us on how she was getting on in January 2015, March 2016, and most recently March 2017, where this was her plan: “This time around, I’m not going to make any grand statements or plans. I’m going to get my head down and continue doing what I’m doing – providing editorial services to authors and online training to editors – and see where it gets me. I share my most personal thoughts on being an editorial business owner in my Liminal Letters, which I send out roughly every fortnight, so if anyone wants to keep up with my journey, feel free to subscribe!” So, did things go to plan or did they change? Read on to find out …

Hello again, Sophie! So, are you where you thought you’d be when you looked forward a year ago?

Pretty much! I’ve just kept on keeping on. My schedule has been filled solid with editing work, and I’ve continued to create and run courses for editors. I haven’t quite managed to create and refine as many courses as I’d hoped by now – I always seem to make big plans and run out of time!

What has changed and what has stayed the same?

For the first time in a long time, pretty much everything has stayed the same. It’s a relief to feel some stability in my business, to be honest. At the same time, I don’t feel a though I’m stagnating. I’m continually tweaking and improving my work flow, brand, website, courses, skills, etc.

What have you learned? What do you wish you’d known a year ago?

I don’t think there’s anything that’s made me think Darn, if only I’d know that … We can’t learn everything all at once. Sometimes the time isn’t right for the lessons we need. Often, we learn through trial and error – because there’s no one-size-fits-all way to run a business.

Any more hints and tips for people?

There’s no such thing as a ‘finished’ or ‘completed’ business. You have to keep chipping away at things, refining and developing. At times, it can feel frustrating that the work is never done, but try to enjoy the process, celebrate the small wins along the way, and be kind to yourself.

And … where do you see yourself and your business in a(nother) year’s time?

Where I am now, but better.

I actually loved it when things stabilised for me, a few years of full-time self-employment in, when you know what to expect and when you’ll be busy. Like Sophie, things have still changed for me, but in more minimal ways, for example starting to pick up more work for a) ghostwriters and b) university academics doing large projects, which is an extension of my transcription work and tends to come through recommendation. I love that Sophie is still finding time to help her fellow editors along the way, too, and sharing her experiences in her usual honest way.

Visit Sophie at her Liminal Pages website: http://liminalpages.com or find her on Twitter or Facebook!
Facebook:

Sophie’s website is at liminalpages.com and that novel-writing course can be found here: Conquer Your Novel

If you’ve enjoyed this interview, please see more small business chat, the index to all the interviewees, and information on how you can have your business featured. If you’re considering setting up a new business or have recently done so, why not take a look at my books, all available now, in print and e-book formats, from a variety of sources. 

 
2 Comments

Posted by on April 14, 2018 in Business, Small Business Chat