Ever had a bunch of next and numbers in a column and needed to separate them with a space? Follow this guide.

1. Find the column you want to add a space to and right click the column heading.
2. Left click Format Cells
3. Click Custom (bottom)
4. Now work out how many letters/words you want before a space and type: # for each character, press Space where you want a space to be and then type the rest of the # (for example for a NZ telephone number it would look like:  ### ####)
5. Click Ok to accept changes.

Note: You can preview the changes you make in the preview dialog above the custom edit field.

1. Click Start
2. Click Control Panel
3. Open Network and Sharing Center
4. Click Manage Wireless Networks (to the left)
5. Right click and remove your wireless network from the list
6. Attempt re-connection

1. Press the windows key on your keyboard
2. On the metro interface click Administrative Tools

Note: Using Server Manager, you can also select Tools (top right) to select common tasks.

1. Open Server Manager
2. Click Manage (top right)
3. Click Server Manager Properties
4. Make sure “Specify the Server Manager Data refresh period (in minutes)” is ticked
5. Type in the number of minutes you want to refresh your server(s) status.
6. Click Ok

1.  Open Server Manager
2. Click Tools (top right)
3. Click Local Security Policy
4. Navigate to Account Policies/Password Policy
5. Double click “Password must meet complexity requirements”
6. Click Disable
7. Click Ok

Note: You can also Group Policy which includes Local security policies by pressing the Windows Key+R at the same type and typing: gpedit.msc into the run dialog.