Category: Excel

The Excel Dashboard provides an overview of metrics and other data points in one place. In simple terms, dashboards are visual representations of data. They mostly consist of charts and graphs, thereby grabbing the user’s attention. Looking at raw Excel data can be boring. Lets see if we can figure it out. get your data […]

Excel selects multiple cells instead of one (cells are not merged) – When clicking on a cell, Excel will select multiple cells around the intended selection. The number of cells automatically selected and position of the selection is random each time the intended cell is clicked on. Another frequently asked question is “How do I […]

How to add header and footer to all or selected sheets in Excel To select multiple adjacent worksheet, click the tab of the first sheet, hold down the Shift key, and click the tab of the last sheet. To select multiple non-adjacent sheets, hold down the Ctrl key while clicking the sheet tabs individually. To […]

However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. What can you do with Microsoft Excel? Admit it, when you hear Microsoft Excel, you immediately think of calculations, formulas, graphs and tables – things […]

When you let go of the scroll bar, Excel would always jump so the top of a cell is at the top of the grid. If you start in A1 and scroll less than halfway through the cell, Excel would jump so you see the top of row 1. If you start in A1 and […]

When you add text in a formula in Excel, you have to enclose the text with quotation marks (”…”). This is useful for when you want to create a dynamic string that changes based on some conditions. But what happens when you want to put quotation marks as part of the formula’s result? In this […]

There is a character limit in Excel. Excel has a character limit (per cell) of 32,767 characters. And in most cases this is ample space for your needs. While I was researching we ran into the inquiry “Do excel cells have a character limit?”. In most cases, the limit on what can be entered in […]

Excel Macro is a record and playback tool that simply records your Excel steps and the macro will play it back as many times as you want. VBA Macros save time as they automate repetitive tasks. It is a piece of programming code that runs in an Excel environment but you don’t need to be […]

It’s what Windows 8 detractors have been clamoring for, and Microsoft has finally brought back the Start Menu. …Cortana on Desktop. Office 2019 is a one-time purchase that comes with classic apps like Word, Excel, and Power. Point for PC or Mac, and does not include any of the services that come with a Microsoft […]

The Excel backup file is created with a. XLK extension and is stored in the same location as the original. Note that the first time you save, the files will be exactly the same. If you make edits to the original file and then save it again, the backup file will still remain the same […]