Skip to main content

Ubuntu – Wireless is disabled by hardware switch

· One min read

This commonly occurs right after an upgrade/update to the operating system.

  1. First thing is first – your laptop will probably have a Wireless On & Off feature which is either on the side of the laptop chassis or front usually in the form of a button or switch. If it’s off, turn it on!
  2. If the wireless is turned on and you are still getting an issue open a Terminal and type: sudo rfkill unblock wifi
  3. Press Enter
  4. You should now be able to access the wireless.

If neither of the above work – then the problem most likely is you’re wireless on & off switch and it might need to be rewired to be permanently on.

Excel – Add a space in a column of data.

· One min read

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.