In this post, I describe how to open a Microsoft Excel Worksheet as read only. This can be useful if you want to open a Microsoft Excel Worksheet on a shared folder without preventing another user from being able to edit the same spreadsheet. I'm using Windows 10 and Microsoft Excel 2019. Resolution To open a Microsoft Excel spreadsheet as read only, in Windows Explorer, hold the SHIFT key on the keyboard then right click the xlsx file to reveal some additional options: On my computer,  Open as Read-only  did  not  open the Worksheet as read only. However,  Open in Protected View  allows you to view the spreadsheet whilst also enabling another user to edit that spreadsheet. Open Read-Only You can force Excel to open a Worksheet as read only by: 1. Open Microsoft Excel. 2. Go to  Open  then  Browse . 3. Navigate to the Worksheet you want to open,  single click  the file to select it then click the down arrow to the right of the Open button: 4. Click  Open Read-Only . Excel shows it

In this blog post, I describe how to insert multiple rows, either above or below an existing row, in a Google Sheet. If you right click a row in a Google Sheet or press Insert then Rows , you will only be able to insert 1 row above or below the selected row: Resolution To insert more than 1 row above or below an existing row, whilst holding down the left mouse button (or using the SHIFT key), select the number of rows that you wish to insert, then either right click or press Insert then Rows .  Here, I have five rows selected, so I'm able to insert 5 rows above or below: The rows are inserted at the bottom of the selection if you insert below, or at the top of the selection if you insert above, as I've done here: Related Posts - You cannot delete a sheet with a linked form. Please unlink the form first.

In this post, I describe how to fix the error: Get-DnsServerTrustAnchor : The remote procedure call failed. Cause This error can occur when you try to get the DNS server trust anchor for a trust point with an invalid public key. This can occur in PowerShell or when scanning DNS using the  IT documentation tool  XIA Configuration Server. Resolution To fix this error, delete the DNS trust point with the invalid public key then recreate it with a valid key. Get-DnsServerTrustAnchor should now run without an error.

In this blog post, I describe how to find the folder an email is located within in Microsoft Outlook and where that folder is located in the folder hierarchy. If you search for an email in Outlook, you can open it, but it can be difficult to find out which folder that email is located within and where that folder is located in the folder hierarchy. Resolution To see where the email is located, open the email by double clicking it, then press CTRL  and SHIFT  and  F  together on the keyboard to open the Advanced Find window: The In: text box in the top right shows the name of the parent folder of the email - in the screenshot above, this is CRM . To see where that parent folder is located in the folder hierarchy, press the Browse button in the top right of the Advanced Find window. This will open the Select Folder(s) window which shows you where that folder is located: Related Posts - Microsoft Outlook 2019 Remove Mention Column Everywhere - Padding not showing on HTML buttons in e

CENTREL Solutions has released version 14.2 of their IT documentation tool XIA Configuration. This release includes the following functionality: - Microsoft DHCP audit and documentation tool . Improved support for Microsoft DHCP including IPv6 leases, policies, filters and multicast scopes. - The ability to compare Microsoft DHCP IPv4 and IPv6 scopes. - A new report showing your SSL and TLS to help audit Windows server security . - Improved support for scanning and documenting VMware systems . Download XIA Configuration v14.2 here > Request a free 30-day trial here >