ATOI365D#Office365Challenge By now most of us know that CTRL+F brings up Search in Office. When working with Excel, it’s important to know that it will only search the current sheet (by default).

Day: 228 of 365, 137 left
Tools: Excel
Description: Searching entire workbook in Excel

If you have an Excel workbook with multiple sheets, it’s great to be able to search for something and find it faster. Navigating to, and reading through it all is SO yesterday :-), so let’s get with the program.

When using CTRL+F in Excel it brings up the following box. This will search in the current sheet:

excelsearch1

If you click on the “Options” button, it will allow you to change the search area to entire workbook. You’ll also see the “Replace” tab at the top, where you can find and replace certain words etc.

excelsearch2

Thanks Office. It’s the little things…

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Advertisements