Windows 10 New Features - Windows Spotlight - Lock Screen Customization

Windows 10 Version 1511 and Build 10586 now provides a new feature called Windows Spotlight. If you have already upgraded to
the latest build, then let’s go and take a look how to enable and use this feature.
  • Right-click on an empty area of your Desktop and then click Personalize.
  • From the Personalization Settings window, click Lock Screen from the left side pane and make sure to choose Windows Spotlight from the Background drop down menu.

Windows Spotlight

When you select this option, you will see a new beautiful wallpaper in the preview pane. These stunning images are provided to you by Bing.com to be displayed on your Windows Lock Screen. If you think, those images will look nice on your lock screen, then just and apply the changes with the Windows Spotlight feature, and the next time when you will be on your Windows Lock Screen, you will see those images as a background to your Lock Screen.
  • Press Windows+L key to instantly move to Windows 10 Lock Screen or alternatively, you can click the Start button and then click User Name and then click Lock.

Windows 10 Lock Screen Windows Spotlight
Windows Spotlight also provide you the ability to rate those pictures, and see more of them on a regular basis.
  • At the Lock Screen, you will find two options at the top right corner under “Like what you see”, and you can tell Bing that, either you liked the current wallpaper or not.
  • If you like then you can rate that picture, and Windows will occasionally show you more of that kind of pictures on your Lock Screen, or you can tell Window that you are Not a Fan, and instantly you will see another stunning wallpaper right away.
Windows 10 Lock Screen
How to Download and Save Windows Spotlight pictures?
The next part is for curious users, who wants to know that where Windows saves all these amazing images, so they may save them to their wallpaper collection. To save Windows Spotlight images, you need to navigate to the following folders.

  • Open Windows Explorer, and navigate to the drive where Windows is installed, which usually be drive C, and then open the Users folder.
  • Here you need to open the folder corresponding to your User Name, which in my case is The Teacher. Windows Spotlight images are stored in App Data folder, which is a hidden system folder, so to view this folder, you need to turn on Show Hidden Files option, which you can easily do by clicking on the View menu, and then make a check mark on Hidden Items under Show / Hide section.


  • Now open the App Data folder, and then open Local subfolder. Under Local folder navigate to Packages, and here you
    need to find a folder naming, Microsoft Windows Content Delivery Manager, ending with CW5N1H2TXYEWY. Then move to Local State, and lastly the Assets folder.
  • C:\Users\TheTeacher\AppData\Local\Packages\Microsoft.Windows.ContentDeliveryManager_cw5n1h2txyewy\LocalState\Assets

The first thing that you will notice here will be the unusual file names, no preview and no file extension at all. We will talk about this later, let’s first see what you need to do here. First, I will advise you to sort this list according to the file size, so you may see those files first, which are larger in the size, and the second step is to copy these files. I think, you should copy only those files which are larger than 100 KB, because everything here is not necessarily the Windows Spotlight images.

So, I copy those images which I think will be Windows Spotlight images as they are larger in size, and then I paste them inside a folder, and here we go, creating a new folder on the desktop, and pasting all of them here. Once you finished copying and pasting
those files, now it is time to rename them, and give them an appropriate file extension.
Copied Spotlight Images to New Folder

  • To change the first name of all the files at once, select all of them by pressing Control+A keyboard shortcut, or click Select All from the Home tab. Right-click on any one file, and choose Rename from the context menu.

Windows 10 Spotlight Images

  • As I type a name like, Windows Spotlight to one of the selected files, and as soon as I hit the Enter key, Windows will rename all of them automatically with the same name, while giving a number at the end. So this is an easy and quickest
    method to rename a bunch of files at once.

Windows 10 Spotlight Images

Now it is time to give all them an appropriate extension, so the Windows app may recognize these images files, and also Windows will start showing you the thumbnails right away! As these image files does not have any extension, in Windows you cannot change the extension of multiple files at once. Like you can surely give an extension to a single file by applying a period sign in the end of the file name, and then either give it JPG or a PNG extension. But you can not do this on multiple files, as we recently did for the first name.

So, to do this, you need to take the help of Windows Command Prompt, which is also my favorite since my early days of computing. To open the Command Prompt:
  • Right-click on an empty area of the folder while holding down the Shift key and you will see a new option in the Context Menu, Open Command Window Here. Click this option and you will be at Command Prompt, while residing in the same folder.

Open Command Window Here

  • To change the extension of all the files at once, type the following command:
  • rename *.* *.jpg and hit the Enter key.

In an instant, in the background, you can see Windows will start showing you the thumbnails of all the pictures, that means you did it the right way. Each picture is available in both, Landscape and Portrait style, depending on your Windows 10 Device size or position, you can choose which one to set as a Background.
Rename Command
This was all about using Windows Spotlight feature, and saving those images to your collection. You can also watch the following video to learn everything visually.

Microsoft Word 2016 Tutorial - Show Hide Text in Word Document

When using Microsoft Word, sometimes you may be in a situation, when you don’t need to print or view certain parts of your document, but you don’t want to delete them either. This is the time, when you can use Show / Hide Text feature of Microsoft Word.

For instance, in this Standard Feed file, I need to print two versions of this document. The first copy of print out will be as it is, but for the second copy, I don’t need these Terms and Conditions lines to be printed. But I don’t want to delete them either. So what I will do is to hide those text lines, instead of deleting them. So, let’s get started and learn, how to hide and unhide text, and how to print a document with and without the hidden text.
First, select that particular text area that you wish to hide. Now, right-click on the selected text, and then click Font from the context menu. From the Font window, under Effects section, make a check mark on Hidden, and then press OK. That’s it. The selected text is now no longer be visible in your document, and if you see the Print Preview of this document, you can notice that particular text is also not visible in the Print Preview window, and will not be printed either.

So you can go and print one version of this document, without the hidden text. But for the second print copy, where you need to print the hidden text as well, then you can do this either by two ways. The first method is, you can change the printing options alone, and tell Word to print the hidden text as well, and you will no longer be require to unhide the text before printing. It is useful when you only need to print the hidden text for print out only, but what the text remain hidden in the document itself.

The second method is, as you may have already guessed, is unhiding the hidden text, and then take the print out. So in both cases, choice is yours. Let’s see the first method, where I want to print the hidden text, without actually unhide it. To do this, go to Print dialog box, either by pressing Control + P keyboard shortcut, or you can click the File menu, and then click Print. From the Print window, click Page Setup link. Select the Paper tab, and then click Print Options button from the bottom right corner.

Make sure Display is selected from the left side pane, and from the Printing Options section, make a check mark on, Print Hidden Text. Press the OK button. You can instantly see that the hidden text is now visible in the Preview Pane with the dotted lines underneath. So this way, you can directly print the hidden text, if you don’t want to unhide the text before.

But when you actually need to unhide the hidden text, then you can also do this by two ways. Do note that, to unhide the text, you require to select the above and below area of the hidden text, but you may not actually remember, or forgot that, where the hidden text was. So what you can do is to select the entire document, then right-click and choose Font. You can notice that, the Hidden option now has a black square instead of a check mark. This is because you selected hidden and non-hidden area of the document. Click the Hidden option once, and it will change into a check mark, and click it again to uncheck and apply the changes.

The only problem unhiding text with this method is, you may be unhiding all the hidden text, even if you don’t want to. Like, if you had made hidden separate areas of your document, then using this technique will unhide all of them, even if you only want to unhide specific text.

So how you can unhide a specific hidden area?

For this, you need to turn on another Microsoft Word feature, called Show / Hide, and it is available on Home tab, under Paragraph section. Click this button once, and it will start showing you all the paragraph marks in your document, including the hidden text with dotted lines underneath.

So now, to unhide a specific hidden text area, now you have the option to select that particular hidden text alone, and can then unhide that particular text.


Expand Taskbar on Multiple Monitors - Windows 10 / 8 Tutorial

If you are using Multiple Monitors on
a Windows 8 or Windows 10 PC, then you have the opportunity to expand Taskbar
on Multiple Monitors, and that is without using any third party application. In
this tutorial, you will learn to expand Taskbar on Multiple Monitors, and we
will also learn to configure some other settings for Multiple Taskbar.

To expand Taskbar over Multiple
Monitors, right-click on an empty area of your Taskbar, and then click
Properties, and here is that setting that you need to expand your taskbar over
Multiple Monitors. Show Taskbar on All Displays, make a check mark on this
option, and apply the changes, and in an instant, you can see that your Taskbar
is expanding over to all the monitors attached to your PC. But that is not all,
here are a few more settings that you can configure according to your

If you expand the “Show taskbar
buttons on” drop down menu, you will find 3 different settings here. If you
have selected the first option All Taskbars, which will also be the default
option, then you will see that the Taskbar has expanded to Multiple Monitors,
and showing you all the open applications icons on each taskbar, including the
Pinned items on the taskbar.

But if you don’t prefer to see the
Pinned Items on every taskbar around Multiple Monitors, then you can go for the
second option which is, Main Taskbar and Taskbar Where Window is Open”. Let me
explain you that, we refer Main Taskbar to as the Taskbar which has, System
Tray available on the bottom right corner including a Clock, Action Center and
other icons. You can see that the System Tray and Pinned Items will only be
available for your main display alone. If you go with this setting, then you
will only see opened Application Buttons on the Main Taskbar, and on the Taskbar
for the monitor from where that application has been opened. For instance, if I
open an application using the Start button of my second monitor, or even if I
move an application from main display to second monitor, then you will see open
app icon on the Main Display, and on the taskbar of that monitor where
application is opened or being shifted. Like, I will only see this Microsoft
Word and Notepad icon on my Main Display and Second Display Taskbar, and these
two taskbar icons will not be appearing on third or any other monitor.

If I go with the last option, “Taskbar
where window is open” and apply the changes, you can see that both, Microsoft
Word and Notepad Icons are only available on second monitor, and they are no
longer visible on my Main Display. This option is useful if you want to see the
open application icons only on those Taskbars, from which particular monitor
they have been opened. If you work with a lot of applications, then you may
find separate opened applications icon for each individual taskbars.

So this is how you can expand and
customize the Taskbar behavior over Multiple Monitors. 

Windows 10 Desktop Customization - Span Wallpaper Across Multiple Monitors

If you have already configured and
setup multiple monitors on your Windows 10 PC, then you might want to have a
nice wallpaper for each monitor, but what about spanning a single wallpaper on
dual monitors? That’s right, you can span a single wallpaper to multiple
monitors using a simple Windows option.

To do this, right-click on an empty
area of your Desktop, and then click Personalize. If you just want to set a
single wallpaper at all, then from the Background drop down menu, choose
Picture and then browse for the picture, that you want to have as a wallpaper
on multiple monitors. Now from the Choose a Fit drop down menu, select Span and
that’s it! That single wallpaper will be expanded to your multiple monitors.

It is better to download high
resolution wallpapers, and you can use your favorite search engine to download
Dual Monitor wallpapers. You can also save dual monitor wallpapers to a folder,
and then choose Slide Show from the Background option. Select a time period
after which you want windows to change the wallpaper automatically, and if you
don’t want to see those wallpapers in sequence, then you can turn on Shuffle
option as well. Make sure Choose a Fit option is still set to Span. You’re all
done now. Close that window, and see your high resolution spanned wallpapers on
multiple monitors.

Windows 10 Tutorial - How to Setup Multiple Monitors

Hello everyone, and welcome again! In
this Tutorial, we will learn, How to Setup Multiple Monitors in Windows 10.
Before setting up multiple monitors in Windows 10, I assume that you have
already connected an additional monitor to your computer, either it is a
notebook or desktop, and have properly plug-in all the wires, and you may also
require to configure some BIOS settings as well, to Enable Dual Monitor

For instance, on my ECS, A55 F2,
motherboard, I have to configure my BIOS to enable, Dual Monitor support, and I
have connected one monitor on inbuilt VGA port of the motherboard, and the
second monitor is connected to AMD Radeon R7 200 Series PCI Express Card.

If you have properly connected both
monitors, and have also configured the BIOS settings properly, then you don’t
need to configure anything in Windows itself. When you connect an additional
monitor to your computer or notebook, Windows 10 automatically detects the
additional monitor, and start displaying your Windows desktop automatically.

However, you can configure some
Multiple Monitor settings according to your preferences. To do this,
right-click on an empty area of your Desktop, and then choose Display Settings
from the context menu. If Windows has already detected and installed the
additional monitor drivers, then you will see one and two number in the preview
pane, indicating that Windows has already detected and setup multiple monitors.
If you are still seeing only one number in the preview pane, then you can click
Detect link, and Windows will try to look, if there is an additional monitor
has been connected. If Windows fails to detect any additional monitor even if
you have properly plug-in all the wires, then you may need to look into your
BIOS Settings for any Dual Monitor support option, or you may also require to
install the add-on VGA Card drivers, where you have plug-in your second
Once you are done, and Windows
detected both the monitors, then it is the time to configure some additional
multi monitor settings. Clicking on Identify link will display numerical number
1 and 2 on both monitors, telling you that Windows is assuming which monitor as
number one, and which one the number two. If number 1 and number 2 monitor are
not as you want, like you want the number 2 to be number 1, and number 1
monitor to be number 2, then you don’t need to change wire settings, or
monitor’s positions. You can do this right from the Display Settings window. To
change the position of monitors in Windows, simply drag and drop the monitors
in the preview pane, and you don’t need to change the position of monitors
physically. This setting determines that which monitor is setup on your left
side, and which one is on the right side.

But the next problem could be that,
you might want to set the number 2 display as your Main Display. Then just
select the 2nd computer from the preview pane, and then click “Make this my
main display”. Apply the changes, and in an instant, your main desktop with all
its icon and the taskbar will be shifted to your second display, which you just
made as your main display. You can revert back anytime, by making your 1st
display as the Main Display again.

Depending on either you have connected
two display to a desktop computer, or with a notebook, you might see different
or additional options under Multiple Displays drop down menu. Like, as I have
connected these two display with a Desktop computer, I have these 3 options in
the list.

The first option is, Extend these
displays, which is usually will be the default option for Desktop computers
with multiple displays, and is widely used everywhere. This option extend the
windows display to both monitors, and ultimately giving you larger area for
work. Let’s first apply this setting, and see what we can do with extended display.
The best thing that you can do with
multiple monitor with extended display is, you can move applications between
both display. To move an application to other display, just grab it from the
top edge or title bar, and drag it from one monitor to another. That’s it! So
multiple monitors will make it easy for you, when you need to have an eye on
one screen, and work on the second at the same time. Ultimately making you more
productive when you need to work with a lot of apps in a time, and you may not require
to minimize certain applications, or switch between apps when you need to work
on at least two applications at the same time. You can even play a video on one
screen, and can work on your office application at the same time on other

For any reason if you want to switch
back to one screen, then you can do this from the Display Settings window
without actually disconnecting any monitor. From the Multiple Displays drop
down, choose which monitor you only want to see, either number 1 or number 2,
and the other will be switch off right away.

Then you have the option to change the
Orientation of monitors. In Orientation you have four options, Landscape, which
will be the default for wide screens, then you have Portrait, and then Portrait
Flipped, so Landscape Flipped.

If your both monitors have wider
screens, then you may not require to change the orientation, as the Landscape
is best option for wider screens, until you have settle your monitors in a
different position. For instance, if I have to rotate and place one of my
monitor in vertical position for some reason, then I can change the orientation
from Landscape to Portrait, so the contents can be fit and seen nicely on that
particular monitor, and there you have the example right away.

And for any reason, if you have to
place a monitor on a 360-degree rotation, like completely upside down, then you
can use the options, Landscape Flipped or Portrait Flipped, where Windows will
rotate the display to 360 degrees on an upside down monitor, and you will be
able to see the contents properly.

If you need to configure more Advanced
Settings, like Screen Resolution, Color and Text settings, then you can click
the Advanced display settings link, and here you can choose different
resolution for both monitors, if they are different in sizes, or can configure
color and text settings as well.

People having accessibility problems
can also enlarge the size of text, applications and other items that they see
on the screen from the previous window. Changing this setting might require you
to log out and login back to your user account.

To quickly switch between different
multiple monitor settings, you can also press Windows + P key to bring some
multiple monitor options. As I told you before, depending on either you are
setting multiple monitors with a Desktop or Laptop, you might see different
settings accordingly.

So this was an overview about Setting
Up Multiple Display on a Windows PC. 

Windows 10 Tutorial - Verify Your Identity On This PC

If you have recently upgraded to
Windows 10, or did a clean install from scratch, and already using Microsoft
Account to login into your Windows 10 device, then you must verify your
identity on that particular device. Verifying your identity helps you to protect
your data. In case, Microsoft detects any suspicious activity, then the user
will be asked to enter a security code, which Microsoft will send to your
Microsoft Email Account, or to the phone number that you provided in your
account security information.

You may have already seen a
notification regarding verify your identity, but if you have missed it, then
you can still do it by either of two ways. The quickest methods is to click the
Action Center button from System Tray, and you may see a notification regarding
verify your identity on this PC, or you can click the Start button, and then
click Settings. In Settings window, click Accounts and you will see a message
stating, you need to verify your identity on this PC, and there will be a
Verify link below the message. Click the link, and you may require to enter the
last 4 digits of your phone number, and a code will be sent to your registered
mobile number. Enter the code and complete the verification process. That’s it!

Once you complete the verification
process, Verify your identity link will disappear, and you will only see Manage
My Microsoft Account link. From a security point of view, I will suggest you to
verify your account immediately.

Windows 10 Tutorial - Set Different Wallpapers on Multiple Monitors

Hello everyone, and welcome again! In
this tutorial, you will learn about setting up different wallpapers on multiple
monitors, using Windows 10. In Windows 8, you can easily set different
wallpapers for different monitors by just right-clicking on a particular
picture in Desktop Background window. But this option has been slightly changed
in Windows 10. The entire Personalize window now has a new look, and you will
not find the same Windows 8 option here.

In Windows 10, it is much easier to
configure separate wallpapers on different monitors. So, to set different
wallpapers for different monitors, first open the folder where your pictures
are stored. Now, select at least two different wallpapers by clicking left
mouse button while holding the Control Key. Now, right-click on one of them and
choose “Set as desktop background” from the context menu. That’s it, and you
now have two different wallpapers for both monitors.

To cycle through next wallpaper for
any particular monitor, right-click on Desktop, and choose “Next Desktop
Background”. If you had selected just two wallpapers, then Windows will only
cycle through those two wallpapers. If you want to cycle through more
wallpapers, then select as many wallpapers you want while setting a desktop
Do remember that, Windows 10
automatically support different wallpapers for different monitors, and you
don’t need to configure anything special. You only need to take care of one
thing, and that is, if in Personalize Background window, if you change the
Background from Slideshow to Picture, then you can notice that, “Next Desktop
Background” option will no longer be available in context menu, when you will
right-click on your Desktop. The Next Desktop Background option only appear, if
Slideshow option is set in Background. Choose Slideshow and configure the
picture folder of which images you want to see on your desktop. That’s it and
nothing else you need to configure. Now right-click on any desktop and choose
Next Desktop Background, and you can cycle through images.

If you need to see the old Windows 8
style Personalize Background window, then you can do this by typing the
following command in Run dialog box:

control /name
Microsoft.Personalization /page pageWallpaper

So this was all about setting different
wallpapers on multiple monitors in Windows 10. 

Windows 10 Tutorial - Change Mail App Sync Settings

Hello everyone, and welcome again. A
lot of users where complaining about Windows 10 Mail App, as the Mail Box
Synchronizing Settings were not working up to the mark. I was always receiving
an error code message, whenever I tried to change the mail synchronize
settings. But the good news is, with the latest Windows 10 Version 15-11,
Microsoft has worked on this problem, and now the mail synchronizing settings
are working like a charm.
Let’s see, how to change the Mail App
Synchronizing Settings, so you may update yourself as the new mail arrives into
your Inbox. To do this, click the Start button, and then click Mail, if the
tile is available right on your Start Screen, else you can find it on All Apps
section, and can also pin it to your Start Screen.

Once you are in Mail App, click the
Settings button from the bottom left corner. From the right side Settings pane
click Accounts, and then select the Account for which you want to configure
Mail Sync Settings.

From the Outlook Account Settings
window, click Change Mail Box Sync Settings option, and here you can configure
different settings according to your requirements. Like, I want to be notify
and receive every new mail that arrives, instantly into my inbox, so I change
the Download New Content settings to, As Items Arrive, and I also make a check
mark on, “Always download full message and Internet Images” as I want to read
the entire mails from the Mail App itself, but if you have a metered or slow
connection then you can uncheck this option, if you just want to read the text

Then you have “Download Email from”
option, and here you can configure that for what previous period emails you
want to download from your email server into Mail Client. As I change this
setting, you can see that Mail box instantly download the mails for my email
server to the Mail App for the said period of time.

Below is the mail server address, and
that you can configure if you are using any special configurations. As I apply
the changes, and to give you a demo, I send an email to this address from some
other email ID, and you can see that the email instantly arrives in the inbox.
Even if the Mail app is not running, you will see an instant notification in
the Action and Notification center.

So in my opinion, Microsoft has
seriously updated the known issue in Mail App, and now you may give it a try
and see if it works for you.

Windows 10 Tutorial - How to Check Windows Version, Edition and Build

In Windows 10, if you want to find out
that which version, edition and build of Windows 10 is currently installed on
your system, then you can know this by either of two ways.
The first way to find this out is to
use WIN VERSION command. Click the Start button, and type WIN VER, right into
Taskbar search window, or press Windows + R key to open Run command, and then
type WIN VER, and press OK Button. Here you can find out the exact windows
version and build that is currently installed on your system.

The second method to get this detail
is through Settings window. Click the Start button, and then click Settings.
Click System and then from the left side pane click, About, and here is the
information that you need. Do note that, in previous build or versions of
Windows 10, you may not get exactly the same report as you are seeing in this
latest 15-11 version, and build 10-5 86.

If you want to check that if the
latest version or build is available for your PC or not, then you can do this
right from the Settings window, by clicking on Update & Security, and then
click Check for Updates. If you have recently upgraded to Windows 10 from
Window 7 or Windows 8, then you may have to wait for at least 30 days to get
the latest build.

Windows 10 Tutorial - Set Time Zones Automatically - New Features

With the release of Windows 10
November Update version 15-11, Microsoft has introduced several new features in
Windows 10, and one of them is automatically synchronizing Time Zone according
to your device location. However, in previous versions of Windows, you can set
the Time Zone manually, but now Windows provides you to do it automatically. It
is a very much helpful feature if you travel a lot and you want Windows to
configure the time zone and update the date and time automatically.

To configure Time Zone
Automatically, click the Start button, and then click Settings. Click Time and
Language, and here you can find the new option called, Set Time Zone
Automatically. Turn On this feature by toggle the switch to ON position. That’s
whatever it takes to configure automatic time zones. Do note that, Set Time
Automatically feature must be ON as well, so Windows may update the date and
time according to time zone and your physical location.

Now, wherever you will take your
Windows 10 powered device, Time Zones will get automatically changed according
to your device location, and you will always have an accurate date and time
prediction right on your system tray.

Windows 10 Tutorial - Configure Windows Updates

Hello everyone, and welcome again!
Windows 10 occasionally checks with Microsoft Servers, if there are new Windows
10 updates available, and if any new updates are offered by Microsoft, then
Windows automatically download and installed the new updates for you.

But you can also manually check for
new updates for Windows 10. To check Windows 10 for new updates, click the
Start button, and then click Settings. From the Settings window, click Update
and Security Settings, and then click Windows Update. Under Windows Update,
click Check for Updates link.

If any new updates are available, they
will be offered to you for download and install. If you need further
information about any update, you can then click on Details link. Microsoft
gives each update a Knowledge Base number, and to learn more about a Knowledge
Base Update, you can use your favorite search engine for the same.
If Windows updates displays that your
PC is up to date, it means that all the updates which were available are
already installed on your system.

You can also configure some other
Windows Update settings by clicking on Advanced Options. Here you can specify
that either Windows download and install the updates automatically, which is
already the default option, or it notifies you about when your computer needs
to be schedule for restart.

You can also ask Windows to check for
updates for other Microsoft Products while updating Windows. You can even tell
windows to defer upgrades, which means that Windows will not installed any new
features for several months. Like, Microsoft recently released new version and
latest build of Windows 10. If you defer windows upgrades, then those kinds of
new features will not be available to you automatically for several months.

From Advanced Options window, you can
also view your windows update history by clicking on, View your update history.
Here you can see that which updates have been installed successfully, and which
updates get failed to installed. Windows will retry to install the failed
updates when the next time you check for updates.

If you click the Uninstall Updates
link, then it will open Program and Features applet of Control Panel, from
where you can uninstall all, or a specific windows update. You can even
uninstall the latest preview build of Windows 10, and can revert back to the
previous release.

If there are more than one PC using
Windows 10 over your local network, then you can also configure that Windows
Updates are delivered throughout your network. If you turn on this feature,
then your PC may get or deliver Windows Updates to or from other Windows 10
computers available on your network in addition to Microsoft Servers. This
feature can help speed up the update process, when your local area computers
will be exchanging windows updates with each other, instead of separately
downloading from Microsoft Update server.
If you are interested in testing the
new Windows Insider Builds, then you can also configure the setting by
clicking, Getting Started under Get Insider Preview Builds. But do note that,
there could be some major consequences to upgrading to Insider Preview Builds,
as these builds are not fully tested and you may require to completely
reinstall the Windows from scratch if something went wrong. You should not try
this feature on your regular working computer.

If you think that the latest build is
giving you problem and not working as the way you want it, then you can also
revert back to the previous Windows Build. For instance, I recently upgraded to
latest Windows 10 Build, 10586. So if I plan to revert back to the previous
build, I can do this right from the Settings window, by clicking on Recovery
from the left side pane. Here I can ask Windows to revert back to previous

So, this is how you can configure
Windows 10 Updates and you have the choice to update Windows automatically or

Microsoft Excel 2016 Tutorial - Hide Unhide Columns & Rows

In Microsoft Excel, if you don’t need
to see certain columns and rows for the time, or if you need to print your
worksheet but don’t want a few columns or rows in the printing, then you can
hide those columns and rows instead of deleting them. Hiding columns and rows
preserve the data within them, and the formulas used in those columns or rows,
will still be functional.

For instance, let’s see print preview
of this worksheet. As you can see that all the records are fitted properly on
page according to page length, but a few columns are getting extended to second
page. I don’t want a few columns to be printed. Like this “Province” column, I
don’t want to print this column, so what I do is, I select this column and then
click Format under Cell section of Home tab, then point to Hide and Unhide, and
then click Hide Columns. The another quick way to hide a column is to use
right-click context menu. For example, I don’t want this Discount column
either, so I right-click on column G, and then click Hide.

You can follow the same procedure to
hide specific rows in your worksheet. For example, I don’t need to see or print
this 5th record of customer name Carlos. So to hide this entire row, I can
either select the row first, then click Format, then Hide and Unhide, and
choose Hide Rows, or I can directly right-click on that particular row and
choose Hide from the context menu.

If you want to select and hide more
than one column or row in a time, then what you only need to do is to select
multiple columns and rows at once, then use the hide columns or rows command

But what if, the columns or rows that
you want hide, are not in continuous order. To select non-continuous multiple
columns and rows, you can use the control key. For instance, if I need to hide
Order ID and Ship Date columns, what I do is, I select the column B first, then
press and hold the Control Key, and then click Ship Date column. The same
method goes with rows. Select the first row, then press and hold down the
Control key, then start selecting other non-continuous rows.

When you need to unhide a column, you
first need to select the left and right columns, alongside the hidden column.
Like, if I need to unhide the Column K, then I will first select the column J
and L, then right-click and choose Unhide.

In Excel 2016, there is a quick way to
unhide columns or rows as well. Even though you can identify the hidden columns
and rows by their column headings and row numbers, but when you hide a column
or row, you can also see a little gap between the columns and rows headings.
This gap indicates about the hidden columns or rows. So, if you double-click
the border, instantly the hidden columns or rows will be visible

If anytime you feel that you need to
unhide all the columns or rows in your worksheet, then clicking the button on
upper left corner of your worksheet will select the entire worksheet. Then
right-click on any column heading, and then choose Unhide, and this will unhide
all the columns in this worksheet. You can do exactly the same to unhide all
the hidden rows as well. Select the entire worksheet, then right-click on one
of the rows heading, and choose Unhide.

So you can hide or unhide columns and
rows for both visual, and printing purposes.


Microsoft Excel 2016 Tutorial - Page Setup and Printing Worksheets

In this video, we will cover some
basic page setup and printing options, which will be helpful for you, when you
consider printing an Excel worksheet, especially the larger once. Let’s learn
some basic concepts of Page Setup and Print Previewing. When you start working
on a new worksheet or, open a saved workbook, you might not know that either
the entire contents of your worksheet, in width particularly, are getting fit
on a single page or not, because you never have an idea, where the first page
of your worksheet is ending, and new one is beginning, because the entire
worksheet seems a single page.

Even though the entire worksheet is a
single sheet, but not when you consider printing it. So the first thing you
might always consider before start working on an Excel worksheet is, setting up
the Page. For instance, I add another worksheet in this Order Summary Workbook,
and I have no idea whatsoever that, where my first page is ending, either in
width or height. Like either my page width is up to column J or, Column M, and
the same goes with the height. There is no indication that how many rows are
available for my first page, and from where the second page is being started.
So, what you can do to get an exact
idea of the page dimensions? The easiest and simplest method of this is to, see
Print Preview right away when you create a new worksheet or open an older one.
As for this blank worksheet, I click on File menu, and then click on Print. On
the right side pane, you can see a message stating, “We didn’t find anything to
print”, or in older versions of Excel, you might see a dialog box stating,
“Microsoft Excel didn’t find anything to print”. As I already knew that this is
a new blank worksheet, then why would I will try to see a Print Preview.
Because this is a quickest method of knowing your page dimensions. As I go back
to my worksheet, you can see a dotted line between the column, I and J. That
dotted line is indicating that your first page is ending here width wise, and
if you scroll down and look over, then you can see another dotted line between
the row number 53 and 54. It is where my first page is ending height wise.
So in my opinion, this is the quickest
method, and that is what I always use while start working in a new Excel
worksheet, or when I need to see the page dimensions of an older worksheet. I
prefer pressing Control + F2 key as a shortcut to Print Preview command, or you
can also add a Print Preview button to your Quick Access toolbar. You can also
watch our previous video about Introduction to Excel interface, for mode detail
explanation about customizing Quick Access toolbar.
But you might be thinking that how
Excel decides, where to put those dotted lines. This actually depends on the
default paper size, margins, and orientation settings, and those default
settings are gathered by Excel from your printer settings. We recently had
published a video regarding Setting Up your Default Printer Settings, that you
can watch for brief reference.
So if I click on Page Layout tab form
the Ribbon, here you can see and configure various page and printer settings.
For instance, if I click on Size drop down button, you can notice here that the
default paper size is Letter. So when I press the Print Preview button, Excel
checks which paper size has been used, and according to your paper size and
dimensions the dotted line are drawn. Do note that, you must configure the same
paper size in the application that you are going to use in the printer itself.
If I choose B4 as the paper size, then I will make sure that the same B4 size
paper is available in printer tray, and as I choose the new paper size, you can
see that dotted line has moved according to the paper dimensions.
The Margins and Paper Orientation also
effect that how your worksheet will be viewed and printed. For instance, in
this Orders worksheet, I choose the Paper Size A4, and you can see the dotted
lines right away, and when I got to Margins drop down, the margins have been
set to Wide, where Excel is leaving almost 1 inch blank from all the four side
of the paper, and if I Print this worksheet, then I will actually have a print
where all the four sides of the paper will have 1-inch blank space, and that
you can also see right in the Print Preview.
If I change the margins from Wide to
Narrow, you can see the dotted lines has moved a bit further on the page, and
in the Print Preview window, you can see the blank area from the left and right
side of the page has dramatically reduce.
So setting up a right Paper Size and
Margins can help you to properly organize the contents over the sheet, and you
may have prior idea that where your sheet is ending, and do you need to change
the margins, or reduce the font size, so the contents may not go out of the
As you can see that three columns are
still going outside from the Page Width, and if I see the Print Preview, I can
imagine that how these pages are going to print. From a total of 18 pages, 9
pages are of those 3 columns only. What I want to is to adjust these 3 columns
on a single page alone.
In Microsoft Excel, there are various
methods to cover contents over the page, but a few of them are sometimes
totally ignored by the users. For this particular sheet, I can easily cover all
the contents on a single page just by changing the Page Orientation from
Portrait to Landscape, where page dimensions will rotate, the page width will
become page height, and page height will change to page width. This is the most
common method to adjust content over the page, when you have several columns to
settle. But this will also increase the total numbers of pages, like where all
the contents of this sheet could adjust into 9 pages, are now covering 14
pages. So we will see some more options, from where you can adjust the contents
without changing the page orientation.
For instance, the Order Quantity and
Product Container columns. If I scroll down to the bottom, you can see that the
column headings are unnecessarily covering larger width than the actual
contents in these columns. So what I can do here is, I can wrap the headings
down by using the Wrap Text command from the Home tab, and shift the second
part of the headings down by adjusting column width, while increasing the row
height, and even shorten the heading.
You can see that this doesn’t made any
major able effect, but you can still consider this option as sometimes a little
bit contents may be getting outside of the page. In the Region column,
Northwest Territories is covering the vast space. So what I do here is, I
select the entire column and apply Wrap Text, then reduce the column size. But
the problem here now is that the contents are hiding beneath the row height. So
to adjust all the rows at once, while the column being selected, I click the
Format button from the Cells section under Home tab, and then click Auto Fit
Row Height, and in an instance, everything is in place now.
This really has made some significant
change, but still two columns are outside the page area. The Sales column also
unnecessarily covering up a little space by showing more than two decimal
points, which I don’t want. So I select the entire column and change the
decimal point to 2 points, by applying Comma Style from Number group in Home
The last option that I can apply on
this sheet is reducing the font size. To do this, I select the entire worksheet
by clicking on the upper left corner button, and then change the font size from
11 to 8. As every column now has some extra blank space that I can reduce, but
instead of adjusting each column width manually, what I does is to use the Auto
Fit Column Width Command from the Format drop down, and here it goes.
There are still other methods that can
be used to quickly done the job, I will cover them in my next video, but what
important here in this video is to learn, the simple techniques that you can
apply almost on every worksheet. In our next video, we will be covering Page
Break Preview and Shrink To Fit options of Excel, which ultimately be doing the
same thing automatically that we have learned in this video, but you may now
have a better idea that how things go around.
So, hope you will found this video
interesting and useful. If so, then don’t forget to hit the like button, and do
share this video with your friends. Subscribe to our channel for more upcoming
tutorial videos. Thanks for watching, and take care!