Applicable to the following Office versions: 2019, 2016, 2013, 365; on Windows 7, 8 and Windows 10. Here’s a question we received from one of our readers: “I’ve just installed a new version of Office 365 in my system but it’s clearly not defined as the default program for viewing and editing of Microsoft Office … Read more
Here’s a question from Nanda: “I work as a marketing coordinator. I need to copy list of names available in an Excel spreadsheet into a file i can then import into a legacy information system we use at work. But when I copy the Excel columns to the clipboard and then paste in Notepad, it … Read more
Dorothy wanted to learn how to insert objects into her Excel spreadsheets: I believe that i have seen a Microsoft Excel worksheet that had a Word document embedded in it. Can you explain how can i insert Word files into Excel and in general how to embed file objects in Office? Just so you are … Read more
Updated: October 2019 Applicable: Microsoft Excel 2019/365/2016; Windows and macOS operating systems. Here’s a question we got: Dear Team – some time ago i have created a quite sophisticated Excel spreadsheet for my manager which i password protected for increased security. The thing is that it seems that i have forgotten the password which i … Read more
Applicability: Office 2019, 2016, 2013; Office 365 and Standard. Here’s a question that we received a few days ago: I am currently using Excel 2016 on my Windows 10 based computer. As i am quite a fast typist, i often accidentally make quite a bit of spelling mistakes. For some reason i expected that Excel … Read more
Applicable to: Office 2019, 2016, 2013; 365 or standard Here’s a question that we have received from a reader who wanted to divide an Excel column vertically: I am working on a statistical report in Microsoft Excel, using version 365. I just imported a comma separated value file into the A column and now need … Read more
Dave, who read my post on how to open a pptx file approached me with a similar question. Few days ago, a friend sent me a file with the xlsx suffix as an attachment on GMail. I access my email online via my Samsung Galaxy phone, iPAD and MAC OS X High Sierra computer. I … Read more