30 Awesome Excel Tips and Tricks for 2023

Find and Replace Line Breaks in Cells

To show text on separate lines in an Excel worksheet cell, use a shortcut, Alt+Enter, to add a line break.

If you want to remove the line break later, use Ctrl+J in Find and Replace.

Completely uninstall Office with the uninstall support tool

Option 2 – Completely uninstall Office with the uninstall support tool

https://aka.ms/SaRA-officeUninstallFromPC

 

Uninstall Office manually

Uninstall Office for Mac

 

 

How to Split Multiple Lines in a Cell into Separate Columns

More Info here.

How to save a PowerPoint 2016/2013 file as a 2-slides-per-page PDF file

For PowerPoint 2016/2013:

1.Open your PowerPoint and click on File.

2.Click on Export, choose Create PDF/XPS Document, click Create PDF/XPS.

3.Make sure Save as type: says PDF (*.pdf), then click on Options.

4.Under Publish options, change the Publish what: drop-down to Handouts, and then change Slides per page to 2.

5.Click on OK.

6.Click Publish.

Workaround for printing slides without white edges

Excel file is locked for editing by ‘Another User’

Excel file is locked for editing by ‘Another User’ on shared network drive.

[Resolution]

1. Open a command prompt.
2. Go to that folder where the excel file resides.
3. To show hidden files, type dir /ah *
4. To delete hidden files, type del /ah ~$filename

Microsoft Word 2016 – Text missing from table cells

Please install this update (KB4011140)

Download Download update KB4011140 for 32-bit version of Word 2016
Download Download update KB4011140 for 64-bit version of Word 2016

Let Microsoft Word read out your text

Go to “File”, “Options”, “Customise Ribbon”. In the tab “Popular Commands”, select “All commands” in the drop-down menu. Now, search for the “Speak” command in the alphabetically sorted list and select it.

In other Word versions, this command can be “Voice” or “Text in voice”.

Next, choose a tab in which the “Voice” command can be located, for example, “Home” and click in the middle on the button “Add>>”. Once you have placed the new command, click on OK.

Select the text that you want Microsoft Word to read and click on the Speak icon at the toolbar.

Get Office 365 for free

Get Office 365 for free

It’s not a trial! Students and teachers are eligible for Office 365 for Education, which includes Word, Excel, PowerPoint, OneNote, and now Microsoft Teams, plus additional classroom tools.

All you need to get started is to enter a valid school email address below.

Microsoft Office 2016 Preview

http://products.office.com/…/office-2016-preview
Product key for the Office 2016 Preview
NKGG6-WBPCC-HXWMY-6DQGJ-CPQVG

Download links
Get Office 2016 Preview (32 bit)
Get Office 2016 Preview (64 bit)

To find out more, review What’s New and Known Issues for Office 2016 Preview, or visit the Office 2016 Preview Community, where you can ask questions and get answers from other Office 2016 Preview users.

Q: Can I use the Office 2016 Preview side by side with Office 2013?
A: No. You must uninstall Office 2013 before you can install the Office 2016 Preview.