MS Excel 2016: How to Change Column Headings from Numbers to Letters
Source: MS Excel 2016: How to Change Column Headings from Numbers to Letters
Advertisements
Computing
Excel Comments – Macros
Excel Comments – Macros
Source: Excel Comments – Macros
‘Kudos: https://www.contextures.com/xlcomments03.html
Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub
Sub Comments_AutoSize()
‘posted by Dana DeLouis 2000-09-16
Dim MyComments As Comment
Dim lArea As Long
For Each MyComments In ActiveSheet.Comments
With MyComments
.Shape.TextFrame.AutoSize = True
If .Shape.Width > 300 Then
lArea = .Shape.Width * .Shape.Height
.Shape.Width = 200
‘ An adjustment factor of 1.1
‘ seems to work ok.
.Shape.Height = (lArea / 200) * 1.1
End If
End With
Next ‘ comment
End Sub
ntpquery Utility
Bytefusion’s ntpquery seems to be incredibly old, but works. Sadly, it requires initial installation, but the application files will work fine when copied to another system.
Source: How can I query an NTP server under Windows? – Super User
How to set (and change) an NTP time source in Windows Server 2008 R2 (SBS 2011 and Vanilla Server). – A Windows System Admin’s Blog
To query the time service:
w32tm /query /status
To change time service:
w32tm /config /manualpeerlist:<IP Address or Host Name>
Tip: After changing service IP/Host, run another w32tm /query /status to confirm the settings show the new time service IP/Host.
The difference between bandwidth and latency
What’s the difference between bandwidth and latency? By reading the definition of both terms above you probably already spot the difference between the two, but I’ll give you an analogy to make it easier to understand it if you are still confused. Imagine a highway with 4 lanes where the speed limit is 60 mph. Now on the Internet, bandwidth is the highway, and latency is the 60 mph speed limit. Now if you want to increase the amount of cars that travels through the highway you can add more lanes, but because the highway has too many curves, and bumps, you can’t increase the speed limit so all cars have to travel at 60 mph still. It doesn’t matter how many lanes the highway has, the cars will get to their destination at the same time regardless of the size of the highway!
Why increasing bandwidth increases download speed then you might ask, isn’t that speed? No, by increasing bandwidth you increase capacity not speed. Following the highway analogy, imagine that vehicles traveling through that highway were all trucks with house bricks for delivery. All trucks have to travel at 60 mph, but once they arrive at their destination instead of delivering 4 loads of bricks, 6 loads are delivered because 2 more lanes were added to the highway. The same thing happens when you add bandwidth to an Internet connection, the capacity is increased but the latency (speed ) stays the same.
Enable and disable your touchscreen in Windows 10
-
In the search box on the taskbar, type Device Manager, then select Device Manager.
-
Select the arrow next to Human Interface Devices and select HID-compliant touch screen.
-
Select the Action tab at the top of the window. Select disable or enable.
