Category: Excel

There’s a setting that makes Excel display formulas only instead of their results. This setting might have been enabled in your spreadsheet somehow. To change it back, use this shortcut: If an empty cell is formatted as text, then when you type the formula and hit enter, it will never show the result. You might […]

101 Excel Functions you should know 1 Date and Time Functions. Excel provides many functions to work with dates and times. 6 statistical functions, 3 information functions, 7 math functions, 5 lookup and reference functions, 8 text functions, 9 dynamic array functions, 2 engineering, or 4 logical functions too should be interesting too. Then, how […]

Things to Remember about Sort Column in Excel Don no use a blank column while using sorting in Excel. Do not hide the column in Excel while using sorting because once the column is hidden, it cannot be moved while using sorting. Enter the caption header in one row and do not merge the cell […]

Freeze rows or columns Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. To freeze the left column : Select View .. Select Freeze Panes to open a drop-down list. This immediately freezes the left column so that you can scroll the sheet […]

The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references. Using dollar sign in excel can change the referencing in the formula. Excel’s default is […]

I would then recommend learning about the most common, essential tasks in Excel: Applying conditional formatting. Using freeze panes. Learning basic formulas and functions, sorting data, and filtering dat. Another frequently asked question is “How to use Excel for beginners?”. Rows: Will be your time increments, whether that’s quarters (like Jason), months, years, etc. Columns: […]

Restore unsaved Excel files from temporary files. Click File and Open subsequently. Scroll down to bottom and click Recover Unsaved Workbooks. Then, you will see the Document Recovery panel with several unsaved files, double-click the necessary files to open it. Click Save As to save the file to the desired location. In such cases, to […]

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. One more […]

If the Excel not responding issue is resolved, you need to go to File > Options > Add-ins. Choose COM Add-ins and click Go. Clear all the checkboxes in the list and then press OK. In the first place, you need to learn how to save your work when Excel is not responding. Usually, the […]

The FILTER function in Excel is used to filter a range of data based on the criteria that you specify. The function belongs to the category of Dynamic Arrays functions. The result is an array of values that automatically spills into a range of cells, starting from the cell where you enter a formula. Can […]