Category: Excel

If the values of one data series dwarf the values of the other data series then do not use the column chart to compare two data series. One of the most frequently asked questions in the data visualization world is “What type of chart to use to compare data in Excel”. If you want to […]

If the above solutions fail to fix your Excel not responding or crash, then you can try to uninstall and reinstall Excel, which seems to be a common solution for all crashing apps. If Excel freezes, hangs or stops responding leads to the loss of Excel files, we think you’d better use a professional data […]

To add the Gantt Chart Wizard on the ribbon, you need to: Click on File > Options to open the Project Option dialog box;Click on Customize Ribbon;In the right column under Main Tabs, right-click on the tab where the Wizard will be inserted and choose Add New Group in the context menu;The newly-added group will […]

MS Excel provides an option to hide gridlines for users who do not like them. In your case, the hide feature may have been activated by mistake. By default Excel assigns a greyish shade to the grid lines . Ensure that the color has not been changed to white. Your gridlines may have the correct […]

How to hide rows in Excel. As is the case with nearly all common tasks in Excel, there is more than one way to hide rows: by using the ribbon button, right-click menu, and keyboard shortcut. Anyway, you begin with selecting the rows you’d like to hide: To select one row, click on its heading. […]

Here are the most common ways to fix the problem. First, check to see if Excel is freezing in more than one spreadsheet. If Excel freezes in any file you open, it is likely related to the program itself. If it only happens in one file, you will have to pinpoint what exactly is causing […]

Spell checking in Excel. Excel’s spell checking is a bit different than Word’s. It does not underline the misspelled words or check grammar as you type. You need to run spell check manually unless you automate it using VBA. There are two ways to manual spell check in Excel: Pressing the F7 key or; Clicking […]

Here’s how: Share your Excel file to a local network location. Other users can now open the shared file and work with it, each person saving their own copy of the shared workbook to the same folder, but using a different file name. Add the Compare and Merge Workbooks feature to your Quick Access toolbar. […]

Calculating the elapsed time or time difference is easily done in Excel. We simply subtract the before and after time, ensuring the correct or preferred time format. This tutorial will step through the simple steps to calculate elapsed time in Excel. Moreover, can excel subtract time? As times are stored as simple decimal values, you […]

F2 – select any cell then press F2 key and hit enter to refresh formulas. F9 – recalculates all sheets in workbooks. SHIFT+F9 – recalculates all formulas in the active sheet. CTRL+ALT+F9 – force calculate open worksheets in all open workbooks including cells that have not been changed. CTRL+ALT+SHIFT+F9 – recalculates all sheets in all […]