I love Excel. How often have I said and posted some coll/nerdy thing about it!? Lots – I should make a formula to help me calculate the time 🙂
This is one that was bugging me for a while now. If you have an existing table with data in it how do you copy validation rules on top of the existing cells while maintaining their current value?
All the paste options don’t do this… but there is Paste Special. I had totally forgotten about it . For work, I needed this to work so I spent a bit of time trying to actually (finally) figure out how to do it.
As it turns out it is very simple: Paste Special has the option to paste validations. Done!
I wish I could not read emails. I have a compulsion where if I get an email I have to read the whole thing no matter how capricious or arbitrary. This post is not about that but it is about how to not mark emails as read just by clicking on them. I personally like the default behavior of Outlook but one of my clients doesn’t. Here is how to turn off marking emails as read just by clicking on them
In Outlook 2010, 2013 and 2016
- Go to the View tab
- In the Layout section click the down arrow beside the Reading Pane Icon
- Select Options
- Uncheck the Mark Item As Read When Selection Changes
That’s it! So easy 🙂
It has been the OS on PCs for over 30 years. In that time it has taken on a lot of “history” that may be holding it back. How to take Windows to the next evolution?
OneCore is a start – this is nothing new to us tech nerds. A slimmed down, module ready OS that can go from the nano IoT to the macro server datacenter.
Cool, but not new. Whats new? Andromeda OS. It removes even more unneeded and restrictive coding. Installing Windows on your phone – you don’t need x86 folder – so that’s gone. Think in terms of removing product skews entirely and having just Windows 10. Period. (Not sure how to best write that but you get the idea 🙂 )
Now think of this with the UWP – apps running in virtualized space – Mind Blown
People always want to know if their PC is running as fast as it used to. The quickest and easiest way to do that is by seeing how long the PC takes to boot. This is not the best way – easy is not usually the best.
If you want a real way to measure performance you need tools. Real tool. Enter Sysinternals. A suite of tools that really does the job. The one we will look at here is Process Monitor
- download the app
- Start Process Monitor
- Reset the view to default
- Click Capture to stop the current trace
- Deselect the events you dont want to log
- Click filter then Drop Filtered Event
- Go to Options and enable boot logging
- do not enable thread profiling events
- Click OK and the PC will restart
Now we look at the reboot
- go back into Process Monitor
- Reset filter if needed
- Save the trace
- Click tools then Process Tree
- Click in the far left for Idle
- Note the clock time
- Now in the process tree look for LogonUI
- Note the time stamp
Comparing these two time stamps really gives you an accurate measure!
Re-installing Windows 10 has never been easier! Are you excited!? I sure am 🙂
Check out this awesome step by step:
- Go to the Windows 10 download page: Download Windows 10 page.
- Click Download Tool Now
- Double-click the file to start the Media Creation Tool.
- Click Accept to the licensing agreement.
- Click Create installation media (USB flash drive, DVD, or ISO file) for another PC option
- Click Next
- If the files you’re downloading are for this device the PC will select the best options. Otherwise, clear the Use the recommended options for this PC option and fill in your options. you can also select “Both” in the Architecture section to use both 32 and 64 bit installer -useful if you plan to reuse the media on other PCs
- Click Next.
- Select USB flash drive
- Click Next.
- Select a removable drive
- Click Next
- Click Finish.
And there you have new Install media for Windows 10!
Apps running in the background slow down your PC and steal bandwidth. FIX THEM !!
- Go to Settings
- Background apps
- Turn off the apps that are allowed to run in the background
Another bandwidth/resource killer is syncing your apps. FIX THEM TOO!!
- go to Settings
- Then Accounts
- Then Sync your settings
Turn off all un-needed synchs
I didn’t like it with Windows 7. They did it right with Windows 8 and now they are ruining Windows 10. That’s right – I said Windows 8 was the way.
Product versions. There was a plethora of them in Win7 and it was hard to keep them straight. I like the limited set of OS choices in Win 8-8.1-10. It was easy and it worked.
Now MS has announced a new SKU for Win 10 – Win 10 Pro for Workstations. It offers some great tools
ReFS for more resilient file systems
Support for server class CPUs
These are all features the Pro SKU could use – why sell them separately…
This is pretty cool. Natively Windows 10 supports creating a hotstpot. The only limitation is your hardware
From an elevated command prompt type: NETSH WLAN show drivers
If it says that Hosted Network Supported: Yes you are able to setup a hotspot. Otherwise you will have to buy an external hardware network connection
Now type this: NETSH WLAN set hostednetwork mode=allow ssid=Your_SSID key=Your_Passphrase
This actually creates the hotspot. Change Your SSID to the name you want and change Your_Passphrase to the passphrase you want to use
Open network connections and you will see the connection listed.
Last step is to select the sharing option on the connection and allow other network users to connect through this network connection
How to back up your EFS encryption key
- Plug in an external device
- Go to EFS icon in the system tray.
- Click Back up now
- Click Next.
- Select the checkbox beside the Password.
- Type your new password in the Password field.
- Confirm the password
- Click Next the Browse.
- Go to the external drive
- Name the file
- Click Save then Next then Finish
- Click Finish.