Microsoft Excel (2) | EasyTweaks.com

How to embed watermarks in Office 2016 / 2019 Excel spreadsheets and PowerPoint presentations?

Last updated: September 2018 Applicability: Office 2019, 2016,2013,2010; Windows and MAC OSX Few weeks ago we received a note from a reader: Every quarter, our team creates handouts for management meetings. The process of developing the handouts is pretty elaborated and requires to collaborate in development a series of workbooks, presentations and documents. In order […]

How to embed a Word document into an Excel 2016 / 365 / 2019 workbook?

Last update: February 2019 Applies to: Excel 2019, 2016, 2013; Office 365; Windows 10, 7 and Mac OSX Dorothy wanted to understand how to insert objects into Excel spreadsheets: I believe i have seen a Microsoft Excel worksheet that had a Word document embedded in it. Can you explain how can i insert Word files […]

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

3 COMMENTS

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

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

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

How to auto spell check in Excel 2019 / 365, 2016 and 2013?

Last updated: February 2019 Applicability: Office 2019, 2016, 2013; Office 365 and Standard. Windows and MAC OSX operating systems. Here’s a question that we received a few days ago: Using Excel 2016 on Windows 10. As i am quite a fast writer i accidentally make quite a bit of spelling mistakes. For some reason i […]

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

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

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

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

Category Archives for Microsoft Excel