Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Edit a PDF - Microsoft Support
Word tells you that it's going to make a copy of the PDF and convert its contents into a format that Word can display. The original PDF won't be changed at all.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Show or hide gridlines on a worksheet - Microsoft Support
Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel. Gridlines are always applied to the whole worksheet or workbook, and can't be applied to specific cells or ranges.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
CONCAT function - Microsoft Support
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function.However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Recover an earlier version of an Office file - Microsoft Support
If the AutoRecover option is turned on, you can automatically save versions of your file while you’re working on it. How you recover something depends on when you saved it. If you’ve saved the file. Open the file you were working on.
Applies To: Excel for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, PowerPoint 2021, Excel 2019, PowerPoint 2019, Excel 2016, PowerPoint 2016
IF function – nested formulas and avoiding pitfalls
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. IF statements are incredibly robust, and form the basis of many spreadsheet models, but they are also the root cause of many spreadsheet issues.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App, Excel for Windows Phone 10
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
Change privacy settings in Windows - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Import or export text (.txt or .csv) files - Microsoft Support
Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Form controls - Microsoft Support
In the Cell link box, enter a cell reference that contains the current state of the option button.. The linked cell returns the number of the selected option button in the group of options. Use the same linked cell for all options in a group.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Sortieren von Daten in einem Bereich oder in einer Tabelle
Hinweise: Mögliche Probleme Vergewissern Sie sich, dass alle Daten als Text gespeichert sind: Wenn die Spalte, die Sie sortieren möchten, als Zahlen gespeicherte Zahlen und als Text gespeicherte Zahlen enthält, müssen Sie alle Zahlen entweder als Zahlen oder als Text formatieren.Wenn Sie dieses Format nicht anwenden, werden als Zahlen gespeicherte Zahlen vor den als Text gespeicherten ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016