Category Archives for Microsoft Excel

How to embed a Word document into an Excel workbook?

Last update: August 2018 Applies to: Excel 2019, 2016, 2013; Office 365; Windows 10, 7 and Mac OSX Here is a question we got the other day from one of our readers: I believe i have seen a Microsoft Excel worksheet that had a Word document embedded in it. Can you explain how to accomplish […]

Continue reading

How to remove password protection from Excel 2016 / 2019 workbooks?

Updated: August 2018 Applicable: Excel 2019/365/2016; Windows 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 previously set. So […]

Continue reading

How can i divide or split text between cells in Excel 2016 and 2019?

Last updated: August 2018 Applicability: Excel 2019, 2016, 2013; Office 365 and standard; Windows 7, 10 and  MAC OS X. When analyzing significant amounts of raw data in Microsoft Excel, you might find yourself in need of dividing or splitting text between different column cells. In today’s post we’ll cover three useful techniques that you […]

Continue reading

How to freeze rows and colums headings on Microsoft Excel 2016?

From time to time i receive or develop Excel spreadsheets which contains huge data tables. One of the challenges in this case is how to ensure that the first rows and columns stay visible when you scroll through the table, so it’s easier to correlate the data itself with the row/column heading. In order to […]

Continue reading

How to secure Excel worksheets and Powerpoint presentations in Office 2013 and 2016?

On the other day, one of my colleagues was asking me if there is a way to secure  Excel spreadsheets and Powerpoint presentations in Office 2013 so that others will not have access to those files. Here’s my answer: Open the Excel worksheet/Powerpoint Presentation that you would like to secure. Under File menu, select Info. […]

Continue reading

How to split worksheet cells in Excel 2013?

The other day, I was working on a statistical report in Microsoft Excel 2013 in which i had to split a cell(a column) into two. I was looking for a solution in Excel 2013 and found that the Text to Column feature serves my purpose pretty well. Here’s how to split cells in Excel (we […]

Continue reading

How to insert a form in Microsoft Excel 2013?

Sometimes you would like obtain user feedback and use it as input in your Excel worksheet logic. Using form controls such as buttons, radio buttons, labels, check boxes, combo boxes, text-field labels etc’ allows you to capture information in an easy and intuitive way. First off, you’ll need to enable the Excel 2013 Developer tab: […]

Continue reading

What program will allow me to open an xlsx file on Android, iPhone, MAC and PC?

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 […]

Continue reading