Office Watch – Office Watch

How to use AutoCorrect for more than a word or single character. It can speed up typing of large blocks Read More The post AutoCorrect is great for larger blocks of text & acronyms in Word ap...

https://office-watch.com/2021/autocorrect-for-larger-blocks-of-text-and-more/

Flash Fill is a simple way to split and join text automatically in Excel for Windows or Mac. Flash Fill Read More The post Flash Fill Magic in Excel appeared first on Office Watch .

https://office-watch.com/2021/excel-flash-fill-magic/

How to compare one set of numbers with another list of values using ChiTest() in Excel. ChiTest() or ChiSq.Test() sounds Read More The post Easily compare a series of values with ChiTest() Exc...

https://office-watch.com/2021/comparing-series-of-values-in-excel/

A simple question – what characters can you put in an email address? Like many things to do with the Read More The post What can you put in your email address? appeared first on Office Watc...

https://office-watch.com/2020/what-can-you-put-in-your-email-address/

Find or change many web links in Word documents using the Replace command, here’s the trick. For example, you might Read More The post The trick to Find or Replace web links in Word appeare...

https://office-watch.com/2020/find-and-replace-links-in-word-documents/

Excel’s Sparklines have a good range of options for highlighting high and low values, text or calculated overlays, changing axis Read More The post 8 tips for great Excel Sparklines appeare...

https://office-watch.com/2020/sparklines-excel-tips/

How many rows and columns does Excel have? All the talk about 64-bit versions of Office has raised the issue Read More The post Excel - a history of rows and columns appeared first on Office ...

https://office-watch.com/2020/excel-a-history-of-rows-and-columns/

A strange name but Sparklines is a useful new part of Excel which makes simple single-cell graphs in Excel for Read More The post Sparklines make simple graphs for Excel appeared first on Off...

https://office-watch.com/2020/sparklines-in-excel/

How you choose to make a PDF file from Microsoft Office can make quite a difference to how the PDF Read More The post Two choices to make a PDF - Save or Print? appeared first on Office Watch...

https://office-watch.com/2020/choices-make-a-pdf-file-save-or-print/

Which version of alphabetical order does Microsoft Word use? I thought that alphabetical order was, well, alphabetical order. That’s what Read More The post WTF? Word's Alphabetical order is...

https://office-watch.com/2020/alphabetical-order-in-word/