I would like to talk about a feature of Excel that was made available for the web in December last year. I hope that this feature becomes available for the desktop version as soon as possible and we can work faster in dynamic actions. But until then, we can use the drop-down lists in Excel, just like search boxes on websites or selectable dropdowns. Since this will be like bringing the web experience to the desktop, it will be cute feature that is pleasing for the eye.
MAKE YOUR DATA UNIQUE EFFORTLESSLY
With this feature, even if the data you will have in your data validation list is duplicate data in the field when you select, you will get to make them unique and create your. You will not need to use any extra dynamic array formulas (UNIQUE).
Let’s see how it works with an example.
Let’s say that we have a sales table like the one below, and we would like to have a drop-down list in cell J1 and a list of unique values in the Product Name (Ürün Ad)field. This new feature allows us to both obtain a list of unique Product Names and to select a desired data by making a search in that list.
Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.
Note: Some features listed below are not included in Excel LTSC 2021 for commercial customers. Each of those features is noted if it does not apply to Excel LTSC 2021 for commercial customers.
Co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other’s changes quickly — in a matter of seconds.
Note: Co-authoring is not available in Excel LTSC 2021.
Better collaboration with modern comments
Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.
Note: Modern comments is not available in Excel LTSC 2021.
MODERN COMMENT
Know who’s in your workbook
See who else is working along with you and where they are in the workbook.
Note: This feature is not available in Excel LTSC 2021.
WHO’S?
Visual refresh
Work with a modernized Start experience and newly refreshed tabs in the ribbon. Experience a clean, clear style with monoline iconography, neutral color palette, and softer window corners. These updates communicate action and provide features with simple visuals.
Note: Visual refresh is not available in Excel LTSC 2021.
NEW STYLE
Look left, look right… XLOOKUP is here!
Row by row, find anything you need in a table or range with XLOOKUP.
Return exact matches by default—there’s no need to specify.
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.
Similar to variables in programming, LET is accomplished through Excel’s native formula syntax.
Write one formula and return an array of values. Expedite calculations and insights with six
more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
Note: The Accessibility ribbon is not available in Excel LTSC 2021.
ACCESSIBILITY
Increase the reach of your content
Accessibility Checker keeps an eye on your documents and tells you in the status bar when it finds something you should look at. Try it by clicking Review > Check Accessibility.
ACCESSIBILITY
Performance improvements
Experience improved performance, stability, and speed across Excel.
Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
SUMIF, COUNTIF, AVERAGEIF
Unhide many sheets at the same time
No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.
We’re constantly adding more rich media content to the Office Premium Creative Content collection that helps you express yourself, such as a curated library of stock images, icons, and more.
At the top of your Microsoft Office apps on Windows, you’ll find the new Microsoft Search box. This powerful tool helps you quickly find what you’re looking for, such as text, commands, help, and more.
In this article, we will be informing you about how to rename a worksheet. Two changes that help to edit and define worksheets and the data they contain is to rename the worksheet and to change the color of the sheet tab under the work area. You will see the instruction and actions concerning this. You can take a look at our blog to find our articles about the other features.
3 ways to rename a worksheet
Double-click the sheet tab and type the new name.
Right-click the sheet tab, click Rename, and type the new name.
Use the keyboard shortcut Alt+H > O > R, and type the new name.
1- Double-click the Sheet Tab
This method works in all versions of Windows, Mac, 365 and online Excel.
Double-click on the name of the sheet tab to emphasize the name in the tab.
Type a new name for the worksheet.
Press Enter to complete renaming the worksheet.
The new name should be displayed on the sheet tab.
2- Right-click the Sheet Tab
This method works in all versions of Windows, Mac, 365 and online Excel.
Right-click the sheet tab of the worksheet you want to rename to open the context menu.
Click Rename on the menu list to emphasize the current sheet name.
Type a new name for the worksheet.
Press Enter to complete renaming the worksheet.
The new name should be displayed on the sheet tab.
3- Access the Ribbon Options with your mouse
This method works in all versions of Windows, Mac, 365 and online Excel.
Click the sheet tab of the worksheet to be renamed to make it the active page.
Click the Home tab of the ribbon.
Click Format on the Cells to open the drop-down menu.
Click Rename Sheet to emphasize the sheet tab on bottom of the screen.
Type a new name for the worksheet.
Press Enter to complete renaming the worksheet.
Things to pay attention to while naming a worksheet:
Page name cannot be blank.
It cannot consist of more than 31 characters.
It cannot contain any of these characters: / ? * : [ ] For example, 05/04/2020 cannot be a valid worksheet name but 05-04-2020 can be.
It cannot start or end with an apostrophe (‘), but it can be used between texts and numbers in the name.
It cannot be named “History“. This is a special dictionary used for special purposes within Excel.
2- Right-click the Sheet Tab