Technipages

Smart phone, gadget and computer tutorials

Excel 2019

How to Merge Sheets in Excel

Posted on by Kat Armstrong Leave a Comment

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

You Might Also Like

How to Spell Check in Excel

Posted on by Kat Armstrong Leave a Comment

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

You Might Also Like

Convert Excel Documents to PDF Format

Posted on by Mona Leave a Comment

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

You Might Also Like

How to Pin a File or Folder to the Open List in Microsoft Office to Save Time

Posted on by Mona Leave a Comment

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

You Might Also Like

Important Shortcut Keys in Microsoft Excel

Posted on by Mona Leave a Comment

While using Excel is undeniably useful, both in the working environment and for home needs, most people just use it when they need to and regard it as something related to the dread of data entry. In reality, by using important shortcut keys in Microsoft Excel, you can do most tasks faster and easier, thus improving your experience. Microsoft Excel is one of the great … [Read more...] about Important Shortcut Keys in Microsoft Excel

You Might Also Like

How to Embed an Excel Worksheet Within Your Word Document

Posted on by Mona Leave a Comment

Microsoft Office is part of an incredible suite of software products from Microsoft. While many have tried to make something as suitable for office work, there are no programs that have such a wide variety and utility for everyday tasks. The native integration of one platform to the other makes the handling office work easier and allows you to do a variety of tasks, … [Read more...] about How to Embed an Excel Worksheet Within Your Word Document

You Might Also Like

How to Add Track Changes to the Excel Ribbon Menu

Posted on by Judy Sanhz Leave a Comment

After undergoing recent software updates to certain versions of Microsoft Excel in Summer 2017, Microsoft allotted Track Changes as a Legacy Feature. To facilitate ease of use, you can add it on to your Quick Access Toolbar to track every file. Alternatively, you can add the Excel ribbon via the creation of a new group and add it to this new group. Like with Word, Microsoft … [Read more...] about How to Add Track Changes to the Excel Ribbon Menu

You Might Also Like

Enable “Send to Mail Recipient” Option in Excel & Word 2019

Posted on by Mitch Bartlett 5 Comments

By default, Microsoft Excel 2019, Word 2019, and Office 365 doesn't have the useful "Send to Mail Recipient" option available on the toolbar. The option enables users to quickly access their email client to send documents. Here's how to add it. … [Read more...] about Enable “Send to Mail Recipient” Option in Excel & Word 2019

You Might Also Like

Excel 2019 & 2016: Force “Open as Read Only” Prompt

Posted on by Mitch Bartlett 9 Comments

If you have a file that is sensitive to changes, you can force Microsoft Excel 2019, 2016, or 365 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 2019 & 2016: Force “Open as Read Only” Prompt

You Might Also Like

Freeze or Unfreeze Panes, Columns, and Rows in Excel

Posted on by Mitch Bartlett 3 Comments

In Microsoft Excel 2019, 2016, and , you can freeze rows and columns so that when you scroll, those panes stay in place. This can be handy for header sections so that you can see your headers no matter where you scroll to in the spreadsheet. … [Read more...] about Freeze or Unfreeze Panes, Columns, and Rows in Excel

You Might Also Like