When you create a workbook in Excel, you’ll notice that the cells have the same default size (width and height). These default dimensions are usually fine, but if you have repetitive needs to always change the columns width or rows height before any data entry, you might need to set new default values to use … Read more
Whenever you work on an Excel spreadsheet, in most cases you will need to change the size of the cells to be able to view all the content they contain. But, to do this, and due to the tabular structure of the spreadsheet, you will of course have to resize the entire column or row … Read more
This tutorial is an Excel tutorial for beginners covering all the basic features of this software. It will enable you to master Excel basics, quickly and efficiently.
You will learn how to use the Excel interface; how to create and save a workbook; how to manage Excel sheets; how to enter, edit, and format data; how to manage rows, columns, and cells; how to format cells; how to use formulas and functions; how to sort and filter data; how to create and edit charts; how to print a sheet or part of it; how to hide the ribbon, how to convert an Excel sheet to PDF; and how to customize the Quick Access Toolbar.
After this tutorial, you will no longer remain a beginner in Excel.
Excel Options is a feature that you can use to customize a lot of settings related to Excel display and behavior. In this article, I will show you where to find the Excel Options feature, what settings you can set using it, and how to fix the issue of not being able to display the … Read more
One of the Excel error messages that disrupt the user’s workflow and aren’t so easy to resolve is the “Not Enough Memory” error. In this tutorial, I will tell you when this error usually occurs, will explain the possible causes behind it, and will give you some effective steps and solutions to fix it. A- … Read more
Converting an Excel spreadsheet or workbook to a PDF has so many advantages that allow users to easily share and print them: The PDF format is universal. All modern devices, operating systems, and browsers can easily read PDF documents. So, a user that receives an Excel workbook can view it without the need of having … Read more
There are some rules for naming a cell in Excel, especially for the first character in the name, as not all characters are acceptable by Excel. So, what characters a cell name can start with or cannot in Excel? I made some experiments and got a lot of results that I organized by categories of … Read more