Call 1300 885 420
iTandCoffee | Patient help with your personal and business technology
  • Home
  • About Us
  • Classes
  • Appointments
  • Online Content
    • Guides
    • Videos
    • Newsletter
    • Tips Library
  • Gift Vouchers
  • iTandCoffee Club
    • About the Club
    • Membership Options
    • Members Area
  • Blog
  • Contact
  • Home
  • About Us
  • Classes
  • Appointments
  • Online Content
    • Guides
    • Videos
    • Newsletter
    • Tips Library
  • Gift Vouchers
  • iTandCoffee Club
    • About the Club
    • Membership Options
    • Members Area
  • Blog
  • Contact
Search by typing & pressing enter

YOUR CART

Tips, Tricks and Articles about your Technology

iPad, iPhone, Mac, Windows, Android, Office 365, Google services, iCloud, OneDrive, Dropbox, Apps, Social Media, Zoom, and more.
Join the iTandCoffee Club to read members-only tips on this page

16/11/2020 0 Comments

How to quickly convert a whole column of numerics/non-numerics to text in Excel

Picture
Image by Pexels from Pixabay
What I love about my job is that, nearly every day, I have one of those "I didn't know that!" moments - for example, where I find out there is a quick way to do something that was otherwise quite tedious and potentially error prone.

I have regularly come across the problem in Excel where a column includes values that are generally numeric, but can also sometimes include an alphabetic character. Excel will often assume that the numeric value is number, when I really need the whole column to be treated as text. 

When this happens, it can cause problems for any formulae that try matching against the column values - if the formulae expects text, but the value stored is numeric. Changing the overall column format to text is not enough - the numeric values already in the column remain as numbers even when this is done.

In preparing one of the recent Boot Camp sessions for Microsoft Excel, I discovered that that there is such an easy way to convert a column like that so that all entries are text - with no need for formulae or copying and pasting values (which is what I used to do!)

Read More
0 Comments

1/8/2020 0 Comments

If you have an Excel file that you need to use over and over - create a Template

Picture
If you have an Excel spreadsheet that you use over an over - perhaps using the Save As function to save as a new version each time you need to re-use it - it's really worth considering saving it as a Template instead.

Read More
0 Comments

1/12/2019 0 Comments

How to print an Excel worksheet so that it fits across a single page

Picture
If you are new-ish to Excel, you may have found that printing of your Excel worksheet can be a tad challenging - working out how to ensure that the worksheet is not split across multiple pages and impossible to read.

There is a simple trick to ensuring that your worksheet's width is set to fit one page - and we have recorded a short tutorial on this topic for our iTandCoffee Club members.  
Printing Excel worksheets to fit 1 page width
Let us know your own Excel question or issue in the comments below - and we will include a 'how to' it in a future article on this blog.

Not yet a member of The iTandCoffee Club?

​Join before Christmas 2019 and you will receive an extra 3 months on your 12-month subscription - 15 months for the cost of 12!
0 Comments

28/12/2018 0 Comments

What to do if Excel won't let you edit or save a file ...

Picture
If you are running a newer version of Microsoft Excel on Windows, you can sometimes find that it stops you from editing and saving an older Excel file - or (like an iTandCoffee business client recently found) from editing and saving a temporary Excel file created by some old software that you are running

There is a way that you can adjust Excel's file protection settings to allow you to edit and save these files.  Visit the Options settings (found in the File menu). The relevant settings are found in the Trust Centre option.  

​Watch this short video for further details.

Read More
0 Comments

    Receive great articles like this 
    fortnightly to your Inbox

    Picture

    Follow us on Facebook

    iTandCoffee
    Picture

    Join the iTandCoffee Club

    ​for free content, tutorials, videos, classes, offers, discounts and more

    Join our growing community of local and online members who love learning about their technology - through FREE club sessions, remote/phone support, online tips, tricks and tutorials, special members-only offers and discounts, and more. Membership starts at only $49/year.
    Find out more about The iTandCoffee Club

    What's on at iTandCoffee ?

    Join us for a short, fun 'topic of the day' classes known as PTT sessions (Personal Training for your Technology fitness!) - these are run on a regular basis. Or join any of our other classes shown below to learn so much about your technology.
    If you have questions, why not join our The iTandCoffee Club to attend fun and informative 'user group' meetings.
    All classes are run as online classes (using Zoom) which means you can attend from anywhere.

    Archives

    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    November 2012
    October 2012
    September 2012
    August 2012
    May 2012

    Categories

    All 1800-number Accessibility Accessories Activity Monitor Adware Airdrop Airplay Airpods Alarms Alerts Android Apple-id Apple-id Apple Music Apple News Apple-pencil Apple-tv Apple Watch Apps App Store App-windows Apss Audio Autolock Automatic-downloadsupdates Backup Backups Battery Be-connected Be-connected Bigpond Big Sur Bitcoin Blockchain Bluetooth Books Boot Camp Business Buying Guide Calendar Camera Catalina Cellular Data Centrelink Channel 9 Charging Christmas Chrome Classes Client Stories Cloud Cloud-storage Club Club News Colours Contacts Continuity Control-center Control Centre Convert Cookies COVID 19 COVID-19 Cybersafety Datad777f385d3 Data Usage Delete Desktop Dictation Dock Do Not Disturb Downloads Dropbox Education El-capitan Email Emergency Emojii Entertainment Ethernet Evernote Excel Facebook Family Files Finance Finder Find-my-iDevice Fingerprint Sensor Fonts Force Reboot Forgetting Curve Fraud Free Friday Gift Ideas Google Google Flights Guides Handoff Handy Hints Hard-drive-crash Health High Sierra Home Button Homepod Home Screen Hotmail Humour ICloud ICloud Backup ICloud Drive ICloud Family ICloud Photo Library Identity Theft IMAP IMessage Imovie Instagram Internet Internet Issues Internet-options Ios Ios-11 Ios-11 Ios-12 IOS 13 IOS 14 Ios Photos Ipad Iphone IPhone 12 Iphone8 Iphone-8 Iphone Basics Iphone-calendar Iphone-settings Iphonex Iphone-x Ipod Itandcoffee Itandcoffee Club Itandcoffee News Itandcoffee Services Itandcoffee-swap-shop Itandwine Itunes Junk Keyboard Keychain Kidsandtechnology Kids And Technology Lifestyle Mac Mac-basics Mackeeper Mac-mail Mac-mail Mac-monday Macos Mac Photos Mac-photos Mac Tutorials Mac-videos Mail Malware Measure Media Medical-id Messages Microphone Microsoft Mobile Data Mobile-data Mobile Porting Mojave Multitasking My-health-record NBN Netflix Notes Notifications Number Porting Office 365 Onedrive Onenote Online-safety Online-safety Optusnet Os-x Outlook Pages Parental Controls Passwords Paypal Pdf Personal-hotspot Phishing Phone Photo Book Photo-books Photos Photos-on-mac Podcasts Popups Powerpoint Preview Printing Privacy Productivity Product Launch Publicity Publicityads57a389ac69 Purchasing-an-idevice Qa Quicktime Raise-to-wake Ransomware Reachability Reboot Recommendations Recovery Relay Reminders Remotewipe Repairs Restore Restrictions Rings Rotation-lock Router Safari Safari-favourites Samsung Santa Scam Scam Email Scams Scan Scannable Scanning School-ipad Scoopit Screen Screen-brightness Screensaver Screenshots Screen Time Scrolling Secondhand-devices Security Sell Seniors Seo Services Sessions Settings Share Shared-calendar Shop Shopping Shortcuts Sierra Signature Silent-auction Sim Siri Skype Slideover Slides Slideshow Slideshows Slow-device Slow-mac Smart-tv Sms Snapfish Socialmedia Social Media Softwareupdate Software Update Software Updates Sounds Spam Spinning-beachball Split Screen Split-view Spotlightsearch Startup Storage Storage Space Subscriptions Sunrise Switch Symbols System Preferences Task Manager Tasks Taskswitcher Task-switcher Technology Technologyarticles Technologydependency Technology-lifestyle Technology-solutions Technologytips Techsupport Telco Telcos Telstra Telstracomplaint Text Text Replacements Theft The-katering-show Thermomix Thesenior Timemachine Time-to-leave Tio Toys Trackpad Transcribe Translate Travel Travel-sim Tripadvisor Troubleshooting Tutorial Tutorials Two Factor Authentication Twofactor-authentication Two-step-verification Typing Typing Shortcuts Undo Unlock Update Updates Upgrade Uppercase Usage User Group Video Video-blog Videos Virus Voice-and-data Voicemail Voice-memos Volume Vpn Wallpaper Warnings Weather Web Browser Website Weebly Whatsapp Widgets Wifi Wi Fi Wi-Fi Wifi084d04ddac Wifi-calling Windows Windows10 Windows 10 Word Wordpress World-clock Yosemite YouTube Zoom

27 Sycamore St, Camberwell, Victoria Australia

​​Call 1300 885 420

​to book an appointment or class, or to enquire about our services and products

Seniors Card Welcome
SENIORS CARD WELCOME HERE:
Seniors Card holders qualify for a 10% discount on all classes booked and paid for online (excludes PTT sessions and classes already discounted during COVID-19 crisis). To activate the discount at the time of booking, select Redeem Coupon or Gift Certificate and enter 10OFFSEN before selecting Pay Now.
Services
Classes
Event Calendar
Private Appointments
Gift Vouchers
Phone/Email support
​Business Services
​Help for families
​Be Connected
Helping Hand
Online Content
​Newsletter
User Guides
Video tutorials/classes
Tips and Hints
​Blog
iTandCoffee Club
About the Club
Free Club Sessions
Sign In/View Account
Members Area
Prices/Policies
Prices
Privacy
Cancellations, Refunds, Returns
About iTandCoffee
Home
About
​Contact us
Testimonials
In the press
Picture
​© 2012-2021 iTandCoffee Pty Ltd. All rights reserved  ACN: 606 340 434