Soluții

How to uninstall quality updates on W10 using CMD

Although Windows 10 updates are meant to fix problems and improve the experience, sometimes these quality patches can cause more issues than they solve. For instance, it is not uncommon to see updates rolling out with bugs breaking features and drives, compatibility problems with software or hardware, and other issues that can negatively affect users.

[mai mult...]

How to Get Workbook Statistics in Microsoft Excel

Get Workbook Statistics in Microsoft Excel

You can view your Workbook Statistics at any point in your spreadsheet creation process, and as many times as you like. Open your Excel workbook and head to the Review tab. Click “Workbook Statistics” in the Proofing section of the ribbon.

Click Workbook Statistics on the Review tab

When the small window opens, you’ll see data for your current sheet at the top and the entire workbook at the bottom.

Workbooks Statistics in Excel

If you want details for a different sheet in your workbook, close the Workbook Statistics window by clicking “OK.” Then click the tab for the sheet that you want to see and follow the same steps listed above.

Workbooks Statistics for two sheets

Data Included in Workbook Statistics

You can see a decent amount of data with the Workbook Statistics feature. This is helpful for situations where you expect to see something in your current sheet or workbook and you don’t, or vice versa. Statistics differ slightly between the spreadsheet and the entire workbook. Also, keep in mind that most are simple counts (numbers).

Spreadsheet Statistics:

  • The end of the sheet (the last cell with data)
  • Cells with data
  • Tables and PivotTables
  • Formulas
  • Charts
  • Images and objects
  • Form controls
  • Comments and notes

Workbook Statistics:

  • Number of sheets
  • Cells with data
  • Tables and PivotTables
  • Formulas
  • Charts
  • External connections
  • Macros

You can view Workbook Statistics in Excel for Microsoft 365 on Windows and Mac as well as in Excel on the web. You can also access it in the same way on these platforms. The only difference is that Excel online does not display the complete data lists written above for sheets and workbooks.

[mai mult...]

How to Hide, Pin, and Filter Chats in Microsoft Teams

It’s easy to lose individual Microsoft Teams chats—also known as Direct Messages—in the long list of conversations. Here’s how to get control of your chats by hiding, pinning, and filtering messages in Teams.

As there’s no way to group chats like Slack, the key elements to organizing Microsoft Teams are the ability to hide a chat (so it disappears from the list), pin a chat (so that important chats are always at the top), and filter the list (so that you can find the chats you want).

[mai mult...]