Category: Excel

How to Add a Series of Dates in Excel Add the first date in some cell. Select that cell, right-click on the fill handle, drag it down or across several cells, and then release. In the context menu, click Series. In the Series dialog box, choose the appropriate Date unit and enter the Step value. […]

In Excel menu go to the “Help” menu and then click on “About Microsoft Excel”. (If you do not see this option in the menu you are probably using Excel 2007 or 2010 .) When you click on “About Microsoft Excel” you will see some information on your Excel version with at the top the […]

Being a Windows program, Microsoft Excel is not natively supported on Chromebooks. However, you will be pleased to know that it is possible to use Microsoft Excel on Chromebook. Although, Chromebooks come preloaded with free software for working on spreadsheets (Google Sheets), many users still prefer using Microsoft Excel. 1 Go to Google Play Store […]

Excel icon exclamation mark Excel and many other programs use icons to visualize the file extension. If you see an icon with an exclamation mark on it, you may wonder whether the file contains an error or it’s corrupted, but you don’t have to worry, it just means that this is a macro-enabled Excel file. […]

On the Excel menu, click Preferences. Under Authoring, click General .. Clear the Use R1C1 reference style check box. The column headings now show A, B, and C, instead of 1, 2, 3, and so on. The most common answer is; muliplan was very popular on CP/M systems, but on MS-DOS systems it lost fame […]

Enter a formula that contains a built-in function. Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (.. Select the range of cells, and then type a closing parenthesis).. Press Enter to get the result. So, how to […]

Surprisingly, excel has provided with the HYPERLINK formula, where we can easily give reference to a cell to send an automatic email to the recipient (s) in Excel. The destination location may be within the existing workbook or outside the workbook. But, Excel offers the option to send emails directly from Excel itself. Suppose, you […]

You can easily check Excel version you are using by looking at the menu or the top ribbon. Open any Microsoft Excel file and look at the top left corner of the file. Depending on how the File button looks, you can easily identify the version of Excel. Another frequently asked question is “How to […]

If the Data Analysis command is not available in your version of Excel, you need to load the Analysis Tool. Pak add-in program. These instructions apply to Excel 2010, Excel 2013 and Excel 2016. Click the File tab, click Options, and then click the Add-Ins category. One of the next things we wondered was; how […]

Macro isn’t supported in Excel Online and Share, and point online. So a file with the macro may not work well in Share, and point online. If you just want to use the co-authoring feature in Share, and point online. Another common inquiry is “Can I run macros in an Excel workbook in the browser?”. […]