How large can a document in Microsoft Word actually get? While most users never hit the upper limits, Word does have technical size restrictions that can affect performance, file stability, images, and long reports. Here’s what you need to know about maximum Word document size, file limits, and how to
Excel users are rightly interested in Lambda() a very powerful addition to Excel. Lambda lets you create user-defined functions without VBA. No need for .xlsm files with all the security concerns they entail. A long formula can be written once then referenced anywhere in the workbook by a short name of
Change Case options in Word, like many Word features goes beyond the obvious choices from the basic shortcut. There’s up to five choices on the ribbon with a keyboard shortcut to reach it. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE
A long-standing bug in Microsoft Word quietly breaks your document navigation when you place Heading styles inside a table. The Table of Contents shows all your headings correctly, but the Navigation Pane silently drops any heading that lives inside a table cell. The same broken behavior ripples into PDF Bookmarks
Learn how to create live, dynamic sorted lists in Excel using the powerful combination of Sort()/SortBy() and Filter() functions. In Excel 365 and Office 2021+ dynamic array formulas like FILTER() let you extract a subset of data — and by wrapping that result inside SORT(), you can instantly sort the
Microsoft’s Word Comments feature has popped up in the news again over the break, this time to embarrass Milo Yiannopoulos, a former Brietbart commentator. Mr Yiannopoulos is in a legal battle with his publisher over a proposed book and some of the court papers are now public. What’s catching attention
