what is compatibility mode in Microsoft Excel

What is Excel Compatibility Mode?

Older versions of Microsoft Excel used to create files with a file type that ended in .xls. However, newer versions now use a file format that ends with .xlsx. Newer versions of Excel can open these older Excel file versions, but some older versions of Excel have trouble with the newer file format. Excel is … Read more

How to Title an Excel Spreadsheet

Giving a title to an Excel spreadsheet makes it much easier to identify the spreadsheet in the future if you need to view it or edit it. Use these steps to title an Excel spreadsheet. Open the file in Excel. Click the Page Layout tab at the top of the window. Click the small Page … Read more

How to Create a Comma Delimited File from Excel

While default files that you create in Microsoft Excel are going to be in the .xls or .xlsx file format, you have some other options. Use these steps to create a comma delimited file from Excel. Open Excel and create a new workbook. Enter the data into your cells. Click the File tab at the … Read more

Excel UPC number formatting

How to Show Excel UPC Numbers in Full

The steps in this article are going to show you how to display Excel UPC numbers in full, as opposed to the scientific notation that it displays by default. This setting will only apply to each worksheet for which you make this formatting change. It doesn’t carry over to other spreadsheets or new spreadsheets that … Read more

How to Use the Excel New Sheet Shortcut

The steps in this guide are going to show you how to use a keyboard shortcut to create a new worksheet in Microsoft Excel. An Excel workbook is the Excel file itself, while an Excel worksheet is a single spreadsheet within that workbook. You can switch between worksheets in Excel by clicking the file tabs … Read more