Category: Excel

Microsoft Excel is spreadsheet software used to calculate financial, statistical and engineering information, and is used in a wide range of places, from individual households to Fortune 500 companies. The components of Excel are cells, spreadsheets and workbooks. Microsoft Excel is handy when performing calculations. Why excel is good? Excel is a vital tool for […]

Prevent Excel from Removing Leading 0s Creating Custom Number Formats Select the cells you need to change. Open the Format window. Create a custom format. Add leading zeroes. Specify decimal places and trailing zeroes. You should be wondering “Why does 0 disappear when typing in Excel?” So you’ve typed 00198 and Excel has completely ignored […]

Microsoft Excel opens saved Excel file as blank workbook. Sometimes, when a user opens a saved workbook, it is blank. This issue is often caused when the Excel’s settings have been changed (usually inadvertently) to ignore external programs. Sometimes, when a user opens a saved workbook, it is blank. This issue is often caused when […]

If you have added an Excel file to the Google Drive or have converted an Excel file into a Google Sheets document, the macros in the Excel file WILL NOT work. While Google Sheets is trying to accommodate a lot of what an existing Excel file can have, there are still some gaps, and they […]

How to make a pie chart in Excel Select your data. From your Excel worksheet, highlight the data you want to appear in your pie. Insert the type of pie chart you want. From the Insert tab, go to the Charts command group and click the Insert Pie or Doughnut Chart icon., and quick customization. […]

Here are the top 10 career success secrets on how to excel at work., and take initiative. Be your own evaluator. Be ready to learn., and anticipate needs., and communicate well. Set goals to achieve. Show, don’t tell., and gain trust. One of the best ways to achieve career success is to keep assessing your […]

Cause: The default cell reference style (A1), which refers to columns as letters and refers to rows as numbers, was changed. Solution: Clear the R1C1 reference style selection in Excel preferences. Difference between A1 and R1C1 reference styles. By default, Excel uses the A1 reference style, which refers to columns as letters, and refers to […]

In some cases, the excel file appears blank because Microsoft Excel is not able to load the data of the file due to hardware acceleration for the graphics card. In such cases, you can fix the issue by disabling hardware acceleration. And as a result, a blank screen appears instead of the actual spreadsheet document. […]

How to Concatenate Cells in Excel Select a cell where you want to enter the formula. Type =CONCATENATE ( in that cell or in the formula bar. Press and hold Ctrl and click on each cell you want to concatenate. Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter. […]

We can do Automatic Sorting in Excel using a very simple method. This tutorial will guide all levels of Excel users on how to do automatic sorting in excel. We will select the data, copy it and paste it in another Column D. We will click on Data tab and then we will click on […]