If you have a file that is sensitive to changes, you can force Microsoft Excel 365 / 2019 to prompt the user to open as Read Only whenever they attempt to open the file. Here's how to enable this setting. … [Read more...] about Excel: Force “Open as Read Only” Prompt
Excel 2019
How to Add a PDF to Excel
Adding a PDF to Excel may sound more complicated than it really is. The good news is that it only takes a few minutes and that the steps are easy to remember. So, the next time you have to send a PDF in an Excel file, you won't have to bother anyone to do it for you. Let's see how you can add that PDF to the Excel file. … [Read more...] about How to Add a PDF to Excel
How to Insert Excel Sheet Into Word Document
Embedding a Microsoft Excel sheet into a Word document is easy – all you need to do is the copy and paste command. Use these steps. … [Read more...] about How to Insert Excel Sheet Into Word Document
Excel: Add Watermark
Watermarks are a great way to stop people from stealing your content or the results of your hard work. Thankfully, you can add them to more than just art or even your word document – even Excel supports this function. … [Read more...] about Excel: Add Watermark
Excel: Shade Every Other Row
Looking at large amounts of data can be quite straining on the eyes. Thankfully Excel has a useful function to make it easier – alternate row styling. Simply put: Zebra striping. Shading rows in alternate colours is a great way to make large amounts of data easier to work with. Don’t worry, you won’t have to colour your rows manually. You can apply it all in just a few click … [Read more...] about Excel: Shade Every Other Row
Excel: Make Header Row
Creating a sticky header row is a great tool for making it easier to keep track of data in spreadsheets. It’s easy too – look below for instructions on how to set the top row of your spreadsheet to remain stuck even as you scroll down. … [Read more...] about Excel: Make Header Row
How to Merge Sheets in Excel
When you are working in Excel, you may end up with a lot of data spread across multiple sheets within the same workbook. What happens if you need to combine that information? Sure, you could copy and paste everything. However, that is not only time consuming - it could also seriously screw up your careful formatting or your formulas. There is definitely a much easier way to … [Read more...] about How to Merge Sheets in Excel
How to Spell Check in Excel
I will always and forever be a fan of Microsoft Excel. Its suite of tools is just as powerful as those offered by the search giant. It honestly comes down to a matter of preference as to which you choose to use on a daily basis. If you have ever been stuck in an Excel spreadsheet hell as I have (more times than I care to count,) you understand how crucial it is to be sure … [Read more...] about How to Spell Check in Excel
Convert Excel Documents to PDF Format
There are numerous ways through which an Excel file can be converted to a PDF format, and there are multiple reasons why you might need to do a conversion. One of the most significant is that it is more difficult to open and read a spreadsheet program on computers, mobile phones, and tablets when it’s not in PDF. Another reason why conversion is sometimes necessary is that a … [Read more...] about Convert Excel Documents to PDF Format
How to Pin a File or Folder to the Open List in Microsoft Office to Save Time
Microsoft Windows Office is used every day by millions of people to write documents, make sheets, organize their work, and much more. Everyone who uses any program from the Office suite often returns to the same document again and again, which is why it is important to be able to a file to the open list in Microsoft Office, so you can find it any time you want. Pinning makes … [Read more...] about How to Pin a File or Folder to the Open List in Microsoft Office to Save Time