Advanced users of Microsoft Office will want to have the Developer tab showcased on the Ribbon of Word or Excel programs at all times. However, that tab is not shown by default, which means it can be ...

One of the issues with formatting charts in Excel is that there are so many menus that it's sometimes impossible to find the command you want to implement. What's more, many of the chart formatting ...

How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...

The new Analysis ToolPak is designed for complex statistical and engineering work. However, it’s not turned on by default so you need to activate it yourself when you want to use it. Go to the main ...

On the Draw tab, there are various drawing tools that you can use, namely: Select tool: Select objects such as ink, shapes, and text area. They are useful when working with objects behind the text. To ...

Microsoft Excel is full of little tricks and features that are designed to make it easier for you to set up and manage your spreadsheets. Though unlike formulas — which can be used to automatically ...

Hide everything but the working area in an Excel worksheet Your email has been sent If you’ve ever opened a Microsoft Excel workbook to find no columns, rows and/or scrollbars, this is probably why: ...