Networking & Computer Hacks, Android phone apps & Games

Friday, 25 October 2019

October 25, 2019

Frequently used shortcuts in MS Excel

Frequently used shortcuts

Frequently used shortcuts

This table lists the most frequently used shortcuts in Excel.

To do this
Press
Close a workbook
Ctrl+W
Open a workbook
Ctrl+O
Go to the Home tab
Alt+H
Save a workbook
Ctrl+S
Copy
Ctrl+C
Paste
Ctrl+V
Undo
Ctrl+Z
Remove cell contents
Delete
Choose a fill color
Alt+H, H
Cut
Ctrl+X
Go to Insert tab
Alt+N
Bold
Ctrl+B
Center align cell contents
Alt+H, A, C
Go to Page Layout tab
Alt+P
Go to Data tab
Alt+A
Go to View tab
Alt+W
Open context menu
Shift+F10, or Context key
Add borders
Alt+H, B
Delete column
Alt+H, D, C
Go to Formula tab
Alt+M
Hide the selected rows
Ctrl+9
Hide the selected columns
Ctrl+0

Wednesday, 23 October 2019

October 23, 2019

Save or convert to PDF or XPS in MS Office

Save or convert to PDF or XPS


Excel for Office 365 Word for Office 365 Publisher for Office 365 Access for Office 365 More...

You can use the Office programs to save or convert your files to PDFs so that you can share them or print them using commercial printers. And you won’t need any other software or add-ins.

Use PDF format when you want a file that:


  • Looks the same on most computers.
  • Has a smaller file size.
  • Complies with an industry format.


Examples include resumes, legal documents, newsletters, files that are intended to be read (not edited) and printed, and files that are intended for professional printing.

Windows

To export or save as PDF, in your Office file, on the File menu, click Export or Save As

Office for Mac

To save your file as a PDF in Office for Mac follow these easy steps:

Click File

Click Save As

Click File Format towards the bottom of the window
Use the File Format tool in Word's Save As to select other formats, like PDF, to save to
Select PDF from the list of available file formats

Give your file a name, if it doesn't already have one, then click Export.

iOS

To export your Word document or Excel workbook to PDF format on iOS tap the File button at the top left, choose Export and then PDF.

Tap File > Export to export your document to PDF

Portable Document Format (PDF) preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. The PDF format is also useful for documents that will be reproduced using commercial printing methods. PDF is accepted as a valid format by many agencies and organizations, and viewers are available on a wider variety of platforms than XPS.

XML Paper Specification (XPS)    is an electronic file format that preserves document formatting and enables file sharing. The XPS format ensures that when the file is viewed online or printed, it retains exactly the format that you intended, and that data in the file cannot be easily changed.

Sunday, 1 September 2019

September 01, 2019

6 ways to clean Windows 10 disk space.

6 ways to clean Windows 10 disk space.

6 ways to clean Windows 10 disk space.

Finding a third-party disk cleaning tool for Windows 10? You don't need to, Windows 10 come's with lots of pre-install cleanup tools. Follow instructions as blow.

1. Check for low disk space

  1. Select the Start  button, then select Settings  > System  > Storage .
    Open Storage settings
  2. Your drives will be listed in the Storage area. Note the amount of free space and total size for each drive.


Note

If your PC is not low on space, try the next tip.

You can use Storage Sense to delete unnecessary or temporary files from your device, which can also free up space. 
If you turn on Storage Sense, Windows will automatically free up space by getting rid of unnecessary files—including files in your recycle bin—when you're low on disk space or at intervals you specify. The instructions below show you how to delete temporary files and how to turn on and configure Storage Sense.
If you can't find Storage Sense on your device using the following steps, see the "Free up space with Disk cleanup" section below instead. 
Note

You may not want to delete temporary files to improve performance. While these files may not be used at the moment, they help your apps load and run faster.


2. Temporary files with Storage Sense

  1. Select the Start  button, then select Settings  > System  > Storage .
    Open Storage settings
  2. Select Temporary files in the storage breakdown. Note: If you don't see Temporary files listed, select Show more categories
  3. Windows will take a few moments to determine what files and apps are taking up the most space on your PC.
  4. Select the items you want to delete, and then select Remove files.
To see what's in your Recycle Bin before you empty it, open it from your desktop. If you don't see the Recycle Bin icon  on your desktop, in the search bar on the taskbar, type recycle bin, then select Recycle Bin from the list of results. 


Note

Windows moves files you delete to the Recycle Bin in case you change your mind and need them again in the future. You might be able to free up a significant amount of space by deleting Recycle Bin files to permanently remove files you've previously deleted.

3. Turn on and configure Storage Sense

  1. Select the Start  button, then select Settings  System  Storage .
    Open Storage settings
  2. In the Storage area, turn on Storage Sense.
  3. Select Configure Storage Sense or run it now.
  4. In the Storage Sense area, choose how often you want Storage Sense to run.
  5. In the Temporary Files area, select Delete temporary files that my apps aren't using
  6. Select which files you want Storage Sense to delete (your choices are files in your Recycle Bin and in your Downloads folder), then select the corresponding time intervals.
  7. Scroll down and select Clean now
  8. Windows will take a few moment to clean up your files, and then you'll see a message indicating how much disk space has been freed up.
If your system doesn't have Storage Sense, you can use the Disk Cleanup tool to delete temporary files and system files from your device.

4. Run Disk Cleanup

  1. In the search box on the taskbar, type disk cleanup, then select Disk Cleanup from the list of results.
  2. Select the checkbox next to the type of files you want to delete. (To view a description of each type of file, select the name.) By default, Downloaded Program FilesTemporary Internet Files, and Thumbnails are selected. Be sure to clear those check boxes if you don't want to delete those files.
  3. To free up even more space, select Clean up system files. Disk Cleanup will take a few moments to calculate the amount of space that a can be freed up. 
  4. Select the types of files you want to delete, select OK, then select Delete files in the confirmation window to start the cleanup.
If your PC still runs slowly, try uninstalling apps you don't use anymore.

5. Uninstall apps you don’t use anymore

  1. Select the Start  button, then select Settings  > Apps  > Apps & features.
    Open Apps & features settings
  2. Search for a specific app or sort them to see which ones are using the most space.
  3. When you find an app to remove, choose it from the list and select Uninstall.
  4. Restart your PC and and see if performance has improved.
If your PC still runs slowly, try moving files to another drive.
If you have photos, music, or other files that you want to keep but don't use often, consider saving them to removable media, like a USB drive. You'll still be able to use them when the drive is connected, but they won't take up space on your PC.

6. Move files to another drive

  1. Connect the removable media to your PC.
  2. Select File Explorer   from the taskbar and find the files you want to move.
  3. Select the files, go to Home, then select Move to > Choose location.
  4. Select your removable media from the location list, then select Move.
  5. Restart your PC and see if performance has improved.

Saturday, 31 August 2019

August 31, 2019

10 way to improve Windows 10 performance

1. Make sure you have the latest updates for Windows and device drivers
One of the best ways to get the most out of your PC is to make sure you have the latest version of Windows 10 installed. When you check for updates, your PC will also search for the latest device drivers, which can also help improve your PC’s performance.
To check for updates
1.     Select the Start  button, then select Settings  > Update & Security  > Windows Update  > Check for updates.
2.     Do one of the following:
         If the status says "You're up to date," go to the next tip.
         If the status says "Updates are available," select Install now.
3.     Select the updates you want to install, then select Install.
4.     Restart your PC and see if it seems to run better.
2. Restart your PC and open only the apps you need
Having many apps, programs, web browsers, and so on open at once can slow down your PC. Having a lot of browser tabs open at once can also slow it down quite a bit. If this is happening, close any apps, browser tabs, etc., that you don't need and see if that helps speed up your PC. If it doesn't seem to help, restart your PC and then open just the apps, programs and browser windows you need.
To restart your PC
1.     Select the Start  button, then select Power  > Restart.
2.     After your PC restarts, open just the apps you need, then close them when you’re done.
Sometimes apps that were made for an earlier version of Windows will still run on Windows 10, but they might slow down your PC. If this happens after you open a certain program, check the software company’s website for an updated version, or run the Program Compatibility Troubleshooter.
To run the Program Compatibility Troubleshooter
1.     In the search box on the taskbar, type troubleshoot, then select Troubleshoot settings, which has System settings listed underneath it.
2.     In the list of troubleshooters, select Program Compatibility Troubleshooter > Run the troubleshooter.
3.     Select the program that you’re having problems with, then select Next and continue through the troubleshooter.

3. Use ReadyBoost to help improve performance
ReadyBoost lets you use a removable drive, like a USB flash drive, to improve your PC’s performance without opening your PC and adding more memory (RAM). To use ReadyBoost, you’ll need a USB flash drive or a memory card that has at least 500 MB free and a high data transfer rate.
To use ReadyBoost        
1.     Insert the USB flash drive into a USB port on your PC.
2.     Select File Explorer  from the taskbar.
3.     Press and hold (or right-click) the USB flash drive (or SD card if you used one instead), then select Properties.
4.     Select the ReadyBoost tab, then select Use this device.
Windows determines if the device can use ReadyBoost. If it can’t, it'll let you know.
5.     After Windows determines how much free space to use to optimize memory, select OK to reserve this space so ReadyBoost can use it.
When you look at the contents of the USB flash drive in File Explorer, you’ll see a file named ReadyBoost.sfcache on the flash drive. This file shows how much space is reserved for ReadyBoost.
Note
ReadyBoost can't be used if Windows is installed on a solid state drive (SSD). An SSD is already fast, and ReadyBoost won't be able to improve its performance.
4. Make sure the system is managing the page file size
The paging file is an area on your hard disk that Windows uses like memory. There's a setting in Windows 10 that manages the page file size automatically, which can help improve your PC’s performance.
To make sure automatic page file management is turned on
1.     In the search box on the taskbar, type advanced system, and then select View advanced system settings, which has Control panel listed underneath it.
2.     In System Properties, select the Advanced tab, then select Settings in the Performance area.
3.     In Performance Options, select the Advanced tab, then select Change in the Virtual memory area.
4.     Make sure the Automatically manage paging file size for all drives check box is selected. If it is, continue to the next tip. If it's not, select it and then restart your PC by selecting the Start  button > Power  > Restart.
5. Check for low disk space and free up space
You may improve performance if you free some disk space on your PC.
To check for low disk space
1.     Select the Start button, then select Settings  > System  > Storage .
2.     Your drives will be listed in the Storage area. Note the amount of free space and total size for each drive.
Note
If your PC is not low on space, try the next tip.
You can use Storage Sense to delete unnecessary or temporary files from your device, which can also free up space.
If you turn on Storage Sense, Windows will automatically free up space by getting rid of unnecessary files—including files in your recycle bin—when you're low on disk space or at intervals you specify. The instructions below show you how to delete temporary files and how to turn on and configure Storage Sense.
If you can't find Storage Sense on your device using the following steps, see the "Free up space with Disk cleanup" section below instead.
Note
You may not want to delete temporary files to improve performance. While these files may not be used at the moment, they help your apps load and run faster.
6. Adjust the appearance and performance of Windows
Windows 10 includes many visual effects, such as animations and shadow effects. These look great, but they can also use additional system resources and can slow down your PC. This is especially true if you have a PC with a smaller amount of memory (RAM).
To adjust the visual effects in Windows
1.     In the search box on the taskbar, type performance, then select Adjust the appearance and performance of Windows in the list of results.
2.     On the Visual Effects tab, select Adjust for best performance > Apply.
3.     Restart your PC and see if that speeds up your PC.
7. Pause OneDrive syncing
Your PC settings let you choose where files will be saved by default. You can save files on your PC or to OneDrive by default and sync files between the two locations. This lets you get to your files from any device that can connect to the internet, and it helps make sure your files are backed up in case your PC is ever damaged or lost. However, files must sync between your PC and OneDrive, and syncing can slow down your PC. You can pause OneDrive syncing temporarily and see if it helps improve your PC performance.
To stop syncing to OneDrive
1.     On the taskbar, look for OneDrive  near the notification area.
2.     Select OneDrive  > More  > Pause syncing, and then choose how long you want to pause syncing your files.
3.     Restart your PC and see if your performance issues have improved with syncing paused.
4.     To resume syncing your files, select OneDrive  > More  > Resume syncing.
You can also visit Fix OneDrive sync problems to check for any sync issues.
Note
If you have Window 10 version 1709 or higher, you can use OneDrive Files On-Demand to choose which files you want to sync and always keep on your PC. This can help improve PC performance if you reduce the number of files that are synced to your PC. To see which version of Windows 10 your device is currently running, select the Start  button, then select Settings  > System  > About.
8. Disable unnecessary startup programs
When you turn on your PC, some programs start automatically and run in the background. You can disable these programs so they don’t run when your PC starts.
Many programs are designed to start automatically when Windows does. You don’t realize they're running, but they'll open quickly when you go to use them. This is helpful for programs you use a lot, but not for programs you don’t use often because it increases the time it takes Windows to start.
Find the programs that start automatically
Sometimes you can determine which programs start automatically by looking at the program icons in the notification area on the far right of the taskbar. Check there first to see if there are any programs running that you don’t want to start automatically. To try to find out the name of the program, point to the icon with your mouse pointer. Make sure you select Show hidden icons , so you don’t miss any programs.

Notification area with mouse pointing to show hidden icons
Even after you check the notification area, you might still miss some programs that run automatically at startup. Here’s how you can find all the programs that start automatically, and stop the ones that you don’t want to start automatically when Windows starts.
To stop a program from starting automatically
1.     Select the Start  button, then select Settings  > Apps  > Startup .
2.     In the Startup Apps area, find the program you want to stop from starting automatically and set it to Off.
Notes
         If you turn off a program and it continues to start automatically when Windows starts, you should scan for viruses and malware. See the next section for more info.
         To use the procedure above to stop a program from starting automatically, you need to have Windows 10 (Version 1803 or higher) installed. To see which version of Windows 10 your device is currently running, select the Start  button, then select Settings  > System  > About.
         If you have Windows 10 (Version 1709 or earlier) installed, press Ctrl + Alt + Delete, select Task Manager, select Startup, select the program you want to stop from starting automatically, then select Disable.
9. Check for and remove viruses and malware
A virus, malware, or malicious software could cause your PC to run slowly. Other symptoms include unexpected pop-up messages, programs that unexpectedly start automatically, or the sound of your hard disk constantly working.
The best way to handle viruses and malicious software is to try to prevent them by running antimalware and antivirus software and keeping it up to date. However, even if you take precautions, your PC can still become infected.
You can scan your PC for viruses or other malicious software by using Windows Security (formerly Windows Defender Security Center), which is included in Windows 10. For more info, see How to protect your Windows 10 PC.
Notes
         If you’re using other antivirus or anti-malware software, see the documentation for that program to learn how to scan for viruses. Also, make sure multiple antivirus programs aren’t running at the same time. If they are, choose the one you want to run, and then disable or uninstall any others.
         If you have another antivirus program installed and turned on, Windows Security will be turned off by default.
To scan for viruses using Windows Security (Windows 10 Version 1809 or later)
1.     Select Start   > Settings  > Update & Security  > Windows Security   and then select Open Windows Security.

2.     Select Virus & threat protection, then select Check for updates under Virus & threat protection updates.
3.     On the Protection updates screen, select Check for updates to make sure you have the most recent updates.
4.     Select Virus & threat protection, then select Quick scan.

Wait for Windows Security to finish scanning for viruses and malware.
5.     Do one of the following, depending on the results of the scan:
         Run the recommended advanced scan. This scan takes longer but searches more extensively for threats on your PC.
         If Windows Security finds a virus or malware and can’t remove or quarantine it, contact Microsoft Support for help.
         If no viruses are found, restart your PC and try to reproduce the performance problem you were having with your PC.
Note
If Windows Security doesn’t open, can’t update the definition file, or can’t finish scanning for viruses, try running Windows Defender Offline, which is explained below in To scan for malware and viruses with Windows Defender Offline (Windows 10 Version 1809 or later).
To see which version of Windows 10 your device is currently running, select the Start  button, then select Settings  > System > About.
10. Restore your PC from a system restore point
Restoring your PC undoes recent changes that might be causing problems. If you think a recently installed app, driver, or update for Windows could be causing problems, you might get things running normally again by restoring your PC to an earlier point, called a restore point.
Notes
         Restoring from a restore point won’t affect your personal files, but it will remove apps, drivers, and updates that were installed after the restore point was created.
         System restore works for changes made in the last 7 to 14 days.
To restore your PC from a restore point
1.     In the search box on the taskbar, type restore point, then select Create a restore point from the list of results.
2.     On the System Protection tab, select System Restore.
3.     Select Next, then choose the restore point related to the app, driver, or update that might be causing the problem. Then select Next > Finish.
4.     Restart your PC and see if performance has improved.
If you don’t see any restore points, it might be because system protection isn’t turned on.
To turn on system protection
1.     In the search box on the taskbar, type restore point, then select Create a restore point from the list of results.
2.     On the System Protection tab, select Configure.
3.     Select Turn on system protection > OK.

Friday, 30 August 2019

August 30, 2019

Change the default font or text color for email messages in Outlook

Change the default font or text color for email messages in Outlook


In Outlook, the default font is 11-point Calibri in black. It's used when you compose new email messages. You can change the default font and its color, size, and style — such as bold or italic.

Change the default font, color, style, and size for messages

  1. On the File tab, choose Options > Mail.
    The Outlook File tab
    Note: If you have Outlook 2007, choose the Tools menu, then choose Options > Mail Format.
  2. Under Compose messages, choose Stationery and Fonts.
  3. On the Personal Stationery tab, under New mail messages or Replying or forwarding messages, choose Font.
  4. In the Font box, choose the font, style, size, and color that you want to use. You can see a preview of your changes as you make them.
  5. Choose OK three times to return to Outlook.
Your new settings will take effect immediately.
Notes: 
  • You have to set your font preferences independently for both new messages and replies and forwards.
  • If the font that you choose isn't installed on the recipient's computer, then the recipient's mail program substitutes an available font.

Restore the initial default font style options

If you later decide you don't want to keep your custom font settings and want to return to the default settings, you can use the above steps, but choose the following values.
  • Font: +Body
  • Font style: Regular
  • Size: 11
  • Font color: Automatic

Change the font size for reading messages

You can change the size of messages in the Reading pane by using the Zoom feature.
To change the zoom level for a single message
  • Use the slider at the bottom right of the Reading pane to adjust your zoom level. As you adjust, the text size in the Reading Pane will increase or decrease.
To change the zoom level on all received messages
  1. You can now change the zoom level on all received messages. Click the percentage to the right of the Zoom slider to open the Zoom window.

    You can select your default zoom level.
  2. Select one of the default options or enter a specific percentage number.
  3. To apply this zoom level to all messages, check the Remember my preference check box and then click OK.