Restrict Editing to Parts of a Microsoft Word Document This tutorial will explain how to restrict editing to parts of a Word document. Step 1: With your document open, click the ribbon’s Review tab and then click the Restrict Editing button as shown below. Step 2: In the Restrict Editing task pane on the right… Read More »How to Restrict Editing to Parts of a Word Document
Automatically Refresh a PivotTable When its Data Source is Updated PivotTables require a refresh if the underlying data is changed or added to. This tutorial will explain how to automatically refresh your PivotTable using a few lines of VBA code. The solution will work when you change existing data or add new data. Follow the… Read More »Automatically Refresh a PivotTable When its Data Source is Updated
How to Use Excel’s TEXTJOIN Function =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) Excel’s TEXTJOIN function provides a quick way of combining values in different cells, like for example first, middle and surnames as shown below. This has always been possible in Excel but TEXTJOIN provides a better solution if you need to include a delimiter between… Read More »Combine Values & Delimiters Using Excel’s TEXTJOIN Function