Wednesday 28 January 2015

How to Free Up Space on an iPhone or iPad


ipad-air
iPads and iPhones don’t have file systems you can see, but there are still apps and files eating up space. You can see exactly what’s consuming that limited space and free it up.
Each bit of data on your device is associated with an app. For example, downloaded Kindle eBooks are tied to the Kindle app. Music files are part of the Music app, videos are part of the Videos app, and photos are part of the Photos app.

View Per-App Storage Usage


The number displayed to the right of each app includes the app’s application files, cached documents and data, and media files. Tap the app to view exactly what part of the app is using up the space.
Your device’s Usage screen shows an overview of the storage space used on your device and exactly how much each app is using. Open the Settings app, select the General category, and tap Usage to view it.
ios-7-view-storage-usage-in-settings

Delete Apps

Free up space by removing apps. Games are particularly large, so your installed games will probably appear near the top of your Usage list. Tap an app in the list and tap Delete App to remove it from your device.
You can always reinstall the app later. Just visit the app store, search for the app, and download it again. If the app uses iCloud syncing or its own user account system, your saved settings and data may be accessible even when you reinstall the app later.
delete-large-apps-and-games-to-free-up-space-on-ipad-or-iphone

Clear an App’s Documents & Data

Some apps have quite a bit of space used by their “Documents & Data.” In the screenshot below, the Pocket app itself is using up 37.4 MB, while its documents and data are using up a comparatively whopping 191 MB.
what-is-documents-and-data-in-storage-usage
An app’s Documents & Data include any documents and other files the app has downloaded or created. For example, the Pocket app’s Documents & Data include offline copies of articles in our Pocket queue. The Amazon Kindle app’s Documents & Data include any eBooks you’ve downloaded for use offline. Google Chrome’s Documents & Data include your settings and Chrome’s browser cache.
You can’t actually clear an app’s Documents & Data from this screen. Instead, you’ll need to either delete the app and reinstall it or clear the an app’s temporary data from within the app. For example, you can open the Settings screen in Pocket and tap Clear Downloaded Files to remove offline copies of downloaded articles. This will reduce the Pocket app’s Documents & Data usage. Not every app has this sort of option, so you may have to delete and reinstall an app if it’s using too much space for its temporary data.
clear-pocket-app's-documents-&-data-on-iphone-or-ipad

Delete Music, Videos, Photos, and Other Media Files

Videos, music, photos, podcasts, and other media files are stored as part of the associated app. The Music and Videos apps in the storage list show how much space music and video files are taking up on your device.
Tap the Videos app to see a list of videos taking up space. Swipe a video to the left and tap Delete to remove it from your device, freeing up space. The Podcasts app allows you to delete downloaded episodes in a similar way.
delete-videos-to-free-up-space-on-ios-7
The Music app just shows a total amount of space used by all music on your device. Swipe All Music to the left and tap Delete to remove all music from your device.
If you’d rather remove individual songs, open the Music app itself, swipe a song to the left, and tap Delete.
delete song in music app to free up space on ipad or phone
Photos work similarly. The Photos & Camera app in the Usage list displays how much storage is used by photos on your device. To actually remove these photos, you’ll need to open the Photos app, select the photos you want to delete, and tap the Delete button.
delete-photos-from-ipad-or-iphone

Erase Browsing Data

The Usage screen displays different types of browsing data when you tap the Safari app. Tap Website Data to and tap Remove All Website Data to remove cache and cookies. Swipe to the left on Offline Reading List or History and tap Delete to delete these other types of data.
clear-safari-browsing-data-on-ios-7
If you use Google Chrome, you can clear Chrome’s cache by opening the Chrome app, accessing the Settings screen, tapping Privacy, and clearing your browsing data. Chrome’s browsing data appears as Chrome’s “Documents & Data” on the Settings screen. Other third-party browsers work similarly.
clear-browser-data-in-chrome-on-ipad

If you can’t figure out how to clear an app’s documents and data, just uninstall the app and reinstall it. You may need to set up the app again afterward if it doesn’t sync its settings online.
For Apple’s own preinstalled apps, you can open the the app itself and remove content to free up space. For example, iMessage may be eating up quite a bit of space. You can open the iMessage app, locate message threads containing file or photo attachments, swipe to the left on them, and tap Delete to delete them from your device.

Tuesday 27 January 2015

What is OS X’s Launchpad and How Does it Work?


If you’re new to OS X, or even if you’re not and you’re simply used to pinning everything to the Dock, you might have wondered what Launchpad is, what it does, and how to use it.
Launchpad, for lack of a better comparison, can be thought of as the OS X equivalent of the iOS home screen, which is how you launch iOS apps. Indeed, that’s exactly what Launchpad is, an app launcher and like its iOS equivalent, it is similar in appearance and function. If you’re a traditional Windows user, you can think of Launchpad as a sort of Start screen that you don’t have to use.
To open Launchpad, you can click on its Dock icon.
If you’re using an Apple laptop, pinch on the trackpad using three fingers and your thumb or use the designated Launchpad button on your keyboard (otherwise known as F4). Finally, if you’re a keyboard ninja, use Spotlight and type it!
Once open, you’ll see all your apps arrayed in neat rows of seven. You can move apps around and arrange them so they make better sense to you. Just click and grab an app icon and drag it to its new location.
Note, at the bottom you see navigation dots. These are pages. To move between pages you can swipe left-right with two fingers on your trackpad, click the dot at the bottom of the page, or use “Command + left/right arrow” on your keyboard.
To launch an app you just click on the icon or use the arrow keys on your keyboard to navigate and “Enter” to launch. Remember, use left or right arrow to move around on a page, and “Command + arrow” to move between pages.
If you’re looking for a specific app or group of apps, you can use the search feature at the top of the page. In this example, we display every Microsoft-centric app on our system.
Any apps you install will automatically appear in Launchpad, and new apps installed from the Mac App Store get the sparkle treatment.
You can uninstall any app that you install from the Mac App Store by clicking and holding the mouse button until the apps shake and a small X appears in the upper-left corner, just like on iOS. Clicking on that X will uninstall the app.
Note, any apps that you install via the more traditional Mac method (mounting a .DMG file and then dragging the app to the Applications folder) will have to be uninstalled the same way (dragging from the Applications folder to the Trash). The ability to uninstall apps from Launchpad is a strictly Mac App Store perk.

Organizing Apps and Creating Groups

Over the course of your Mac’s lifespan, you’ll no doubt install dozens upon dozens of apps, and over time, you’ll have page upon page in Launchpad.
You can move apps around and organize them to whatever scheme works for you. Just click and drag the icon to another spot or page. If you want to create a separate page for just a few select apps, you can drag the icon over the last page and a new one will open. This works to an extent but can still be a bit unwieldy.
Better yet, if you want to organize your apps into groups, you can consolidate space so your Launchpad doesn’t stretch for page after page. To create a new app group (Apple calls them Launchpad Folders), simply drag one icon on top of another. The apps will be merged and you can click the title to change it to whatever you want.
To disband an app group, you’ll need to drag each icon out of it.
If you want to close out of of Launchpad, you can press “Escape” or tap the Launchpad key on your keyboard. You can also click anywhere outside of an app icon, use the app switcher, or pinch out on your trackpad using your three fingers and thumb.

Using Launchpad can be a cleaner, more efficient way to launch apps than simply pinning every last one to your Dock, or using the Applications folder. It’s probably not as quick as using Spotlight, but for users who prefer to navigate by mouse, or for those who are routine iOS users, Launchpad may feel a great deal more familiar and comfortable
.

How do I Insert a New Row in Excel via the Keyboard?


how-do-i-insert-a-new-row-in-excel-via-the-keyboard-00
If you are a keyboard ninja, then you hate having to move your hands from the keyboard for any reason unless there is no other option. Today’s SuperUser Q&A post provides multiple ways to help a frustrated reader keep his hands on the keyboard while using Microsoft Excel.
Today’s Question & Answer session comes to us courtesy of SuperUser—a subdivision of Stack Exchange, a community-driven grouping of Q&A web sites.

The Question

SuperUser reader jstricker wants to know how to insert new rows in Excel using a keyboard instead of a mouse:
Right-clicking on a row and selecting insert is fairly time consuming. I would rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? I am primarily interested in inserting a single row at a time, but would also be interested in answers that address inserting multiple rows at a time.
Is there an easy way to insert new rows in Excel using a keyboard?

The Answer

SuperUser contributors jstricker, ATG, KRyan, BillOer, and assylias have the answer for us. First up, jstricker:
There are two options that I am aware of and both (unfortunately) require two steps.
Option 1
  1. With a single cell selected, hit Shift + Space to select the row.
  2. Hit Control + Shift + + (Plus Sign) to insert a row above the current row.
Option 2
  1. With a single cell selected, hit Control + Shift + + (Plus Sign) to insert a row.
  2. Hit Enter to accept the default of Shift Cells Down.
If inserting many rows at once, I think the first option is the best since you can repeat the second step without having to re-select the row.
Followed by the answer from ATG:
The following keyboard shortcut will insert one row above the active cell’s row:
Press Alt + I (Insert), then press R (Row).
On personal computers, use the Keyboard Right-Click Key to emulate a right-click on the current selection.
Additional note from ATG: Substituting C for R will insert a new column.
Then the answer from KRyan:
It is worth noting that this is a sequence, not necessarily keys to be pressed simultaneously (see answer from ATG above). You can type Alt, thenI, then R and get the same effect.
Followed by the answer from BillOer:
You can also select multiple rows and then right-click to insert rows, or you can insert one row and then use Ctrl + Y as many times as you need to insert rows. If you format your spreadsheet as a table, you do not even need to worry about copying your formulas.
And our final answer from assylias:
On Windows I use:
  1. Shift + Space to select the current row.
  2. Keyboard Right-Click Key + I to insert a row.
(*) The Keyboard Right-Click Key looks like this:
how-do-i-insert-a-new-row-in-excel-via-the-keyboard-01

Saturday 24 January 2015

How to Share Files Between User Accounts on Windows, Linux, or OS X


shared-computer-with-shared-files
Your operating system provides each user account with its own folders when you set up severaldifferent user accounts on the same computer. Shared folders allow you to share files between user accounts.
This process works similarly on Windows, Linux, and Mac OS X. These are all powerful multi-user operating systems with similar folder and file permission systems.

Windows


public-folder-on-windows-7On Windows, the “Public” user’s folders are accessible to all users. You’ll find this folder under C:\Users\Public by default. Files you place in any of these folders will be accessible to other users, so it’s a good way to share music, videos, and other types of files between users on the same computer.

Libraries are hidden by default on Windows 8.1, so you’ll have to unhide them to do this.Windows even adds these folders to each user’s libraries by default. For example, a user’s Music library contains the user’s music folder under C:\Users\NAME\as well as the public music folder under C:\Users\Public\. This makes it easy for each user to find the shared, public files. It also makes it easy to make a file public — just drag and drop a file from the user-specific folder to the public folder in the library.
move-file-to-public-library-folder
These Public folders can also be used to share folders publicly on the local network. You’ll find the Public folder sharing option under Advanced sharing settings in the Network and Sharing Control Panel.
public-folder-network-sharing-settings
You could also choose to make any folder shared between users, but this will require messing with folder permissions in Windows. To do this, right-click a folder anywhere in the file system and select Properties. Use the options on the Security tab to change the folder’s permissions and make it accessible to different user accounts. You’ll need administrator access to do this.

Linux


You can use Linux’s permissions system to give other user accounts read or read-write access to specific folders. The process below is for Ubuntu 14.04, but it should be identical on any other Linux distribution using GNOME with the Nautilus file manager. It should be similar for other desktop environments, too.This is a bit more complicated on Linux, as typical Linux distributions don’t come with a special user folder all users have read-write access to. The Public folder on Ubuntu is for sharing files between computers on a network.
Locate the folder you want to make accessible to other users, right-click it, and select Properties. On the Permissions tab, give “Others” the “Create and delete files” permission. Click the Change Permissions for Enclosed Files button and give “Others” the “Read and write” and “Create and Delete Files” permissions.
create-shared-user-data-folder-on-ubuntu-linux
Other users on the same computer will then have read and write access to your folder. They’ll find it under /home/YOURNAME/folder under Computer. To speed things up, they can create a link or bookmark to the folder so they always have easy access to it.

Mac OS X

Mac OS X creates a special Shared folder that all user accounts have access to. This folder is intended for sharing files between different user accounts. It’s located at /Users/Shared.
To access it, open the Finder and click Go > Computer. Navigate to Macintosh HD > Users > Shared. Files you place in this folder can be accessed by any user account on your Mac.
mac-os-x-shared-folder

These tricks are useful if you’re sharing a computer with other people and you all have your own user accounts — maybe your kids have their own limited accounts. You can share a music library, downloads folder, picture archive, videos, documents, or anything else you like without keeping duplicate copies.

How to See Which App is Blocking Your PC from Going into Sleep Mode


image
Have you ever expected your PC to go into sleep mode only to come back and find it is still powered on? We know we certainly have, here’s how to check what’s keeping it awake.

How to See Which App is Blocking Your PC from Going into Sleep Mode

Press the Win + X keyboard combination or right click in the bottom left hand corner of your screen to bring up the Windows Tools Menu, then launch an admin command prompt.
image
When the command prompt opens, type the following command:
powercfg /requests
image
You can see from the screenshot above, that I have 1 Process (VLC Media Player) as well as 2 Drivers that are preventing my PC from going to sleep. That’s all there is to it.

How to Quickly Batch Rename Files on Windows, Mac OS X, or Linux


Windows, Mac OS X, and most Linux desktops have built-in tools for quickly renaming multiple files. Use a batch-rename tool rather than fixing them one by one.
More powerful batch-renaming features may require a third-party tool or the command line. Batch-renaming features are often integrated into third-party file managers, too.

Windows


We’ve already covered the many ways to batch-rename files on Windows. For basic batch-renaming, begin by selecting several files in Windows Explorer or File Explorer. Press Ctrl+A to select a folder full of files, use the mouse cursor to select a group, or hold Ctrl as you click to select and de-select files.

More advanced operations will need Command Prompt commands, PowerShell cmdlets, or third-party bulk-renaming tools. (Be extremely careful when downloading and running such third-party software, as there’s a good chance you could end up with adware or malware.)When you’re ready, right-click a file in the list and select Rename — or just press F2. Type a new “base name” for the files, such as My Vacation, and press Enter. The files will be renamed as My Vacation (1), My Vacation (2), and so on. This will give all those files a much more logical name, grouping them together.

Mac OS X

Mac OS X’s Finder gained its own batch-rename function in version 10.10 Yosemite. These built-in batch renaming features are much more powerful than the built-in Windows ones.
To get started, select the files you want to rename in the Finder, Ctrl-click or right-click them, and select Rename items. You’ll see a Rename dialog where you can choose between three options. Here’s what they do:
  • Replace Text: This option lets you perform a search and replace in the selected files’ names. Enter text you want to find and the text you want to replace it with. For example, you could replace the words “My Vacation” with “Paris Trip.” Or you could search for a bit of text and replace it with nothing at all, snipping that bit of text out of every file name.
  • Add Text: This option allows you to add some text to each file name. You can add the text either before or after the name.
  • Format: This is the most complicated option. You can “format” file names, using a base name and a number. This works similar to the equivalent renaming feature on Windows. You could also use the file’s associated date instead of a number. The number or date can appear before or after the base name.
This may sound a bit complicated, but it’s not too bad. You’ll see a preview of the resulting file name appear below the Rename dialog, so you can see exactly how the files will be named. Feel free to experiment!

Linux


If you’re using a KDE desktop, the standard Dolphin file manager does have this integrated. It works like the batch rename feature on WIndows. Select multiple files, right-click them, and select Rename or press F2. Enter a base name for the files, including the # symbol somewhere in it. The # symbol will be replaced by a sequential number for each file name. For example, if you enter Photo # From My Vacation.jpg, you’ll get files named “Photo 1 From My Vacation.jpg,” “Photo 2 From My Vacation.jpg,” and so on.Some Linux desktop environments come with an integrated batch-renaming tool, and some don’t. The Nautilus file manager used by Ubuntu’s Unity desktop and GNOME doesn’t have this feature built-in.
The Xfce desktop and its Thunar file manager has an easy-to-use, powerful bulk rename tool built into it. To access it, select some files in Thunar, right-click them, and click Rename. This tool can do everything from renaming files based on their audio tags, inserting a date and time, numbering files, performing a search and replace, making text uppercase or lowercase, inserting or deleting characters at a specific position in the file name, and so on.
Thunar’s interface is powerful, but it’s also fairly simple to understand. The preview of how each file’s name will look afterwards helps you experiment safely, so you can see exactly what its functions will do.
On other desktop environments, you can head to your Linux distribution’s software management program and install a bulk-rename tool. We do like Thunar’s Bulk Rename tool, even on GNOME and Unity desktops. Install Thunar on another desktop environment to get a “Bulk Rename” tool you can launch directly from your Linux desktop’s applications menu. Drag-and-drop files from your desktop’s file manager into the Bulk Rename window to start renaming them.
You can even integrate Thunar’s Bulk Rename tool into the Nautilus file manager using the Nautilus Actions tool.
As on other operaitng systems, you can also batch-rename files from the terminal. The Linux terminal is so powerful that you can batch-rename files in all sorts of ways.

Batch-renaming isn’t something every computer user needs to do regularly, but it is often useful. That batch of oddly named image files from your digital camera’s DCIM folder are prime targets for a good batch-renaming when you import them to your computer.

Friday 23 January 2015

Enable Slide To Shutdown UI For Windows 8.1


Windows 8 users may find it difficult to look for the shut down button. For reasons unknown, Windows 8 users need to go through 3 steps to locate the option to shut down. In the Windows 8.1 update, you can right click on the start menu and choose Shut Down.
Slide To Shut Down Screen
However if you are working on touchscreen devices, you might prefer enabling a (cooler) slide to shut down UI on your Windows 8.1. It also works on desktop and we’ll show you how to set it up in this quick tip.

The Slide To Shutdown UI

The Slide To Shutdown UI is an executable file found in the Windows > System 32 folder. If you double click on the SlideToShutDown.exe file you will see your lock screen rolled down half way through the screen from the top. From here, if you want to shut down your Windows, just slide downwards (but let’s not do that just yet).
Slide To Shutdown
There are a few ways we can access this Slide to Shut down option quickly: Quick Search,Pin to Start or Taskbar and if you are on desktop, by setting a keyboard shortcut.

1. Quick Search For SlideToShutdown

Because of a more powerful Search function on Windows 8, you can press your Windows key to bring out the Metro UI then type slidetoshutdown.exe and press Enter to run it.
Use Windows 8 Search

2. Pin To Start Or Taskbar

You can also pin the SlideToShutDown.exe file to the Start or Taskbar. Right-click on the file and choose pin to Start or Taskbar, and the file will show up in your Metro Launcher or at the bottom of your desktop screen where the taskbar is. To shut down just run the file, the slide to shut down.
Pin To Start or Taskbar

3. Create Shortcut On Desktop

Alternatively you can also create a shortcut to the file and place the shortcut on the desktop.
Right-click on the SlideToShutDown.exe file then choose Send to > Desktop (create shortcut). On the desktop, right-click on the SlideToShutDown shortcut and choose properties.
In the properties window, look under the Shortcut tab for the "Shortcut key:" field. Give this shut down shortcut a keyboard shortcut combination, for example Ctrl + Alt + Shift +S, and you’re done. To next time you want to slide to shutdown just press this key combo.
Create Shortcuts To Desktopa

9 Tips To Help You Keep Your Windows XP Safe After End-Of-Life


Microsoft Windows XP will no longer be receiving anymore security updates beyond April 8, 2014. What this means to most of us who are still on the 13-year-old system is that the OSwill be vulnerable to hackers taking advantage of security flaws that will never be patched.
Windows XP End Of Life
According to Net Applications30% of the world’s PCs are still running on Windows XP. That is a huge bulk of the market, a portion that cannot be neglected. Microsoft and other security vendors have been actively encouraging users to migrate to the latest OS, where security updates are regularly issued, but for some people, this is not possible.
No matter what their reasons are, even though they may run into security risk because of the ended support, there are several ways to mitigate most of risks and to reduce the chances of being attacked. Here are 9 tips to help you survive the end-of-life for Windows XP.

1. Back Up Everything, Every Time

Not a tip specific to Windows XP but a valuable one nonetheless. It should be emphasize that although the tips here will help you mitigate risk, they will not eliminate them and therefore, having a regular, working backup is crucial in case anything goes wrong.
Make sure you back up what you cannot afford to lose, properly and securely if case your XP machine runs into an exploit that could corrupt your data. XP doesn’t come with its own backup tool but there are multiple ones available online.

2. Keep Your Antivirus Updated

XP may not be getting any updates anymore but that doesn’t mean that it won’t be getting antivirus updates. The majority of security vendors will still be providing update to their software running on XP, including Microsoft’s own Microsoft Security Essentials (MSE).
Windows XP End Of Life
This won’t help you if an exploit targets a vulnerability in the operating system but will protect your system from day-to-day malware.

3. Don’t Use Internet Explorer

Internet Explorer 8 was the last version of IE to be released for Windows XP. The OS never got a newer version of the web browser so XP is stuck with an outdated and unguarded attack gateway via browser.
Windows XP End Of Life
If you are on Internet Explorer, but have the option to change to another, more modern and secure browser, consider changing to browsers like Mozilla Firefox or Google Chrome. Unlike IE, these browsers are still being maintained for XP and will be for the near future.

4. Remove Java, Adobe Flash And Reader

Many security breahes nowadays use third-party plugins as an attack vector, with Java, Adobe Flash and Adobe Reader being the usual suspects. If you are not using any of them on a regular basis, remove them completely and you will remove the biggest attack vector on your computer.
However, if you still need them because of the good work that they do, compromise by installing only the Java functions you need; opt for HTML5 or use click-to-flash add-ons to replace Adobe Flash and do consider third-party PDF readers that are available for free online.

5. Choose Your Software And Keep It Updated

Installing third-party software will always introduce a new attack vector into your PC sochoose what you install carefully. Remove those that are no longer being used. Also, make sure you keep those programs updated as developers will always add in bug fixes and patches with the latest updates.

6. Always Scan Your USB Drives Before Connecting

Perhaps the most common way to spread malware is via the unassuming USB drive. Computers you find in colleges and cybercafes are common victims of USB-transmitted malware as they are passed around unawares by one user to the next. If you have no idea where that USB drive has been, always scan it before using them with your XP machine.

7. Use A Limited Account

A study done by Avecto states that 92% of severe vulnerabilities reported by Microsoft can be mitigated by removing admin rights from your account. An attacker can only execute an exploit if they can get the access to do so and using a Limited account is the easiest to block them.
Consider creating a Limited account (find out what a Limited account is here) for your day-to-day activities as most of the time you will only be using your admin rights to install or update programs on your computer.

8. Use XP In A Virtual Machine

Here’s another reason many users are reluctant to upgrade their Windows XP to a newer OS version – they lose out on the third-party software that they are using on their Windows XP because a newer version is not available on the latest OS; or they have to repurchase a newer version.
XP Mode
If this is the case with you, consider running third-party software on a virtual machine. This will put the OS in its own self contained system within your computer. Microsoft provides a free "XP mode" for those who have Window 7 Professional and above. If you don’t have the version required, try VMware Player, which is free for personal use (you will need a copy of XP to install).

9. Disconnect From The Internet Completely

When all else fails, and you are bent on keeping your XP machine unchanged, consider cutting off all connection between your computer with the World Wide Web. If you take this route, you can ignore the majority of the tips mentioned above. If the only reason you are running XP is to support legacy software or hardware and you don’t need the internet,simply disconnect.

This will remove virtually all the ways that an attacker can exploit your computer. If they can’t reach it, they can’t attack it.

Conclusion

By following these simple tips, you will be able to reduce the risk of your XP machine being compromised. However, the best way to be safe is to move on to a modern operating system. If the newer Windows isn’t to your liking, consider switching to a Linux distro as they have advanced a lot when it comes to ease of use, plus they are generally safer than the Windows family.